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 | Leave a comment