ndzlogo-1-1
0%
Loading ...

INDIA – HEADQUARTERS

INDIA

UNITED STATES

CANADA

 

Here we are going to discuss about how to restore a few tables from a database to a new empty database, the key point is that we don’t want to restore the entire database to the new database, only a few tables.

♦ Backup a table from a database

 mysqldump "databasename" tablename > "tablename".sql

♦ Restore a table to a database

 mysql "new-databasename" < "tablename".sql

Now database named as “new-databasename” is restored with the selected tables from the sql file “tablename”.sql