mysql-dump
- 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
mysql-dump.txt · Last modified: 2023/03/06 11:31 by 127.0.0.1