[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

library for backup restore mysql

Junkone

12/12/2007 11:47:00 AM

hello
Is there any libraries to backup and restore mysql databses.
thanks
3 Answers

Andrew Stewart

12/12/2007 3:55:00 PM

0


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://airbladeso...

Junkone

12/12/2007 9:18:00 PM

0

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://airblade...

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

Andrew Stewart

12/13/2007 6:27:00 PM

0


> 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://airbladeso...