[nzlug] Restore MySQL database

[anru chen]

sql file is a text file, just cut off the portion your need, and save
as an other sql file.

anru

On 10/6/06, Michael Dittmer <michaeld at mercury-projects.co.nz> wrote:
> Hi All
>
> I have to restore a MySQL database, except I'm having trouble. The
> command I'm using is mysql -u [username] -p [password] [wikidb] <
> [wiki_backup.sql]
>
> 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?
>
> Thanks
>
> Michael
>
> _______________________________________________
> NZLUG mailing list NZLUG at linux.net.nz
> http://www.linux.net.nz/cgi-bin/mailman/listinfo/nzlug
>