Skip to main content

Restore MySQL Database Without SQL Dump

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 🙂 🙂

Labels:

Comments

Post a Comment

Popular posts from this blog

OpenCV - Drawing a Circle with python

In this tutorial, I will show you how to draw a circle in OpenCV. OpenCV comes with lots of built-in functions that make our life easier especially when we are working on image processing .  And there is a function called circle in OpenCV which is used to draw a circle. This function takes following parameters: 1. Image : Takes an image object 2. Center : Center point coordinates 3. Radius : Radius of the circle 4. Color : Takes color in BGR format 5. Thickness : By default set to 1 (optional) 6. Line Type : By default set to 8-connected.It can also be  LINE_AA  or  4-connected  (Optional) 7. Shift:  Shifts fractional bits in the point coordinates of center and radius (Optional) Especially when we are creating closed shapes. Thickness plays an important role. Here if the negative thickness is passed in this function or any other function which creates a closed shape(rectangle, polygon, etc). Then it creates a filled shape (filled with color). Negative Thickness Filled Circle Positive ...
Post a Comment
Read more

PS3 - Dragon Ball Z Battle Of Z - RPCS3 Setting

Hi GuyZ, Today, I am going to show you, how to play PS3 games on PC using the RPCS3 Emulator. It is very easy to set up and play PS3 Games. I got to know about this emulator some time ago and I thought I should give it a try . Initially I was not sure that whether it would work or not. But at last, it worked. I found it very easy to set up and play PS3 games . Although this emulator is still in the development stage so you may encounter some errors. I haven’t got any errors. In this tutorial, I am using the PS3 PKG file. This emulator also supports dumping ps3 disc and ISO Images. Prerequisites: RPCS3 Emulator PS3 Update File Microsoft Visual C++ 2019 Redistributable PS3 .pkg and Rap File Important Tip Before downloading any game make sure it comes under the playable section of rpcs3 compatibility. To check which game you can play using RPCS3 click HERE. Games that are showing in the Playable Section are actually the games that are in running state and can be played using RPCS3 E...
Post a Comment
Read more

Basic BIOS password crack

This is a password hack but it clears the BIOS such that the next time you start the PC, the CMOS does not ask for any password. Now if you are able to bring the DOS prompt up, then you will be able to change the BIOS setting to the default. To clear the CMOS do the following: Get DOS prompt and type: DEBUG hit enter -o 70 2e hit enter -o 71 ff hit enter -q hit enter exit hit enter Restart the computer
Post a Comment
Read more