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]