# Library for backup restore mysql

**URL:** <https://www.ruby-forum.com/t/library-for-backup-restore-mysql/122835>\
**Category:** Ruby\
**Created:** [December 12, 2007, 6:21pm UTC](https://www.ruby-forum.com/t/library-for-backup-restore-mysql/122835 "2007-12-12T18:21:14Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Junkone](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/e274bd/32.png) [@Junkone](https://www.ruby-forum.com/u/Junkone)\
**Post date:** [December 12, 2007, 6:21pm UTC](https://www.ruby-forum.com/t/library-for-backup-restore-mysql/122835/1 "2007-12-12T18:21:14Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Junkone](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/e274bd/32.png) [@Junkone](https://www.ruby-forum.com/u/Junkone)\
**Post date:** [December 12, 2007, 6:24pm UTC](https://www.ruby-forum.com/t/library-for-backup-restore-mysql/122835/2 "2007-12-12T18:24:48Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Junkone](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/e274bd/32.png) [@Junkone](https://www.ruby-forum.com/u/Junkone)\
**Post date:** [December 12, 2007, 10:21pm UTC](https://www.ruby-forum.com/t/library-for-backup-restore-mysql/122835/3 "2007-12-12T22:21:00Z")

</div>

On Dec 12, 10:55 am, Andrew S. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Restore:
> 
> $ mysql -u username -ppassword \< dump.sql
> 
> Regards,  
> Andy S.
> 
> -------[http://airbladesoftware.c](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

---

<div class="post-metadata">

**Author:** ![Junkone](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/e274bd/32.png) [@Junkone](https://www.ruby-forum.com/u/Junkone)\
**Post date:** [December 13, 2007, 7:29pm UTC](https://www.ruby-forum.com/t/library-for-backup-restore-mysql/122835/4 "2007-12-13T19:29:36Z")

</div>

> 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.