Help me restore by database

[Dan@TT]

Hi

I had a major breakdown of the linux server 4 days ago , yesterday however I've managed with the guys from the hosting company to recover some data from the crashed hdd.

I basically got the entire httpdocs folder , including all the forum files + the complete forum database located in /var/lib/mysql/forumname

the files located in this folder /var/lib/mysql/forumname look like this:

access.frm
access.MYD
access.MYI
....

etc.

Now the server got a new HDD, everything was reinstalled from zero. I've set up the server again from Plesk CP, created a new mysql database with the same name like the old one, same username & password to access the mysql database.

After, I went to /var/lib/mysql/forumname and put back all the previously saved files and I hoped it will work.

It doesn't work. I got Database error when trying to access the forum.

What am I doing wrong ?

Daniel

[Lynne]

You may have to go into your database (through phpMyAdmin or cPanel) and repair/optimize the tables.

Do you not have an actual real backup of the site - a mysqldump?

[Dan@TT]

no. no mysqldump backup.

--------------- Added [DATE]1202752564[/DATE] at [TIME]1202752564[/TIME] ---------------

Any other hints ? I know I'm dumb for not keeping a proper database backup but I really need your help

[valdet]

If I am not wrong, those are raw database backup files, so you cannot restore them from phpmyadmin, but only from SSH.

I think your hosting guys can do that restore pretty easily.

Regards,
Val.

[bobster65]

Originally Posted by Dan@TT

Hi

I had a major breakdown of the linux server 4 days ago , yesterday however I've managed with the guys from the hosting company to recover some data from the crashed hdd.

I basically got the entire httpdocs folder , including all the forum files + the complete forum database located in /var/lib/mysql/forumname

the files located in this folder /var/lib/mysql/forumname look like this:

access.frm
access.MYD
access.MYI
....

etc.

Now the server got a new HDD, everything was reinstalled from zero. I've set up the server again from Plesk CP, created a new mysql database with the same name like the old one, same username & password to access the mysql database.

After, I went to /var/lib/mysql/forumname and put back all the previously saved files and I hoped it will work.

It doesn't work. I got Database error when trying to access the forum.

What am I doing wrong ?

Daniel

Well, the first thing that I see that your .frm .MYI and .MYD are not located in its own database directory. Each DB managed by the MySQL Server has its own database directory. This exists as a subdirectory of the data directory, with the same name as the database it represents. ie .. /var/lib/mysql/forumname/DATABASE_NAME

In your case (as described above), you have an RPM installed MySQL as the data directory is located at /var/lib/mysql/forumname so within that directory, you should have a folder for each database and within that specific DB folder is where those files should be located..

NOW, you mentioned that you "created a new mysql database with the same name like the old one" Is there now a Folder in the var/lib/mysql/forumname directory with that database name? if so, move all those .frm .MYI and .MYD files into that directory.

the .frm files are called Form Files. They describe the structure of the table (its Columns, column types, indexes and so forth)

the Data Files .MYD (MyISAM) OR .ISD (ISAM) contain the table's data -- that is, its rows

the Index files .MYI (MyISAM) OR .ISM (ISAM) contain the index trees from any indexes on the data file. The index file exists whenther or not the table has any indexes...


Let me know if you have a database sub folder for the new data base you created (or if there are any other sub folders in the /var/lib/mysql folder.

--------------- Added [DATE]1202759912[/DATE] at [TIME]1202759912[/TIME] ---------------

Originally Posted by valdet

If I am not wrong, those are raw database backup files, so you cannot restore them from phpmyadmin, but only from SSH.

I think your hosting guys can do that restore pretty easily.

Regards,
Val.

no, those are the actual files themselves that make up the database. Each table within a database exists as 3 files in the database directory (A Form File ie access.frm , a Data file ie access.MYD and a index file ie access.MYI)

[Dan@TT]

Originally Posted by valdet

If I am not wrong, those are raw database backup files, so you cannot restore them from phpmyadmin, but only from SSH.

I think your hosting guys can do that restore pretty easily.

Regards,
Val.

It's a self administered sever. They refused to help.

Originally Posted by bobster65

Well, the first thing that I see that your .frm .MYI and .MYD are not located in its own database directory. Each DB managed by the MySQL Server has its own database directory. This exists as a subdirectory of the data directory. In your case, you have an RPM installed MySQL as the data directory is located at /var/lib/mysql so within that directory, you should have a folder for each database and within that specific DB folder is where those files should be located..

NOW, you mentioned that you "created a new mysql database with the same name like the old one" Is there now a Folder in the var/lib/mysql directory with that database name? if so, move all those .frm .MYI and .MYD files into that directory.

Did exactly this. Got no luck.

the .frm files are called Form Files. They describe the structure of the table (its Columns, column types, indexes and so forth)

the Data Files .MYD (MyISAM) OR .ISD (ISAM) contain the table's data -- that is, its rows

the Index files .MYI (MyISAM) OR .ISM (ISAM) contain the index trees from any indexes on the data file. The index file exists whenther or not the table has any indexes...


Let me know if you have a database sub folder for the new data base you created (or if there are any other sub folders in the /var/lib/mysql folder.

Yes , there is a single subfolder, my new emtpy database where I put the old files.

--------------- Added [DATE]1202759912[/DATE] at [TIME]1202759912[/TIME] ---------------



no, those are the actual files themselves that make up the database. Each table within a database exists as 3 files in the database directory (A Form File ie access.frm , a Data file ie access.MYD and a index file ie access.MYI)

[bobster65]

Yes , there is a single subfolder, my new emtpy database where I put the old files.

OK, well that right there is a HUGE problem. There should be at least a folder named mysql as well and within that folder will be .frm, .MYI and MYI files that store things such as the myselq users and passwords..

THAT is HUGE issue if that is missing..

[snakes1100]

You dont need to replace the mysql folder, once mysql is installed, the folder & mysql default db will be installed and operational, you just need to set the root mysql passwd, then open your vb config.php file and add your user info back via mysql cmd line or using phpmyadmin.

[Dan@TT]

Tried both. No results. Is it possible that some files might have been transferred as corupt ?

[bobster65]

Originally Posted by Dan@TT

Tried both. No results. Is it possible that some files might have been transferred as corupt ?

Its possible..

Did you reinstall mysql as Snakes suggested? By doing that, you will at least know that all the working guts of mysql are present and working.. then it would just be a matter of creating the database again (which will create a empty subfolder in the data directory) and then put all of those files in that folder.

I just made 3 clones of my DB by simply copying all of the files out of my main DB, created 3 new DBs from phpmyadmin .. then copied all the files into those 3 new folders. The all worked perfectly.