How to restore certain tables from a full MySQLdatabase backup?
MySQL backups
M_K_Rao
9:45 am on Apr 7, 2005 (gmt 0)
I am stuck with a MySQLdatabase backup . Now I wish to restore certain tables into the database.
What are the steps to be followed?
What are the priviliges required?
The Contractor
10:59 am on Apr 7, 2005 (gmt 0)
If you received the dump of the tables you can usually run the SQL commands inside the database dump (using phpMyadmin) or while using phpMyAdmin simply upload/point it at the file on your computer. Your success and amount of work will depend on what options were used when dumping the structure/data. You normally need dba rights to create/delete tables etc.
