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 <db_username> -h <db_host> -p db_name table_name > table_name.sql
For further reference:
-
Restore
mysql -u <user_name> -p db_name mysql> source <full_path>/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