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 using – sudo cp -R test /var/lib/mysql
- Copy inno db files using – sudo cp ibdata1 ib_logfile0 ib_logfile1 /var/lib/mysql
- Make sure ownership is set to mysql. Check ownership using.
sudo ls -al - Set Ownership using following syntax
For Files – sudo chown user:group files
Ex: sudo chown mysql:mysql ibdata1 ib_logfile0 ib_logfile1
For Folders – sudo chown -R user:group folder name
Ex: sudo chown -R mysql:mysql test - Start Mysql Service – sudo service mysqld start
- Now you will able to see your databases. 🙂
Note:
For Centos and Fedora Based OS
sudo service mysqld stop
sudo service mysqld start
For Debian and Ubuntu OS
sudo service mysql stop
sudo service mysql start
Also check Reset MySQL Root Password
If you have any questions related to this article. Please leave it in comments.
And if you liked this article then please do like and share this post.
Thanks for reading 🙂 🙂