Category Archives: MySQL

Backup and Restore Databases in MySQL

Posted on May 26, 2007 by Zhou Renjian

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

Posted in MySQL | Comments Off on Backup and Restore Databases in MySQL