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

3D ANALYZER SETTINGS

Settings for Prince of Persia Sands of Time Works with this game, u can try wid others also which are not in above list Performance section: -force zBuffer Hardware limits: -emulate HW TnL caps -emulate Pixel shader caps ANTI-DETECT MODE section: -shaders Z-buffer section: -24 bit zbuffer(with stencil) DirectX DeviceID’s section: NVIDIA GeForce Ti4600 Configuration: VendorID : 4318 Device ID :592 Works well in the following or higher configuration -Intel 865GSA motherboard, -512 MB RAM, -Pentium D dual core 2.66 GHz processor, -No graphics card required…….. have fun.
184 comments
Read more

Choosing the Best Motherboard

We will look at the various factors you should take into account when choosing your gaming motherboard, to ensure that you choose the best motherboard for your needs.If you think of the processor as the brain of a computer, then the motherboard could be described as the central nervous system, responsible for relaying information between all the internal components. In other words, it’s the hub of the computer, where all other components connect to. Since the motherboard is so crucial to your system, buying the best motherboard you can afford is a good investment. Select Your CPU First Before choosing your motherboard, you should have already chosen your CPU. If you haven’t already doneA motherboard will generally only support one type of processor, such as a Pentium 4 or Athlon 64. Different CPUs have connectors that vary physically from one another. So you can’t accidentally plug in the wrong processor into the wrong motherboard. Also, take note that many motherboards
Post a Comment
Read more

Choosing the Best CPU for Your Gaming Computer

Picking the latest, fastest or most expensive processor on the market won’t always result in the right CPU for your particular system. Some processors are designed to work with certain motherboards, so the CPU you choose will limit the type of motherboard you can get. The CPU (Central Processing Unit) is one of the most important components in any computer system. The CPU could be described as the brains of a computer. It contains the logic circuitry that performs the instructions of the software you run. The performance of your games and other applications will be directly related to this tiny little microprocessor. The Major Players: Intel and AMD Two companies dominate the CPU market, Intel and AMD (Advanced Micro Devices). Both companies make a range of different processor models.  For example, Intel have the Core i7 and Core i5 processor models, while AMD have the Athlon and Phenom series.  The Best CPU for Gaming If you’re a basic computer user and you don’t
14 comments
Read more