library for backup restore mysql

[Junkone]

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

 

[Andrew Stewart]

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

 

[Junkone]

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

 

[Andrew Stewart]

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