[wellylug] Restore MySQL database

[Jo Booth]

On 6/10/2006, at 12:14 , David Harrison wrote:

>> The MySQL file I have is a complete dump of the server using  
>> mysqldump.
>> I only want to restore one database from the dump file.
>>
>> Does anyone know restore just a single database?
>
> The quick and dirty way is to make a copy of the backup sql file,  
> remove any references to databases you are not interested in and  
> import the file.

Heh,  was about to say that.  It's just sql in a text file,  
generally. Just get rid of the SQL commands for the other DBs.

-Jo.


Jo Booth
Executive Committee Member
Unlimited Potential
http://up.org.nz
+64 21 526684

[job hunting]