On Dec 12, 10:55 am, Andrew Stewart <b... / airbladesoftware.com> wrote:
> On 12 Dec 2007, at 11:50, Junkone wrote:
>
> > hello
> > Is there any libraries to backup and restore mysql databses.
> > thanks
>
> Backup:
>
> $ mysqldump -u username -ppassword -x --databases db1 db2 db3 > dump.sql
>
> Restore:
>
> $ mysql -u username -ppassword < dump.sql
>
> Regards,
> Andy Stewart
>
> -------http://airbladesoftware.c

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>

appreciate ur help