MySQL dump / restore (quick notes)

Some quick notes on dump / restore of a MySQL database.

REM DUMP A DATABASE TO FILE NOTE: the -- database option will include the CREATE DATABASE IF NOT EXISTS AND USE DATABASE COMMANDS

mysqldump --host localhost -P 3306 -u root -p --databases INFO_DB > /u99/backup/INFO_DB_new.dmp

REM DUMP A DATABASE TO FILE NOTE: the this version will NOT include the CREATE DATABASE IF NOT EXISTS AND USE DATABASE COMMANDS

mysqldump --host localhost -P 3306 -u root -p INFO_DB > /u99/backup/INFO_DB_new.dmp

REM DUMP A DATABASE TO FILE (zipped)

mysqldump --host localhost -P 3306 -u root -p --databases INFO_DB | gzip > /u99/backup/INFO_DB_new.dmp.gz

REM RESTORE A FILE

mysql --host localhost -P 3306 -u root -p < /u99/backup/INFO_DB_new.dmp

REM RESTORE A DATABASE INTO AN EXISTING DATABASE "my_dbase"

mysql --host localhost -P 3306 -u root -p my_dbase< /u99/backup/INFO_DB_new.dmp

REM RESTORE A COMPRESSED DATABASE INTO AN EXISTING DATABASE "my_dbase"

gunzip < myfile.sql.gz | mysql -u root -p my_dbase