How to Restore mysqldump to New Database

Rohan Wiese

Member
If you want to restore mysqldump to New Database then you can go with two manual process which is following:-

The process to restore a MySQL database from a backup file created by mysqldump is a simple two-step process:
  1. Create a new MySQL database using the mysqladmin utility.
mysqladmin -u root -p create mytestdatabase

2. Restore your database backup to this new database using one of several possible commands.

mysql -u root -p mytestdatabase < drupaldb-20090505.sql

If manual methods fail to restore mysqldump to New Database then you can go with professional MySQL Database Recovery software.

 
Top