Search code examples
mysqlphpmyadminubuntu-12.04database-backups

How to import SQL database using raw /var/lib/mysql file structure?

I need to restore a database on a fresh install, unfortunately I wasn't able to perform a proper .sql backup of my previous db, I was only able to access the filesystem so I tarballed the entire /var/lib/mysql directory.

Inside that mysql folder I see a folder with the name of the db I want to restore, but simply copying that file into /var/lib/mysql/ on my new server doesn't seem to work.

Solution

  • Maybe this may help

    1) shutdown new instance

    2) del the Stuff you copied there

    3) Start instance again

    4) create Database Command

    5) shut it down again

    6) copy your files

    7) restart mysql

    you Must use the Same version number as before