Backup MySQL

There is Two way to backup your database

One:Folder backup In windows go to xampp installation folder xampp> mysql > data > here you find your database name folder. copy it and save it . Also copy ib_logfileXX and ibdata
you can use any other computer just go to xampp installation folder xampp> mysql > data >pest it here.

Two:export database .sql backup In browser go to phpmyadmin and select your database >then in to the top mane click Export. then write a name in New template input box .then click go .you will find a file is down loaded.
you can use it any other computer then go to phpmyadmin in browser and create a database and on the top menu click Import click choose file > select this file witch is downloaded > then click go button.

https://stackoverflow.com/questions/15294830/backup-mysql-database-in-xampp

https://stackoverflow.com/questions/38759870/xampp-mysql-table-doesnt-exist-in-engine-1932

 

Chandra Oemaryadi has written 244 articles

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>