MySQL Database backup and restore

Backup

mysqldump -u[user_name] -p[password] [database_name]>./xxx.sql

For example:

mysqldump -uroot -plsi@2007 hiredmyway_live>./hiredmyway_live_1130.sql

Restore

mysqladmin -u[user_name] -p[password] drop [database_name]

mysqladmin -u[user_name] -p[password] create [database_name]

mysql -u[user_name] -p[password] [database_name]<./xxx.sql

For example:

mysqladmin -uroot -plsi@2007 drop hiredmyway_live;

mysqladmin -uroot -plsi@2007 create hiredmyway_live;

mysql -uroot -plsi@2007 hiredmyway_live<./hiredmyway_live_1130.sql

Gzip command

Compress

gzip [file_name which will be compressed]

Extract

gzip -dv [file_name which will be extracted]