Help - Search - Members - Calendar
Full Version: restoring a database with no .sql file?
The Planet Forums > Control Panels > cPanel/WHM
Justice
My former host on another server made back-ups with all of the database files in a folder, but no .sql file. How do I turn a folder of MYI and MYD files into a restored database on my server?

Any help would be appreciated.
mickalo
QUOTE
Originally posted by Justice
My former host on another server made back-ups with all of the database files in a folder, but no .sql file. How do I turn a folder of MYI and MYD files into a restored database on my server?

Any help would be appreciated.


If all the files are intact an not corrupted, you should be able to re-create the database, then copy all the files into the database folder, IE: /var/lib/mysql/my_database/

the copy all the *.MYI and *.MYD files into the new database folder. You may need to run some checks on all tables, to make sure everything is intact and all indices are working,..etc.

Mickalo
Justice
thanks for the quick response...

you did this through ssh?
mickalo
QUOTE
Originally posted by Justice
thanks for the quick response...

you did this through ssh?

Yes.

Mickalo
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.