- mysqldump -t -c -u root -p DBNAME > dump.sql
- symfony doctrine:build --all
- mysql -u root -p DBNAME < dump.sql
Note2: The -t parameter removes the drop table and create table queries from the dump. It is needed if you change the structure of a table, otherwise drop table query will delete what symfony doctrine:build created.
Note3: The -c parameter adds the column names to INSERT INTO statements.
No comments:
Post a Comment