LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (http://www.linuxquestions.org/questions/linux-server-73/)
-   -   Restoring individual database from a universal dump (http://www.linuxquestions.org/questions/linux-server-73/restoring-individual-database-from-a-universal-dump-682375/)

Roosta21 11-10-2008 11:12 AM

Restoring individual database from a universal dump
 
If i backed up all data in mysql using i.e

mysqldump -u sadmin -p pass21 Customers > custback.sql

is it possible to retrieve individual databases or user from this dump?

trickykid 11-10-2008 03:42 PM

Yes, but depending on it's size, a painstakingly task. You either need to do some crafty scripting or edit it to strip out the portions you want to restore.

In the future, if you have more than one database, backup each one individually to it's own dump.

chrism01 11-10-2008 07:31 PM

Actually, Customers is your DB name (see 1st option here: http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html). Perhaps you meant can you restore individual tables?


All times are GMT -5. The time now is 12:40 PM.