From: Andrew Stewart <boss@...>
Date: 2007-12-14T03:27:12+09:00
Subject: Re: library for backup restore mysql


> how do i restore the databse to a new name. for eg
> i backup  mysqldump -u username -ppassword -x --databases db1 >
> dump.sql
> i want to restore it to a new database <dbanother>

mysql -u username -ppassword -D dbanother < dump.sql

Regards,
Andy Stewart


-------
http://airbladesoftware.com