MySQL Migration Help
 

Hello all,

Here is my situation:

I had recently "backed up" some data in a MySQL database directory, before reinstalling the OS.

Currently, I am trying to find a way to restore this database information, as I am unable to view it simply by copying the corresponding directories into my server's MySQL data directory.

Hindsight dictates that I completely did not backup the data in an appropriate fashion (e.g. exporting into .sql files then later reimporting), but I do possess the entire data set, so I am hoping there is a way to restore this properly.

If anyone can assist or suggest a way of reimporting this data (or converting it to a usable format), it'd be greatly appreciated!

Thanks

If you simply backed up the files in /var/lib/mysql/databasename/ you can restore them fairly easily. Connect to mysql and create a new database..
Stop mysql...
You'll find a newly created directory within /var/lib/mysql with the databasename you created. Copy your files from the original database into that directory and chown them to the user mysql runs as (generally mysql.mysql) -
Restart mysql
You should now be able to connect to the database you created (use databasename) and see the tables and data as root as well as grant access to any users etc that you need to access the data.

Thanks for your response.

I have tried this, and apparently the data is not read by the forum script I am using (punBB). The data appears in the phpadmin tool I use from the web, which tells me the data is there. Think I'll have to head on over to the punBB forums and see if they have a fix.

Ideally what I want to do is convert the existing data to .sql files, so I may import them into appropriate tables... but I don't even know if this will work :(