How to Restore Dumped Mysql Database Backup on Ubuntu

Restoring Mysql database in Ubuntu

The Mysql database can be easily Restore by executing the SQL script inside the dump file. The Mysql database dump file has the option to create table and insert into table instructions for your database
$ mysql -u YourUserName -p
mysql> create database restoreddb;
mysql> use restoredb;
mysql> .\mysql.backup;

The above code will Create the database and restore the Dumped Mysql database backup.


Related Topic How to Restore or Recovering Mysql Database on Command line
How to Create Simple Mysql Database Dump Backup on Ubuntu
The Client Server Approach for MySql Database Backup
List of Mysql Error Code and Description
How to Backup Mysql Database on Command line
SQL  ubuntu  mysql  database  

nScraps.com 2011   Privacy Policy  Terms of Service  Feedback