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 10: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 02: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 06: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 01:46 PM.