Restoring MySQL backup

[blacksmith]

Hi

I have a problem:

My server had problems and I had to make backup off home dir and format and reinstall everything back again.

Now I have on the backup only this files:

user_bd
user_bd/table1.MYI
user_bd/table1.MYD
user_bd/table1.frm
user_bd/table2.MYD
user_bd/table2.MYI
user_bd/table2.frm

Who can I get them back on MySQL?

Thanks

 

[ProWebUK]

They should be stored in /var/lib/mysql (the contents of that directory)

Chris

 

[S2S-Robert]

And make sure the permissions / chown are set correctly. Don't know them, but have a look at the already existing databases

 

[ProWebUK]

mysql:mysql

 

[DirectAdmin Support]

Also, you might have to

1) restart mysql
2) add users to the database so that you can access it.

John

 

[blacksmith]

Thank you all!

I have to create the user like John said, but it works fine!