hello
Is there any libraries to backup and restore mysql databses.
thanks
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 S.
On Dec 12, 10:55 am, Andrew S. [email protected] wrote:
Restore:
$ mysql -u username -ppassword < dump.sql
Regards,
Andy S.-------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
appreciate ur help
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
mysql -u username -ppassword -D dbanother < dump.sql
Regards,
Andy S.