This post shows how to export a MySQL database with SQLyog then import it back to another MySQL server.
Steps:
Export MySQL Database
1. Start SQLyog
2. Tools > Backup Database As 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...
3. Browse the exported SQL File
4. Click Execute.
Done!!
Steps:
Export MySQL Database
1. Start SQLyog
2. Tools > Backup Database As 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...
3. Browse the exported SQL File
4. Click Execute.
Done!!
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. http://www.valentina-db.com/en/valentina-studio-overview
ReplyDeleteGreat Article Artificial Intelligence Projects
DeleteProject Center in Chennai
JavaScript Training in Chennai
JavaScript Training in Chennai Project Centers in Chennai
Very Helpfull!!! Thanks
ReplyDeleteIt is safe to say that you will be dbdesigner.net 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.
ReplyDeleteThese are really amazing and valuable websites you have shared with us. Thanks for the informative post.
ReplyDeleteWordPress development company in Chennai
ok bos ku
ReplyDeleteThey create and keep up the framework, sell support, administration agreements, and exclusive authorized duplicates of MySQL. Change Site URL Using MySQL
ReplyDeleteThe 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
ReplyDeleteSuch a nice post.#Thanks for sharing this kind of information valentina-studio-pro-crack You can also visit my Website ukcrack.com
ReplyDeleteThis is a really authentic and informative blog. Share more posts like this.
ReplyDeleteData Analytics Courses in Chennai
Big Data Analytics Courses in Chennai
Big Data Analytics Online Course
More impressive Blog!!! Thanks for sharing this wonderful blog with us.
ReplyDeleteDigital Marketing Course in Chennai
Online Digital Marketing Course
Digital Marketing Course in Coimbatore
Thanks for sharing this useful content. How to create stored procedure in mysql with example and 5 Career Pathways with an ITIL service transition certification Mysql Database
ReplyDeleteThanks for sharing this useful content. How to create stored procedure in mysql with example and 5 Career Pathways with an ITIL service transition certification Stored Procedure
ReplyDeleteThanks for sharing a valuable information.
ReplyDeleteBest Interior Designers in Chennai
Best Interior Decorators in Chennai
chennai renovation
flat renovation contractor services in chennai
modular kitchen in chennai
false ceiling contractor services in chennai
carpenter services in chennai