* * * root@apps:~# cat /etc/backup_mysql.sh * #!/bin/sh * echo "Creating mysql dump......" * mysqldump -p'$#DB1' bpdbgov_dynamic > /var/backup_mysql/bpdbgov_dynamic-`date +%d-%B-%Y`.sql * # * echo "dump Backup completed" * echo "======================================" * root@apps:~# * * * * ==================== * mysqldump db_name table_name > table_name.sql * Dumping from a remote database * mysqldump -u -h -p db_name table_name > table_name.sql * For further reference: * http://www.abbeyworkshop.com/howto/lamp/MySQL_Export_Backup/index.html * Restore * mysql -u -p db_name mysql> source /table_name.sql * or in one line * mysql -u username -p db_name < /path/to/table_name.sql * * Dump and restore a single table from a compressed (.sql.gz) format * Credit: John McGrath * Dump * mysqldump db_name table_name | gzip > table_name.sql.gz * Restore * gunzip < table_name.sql.gz | mysql -u username -p db_name * *