How to get mysql Database dump and restore database |

How to get mysql Database dump and restore database

1.You can use following commands for taking mysql dump in .sql format go to /var/lib/mysql search for the database whose dump you want. ls -l | grep database_name mysqldump database_name > database.sql 2. If the mysql dumpis available and you want to restore that you need to use following command for that cd /var/lib/mysql check the database name where you want to restore the mysqldump ls -l | grep database_name mysql database_name < database.sql – Like this post ? Share on your Social Networking Profile ( Facebook, Twitter & Google+ ) and get a flat 10% Recurring discount on our VPS Hosting and Dedicated Servers. Email us the shared link at : [email protected] or speak to our live chat operator now, by clicking on the “Live Chat” Scroller on the left-hand side of this page and we will provide you with the discount Coupon right away! If you enjoyed this post, please consid...

Full article: http://blog.eukhost.com/webhosting/how-to-get-mysql-datab...