source: cpc/trunk/project/bin/loadsql @ 1316

Last change on this file since 1316 was 873, checked in by goya, 12 years ago

Centralisation de la conf db

File size: 793 bytes
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
12php 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
15zcat data/sql/data.sql.gz | mysql $MYSQLID $DBNAME
16#php symfony set:Vacances
Note: See TracBrowser for help on using the repository browser.