mysqldump -u dbUser -p dbPassword YOUR_SCHEMA | gzip -9 > YOUR_SCHEMA.sql.gz
mysql -u dbUser -p dbPassword < gzip -cd YOUR_SCHEMA.sql.gz
mysqldump --default-character-set=utf8 --user=dbUser --password=dbPassword YOUR_SCHEMA | gzip -f > db.sql.gz
mysqldump -hlocalhost -udbUser -pdbPassword --skip-opt --add-drop-table YOUR_SCHEMA > YOUR_SCHEMA.sql
mysqldump -hlocalhost -udbUser -pdbPassword --skip-opt --order-byprimary --skip-dump-date --skip-comments --add-drop-table YOUR_SCHEMA > YOUR_SCHEMA.sql
mysqldump -hlocalhost -udbUser -pdbPassword --skip-add-drop-table --skip-add-locks --skip-disable-keys --skip-set-charset YOUR_SCHEMA > YOUR_SCHEMA.sql
mysqldump -hlocalhost -udbUser -pdbPassword --compact --skip-comments YOUR_SCHEMA > YOUR_SCHEMA.sql
mysqldump --user=dbUser --password=dbPassword --host=localhost --port=3306 --extended-insert=FALSE --add-drop-database=TRUE --add-drop-table=TRUE --disable-keys=TRUE --order-by-primary=TRUE --routines=TRUE --triggers=TRUE YOUR_SCHEMA > YOUR_SCHEMA.sql
mysqldump --user=dbUser --password=dbPassword --host=localhost --port=3306 --quick --single-transaction --routines --triggers --hex-blob --no-data YOUR_SCHEMA | sed -e 's/\/\*\![0-9][0-9]* *DEFINER[^\*]*\*\///g' > YOUR_SCHEMA_CREATE.sql
mysqldump --user=dbUser --password=dbPassword --host=localhost --port=3306 --no-create-info YOUR_SCHEMA | sed -e 's/\/\*\![0-9][0-9]* *DEFINER[^\*]*\*\///g' > YOUR_SCHEMA_DATA.sql
mysqldump --user=dbUser --password=dbPassword --host=localhost --port=3306 --extended-insert=FALSE --add-drop-database=TRUE --add-drop-table=TRUE --disable-keys=TRUE --order-by-primary=TRUE --routines=TRUE --triggers=TRUE YOUR_SCHEMA> YOUR_SCHEMA_BACKUP.sql
mysql --user=dbUser --password=dbPassword --host=localhost --port=3306 < YOUR_SCHEMA_CREATE.sql
mysql --user=dbUser --password=dbPassword --host=localhost --port=3306 --database=YOUR_SCHEMA < YOUR_SCHEMA_DATA.sql
Comments
Post a Comment