Today in this article “ Restore MySQL Database Without SQL Dump ” we will discuss how you can restore your database when you don’t have SQL dump file. This happens when your MYSQL gets corrupted. In that case, if you want to make a back up of your database you can simply copy following files and then restore them after a fresh installation Let’s Start Generally MySQL gets installed on following location /var/lib/mysql On this location it create folders of your databases. For instance, if you have databases like test, test1, test2 Then on this location /var/lib/mysql – You will have three folders test, test1, test2. And each of these folders will contain database files for the MyISAM database. It will have three main files with the following extensions frm myi myd And another three files which will be inside in /var/lib/mysql. These files are for INNO DB database. ibdata1 ib_logfile0 ib_logfile1 Steps: Stop Mysql Service using – sudo service mysqld stop Copy folder to /var/lib/mysql
This blog includes computer hacks,tips and tricks,gaming hacks and many more stuff.