| Line | |
|---|
| 1 | #!/bin/bash |
|---|
| 2 | . bin/db.inc |
|---|
| 3 | |
|---|
| 4 | #echo "SET FOREIGN_KEY_CHECKS = 0;" > /tmp/drop.sql |
|---|
| 5 | #echo "SET FOREIGN_KEY_CHECKS = 0;" > /tmp/delete.sql |
|---|
| 6 | #echo "SHOW TABLES" | mysql $MYSQLID $DBNAME | grep -v Tables_ > /tmp/tables.sql |
|---|
| 7 | #cat /tmp/tables.sql | sed 's/^/DROP TABLE /' | sed 's/$/;/' >> /tmp/drop.sql |
|---|
| 8 | #cat /tmp/drop.sql | mysql $MYSQLID $DBNAME |
|---|
| 9 | #cat /tmp/tables.sql | sed 's/^/CREATE TABLE /' | sed 's/$/;/' > /tmp/create.sql |
|---|
| 10 | #cat /tmp/create.sql | mysql $MYSQLID $DBNAME |
|---|
| 11 | #cat /tmp/tables.sql | sed 's/^/DELETE FROM /' | sed 's/$/;/' >> /tmp/delete.sql |
|---|
| 12 | php symfony doctrine:build-all-reload --no-confirmation |
|---|
| 13 | #cat /tmp/delete.sql | mysql $MYSQLID $DBNAME |
|---|
| 14 | #rm /tmp/tables.sql /tmp/drop.sql /tmp/create.sql /tmp/delete.sql |
|---|
| 15 | zcat data/sql/data.sql.gz | mysql $MYSQLID $DBNAME |
|---|
| 16 | #php symfony set:Vacances |
|---|
Note: See
TracBrowser
for help on using the repository browser.
