Monday, March 18, 2013

Import/Export MySQL database with SQLyog

This post shows how to export a MySQL database with SQLyog then import it back to another MySQL server.

Export MySQL Database
1. Start SQLyog
2. Tools > Backup Database As SQL Dump ...
sqlyog - SQL Dump

3. in the SQL Dump dialog, choose options or keep default
    a) Export as SQL
    b) Database name
    c) Export to file (file location)
    d) Objects
    e) Options having on source
    f) Options written to file
4. click Export.

Import MySQL Database
1. Start SQLyog
2. Tools > Execute SQL Script...
sqlyog - Execute Query(s) From A File
3. Browse the exported SQL File
4. Click Execute.



  1. Take a look on free tool Valentina Studio, is the best way to transform your data into meaningful information; create, administer, query and explore Valentina DB, MySQL, Postgre and SQLite databases for free on 32/64 bit Windows, Linux and Mac OS X.

  2. Very Helpfull!!! Thanks

  3. It is safe to say that you will be prepared to explain to your administration and friends why things need to change and how they are going to turn out? In the event that not, at that point read on.

  4. These are really amazing and valuable websites you have shared with us. Thanks for the informative post.
    WordPress development company in Chennai

  5. They create and keep up the framework, sell support, administration agreements, and exclusive authorized duplicates of MySQL. Change Site URL Using MySQL

  6. The article looks magnificent, but it would be beneficial if you can share more about the suchlike subjects in the future. Keep posting. Shipping Containers For Sale



Related Posts Plugin for WordPress, Blogger...