Backup and Restore Databases in MySQL
Saturday, May 26th, 2007Just simple as following:
mysqldump -h host -u user -p –databases db > dbbackup
mysqldump -h host -u user -p
CREATE DATABASE restored;
mysql -h host -p -u user restored < dbbackup
Just simple as following:
mysqldump -h host -u user -p –databases db > dbbackup
mysqldump -h host -u user -p
CREATE DATABASE restored;
mysql -h host -p -u user restored < dbbackup