Page 1 of 1

Restoring Old Database Table

Posted: Mon Feb 28, 2005 5:40 pm
by Jon the Great
When I went to switch my phpbb board from one web host to another, like an idiot I just downloaded all the database files to my hard drive instead of looking for a way to download them together in .sql format. So now I've got a bunch of .myi, .myd, and .frm files sitting around and I'm looking for a way to condense them into a .sql file. Anyone ever done this before?

Screenshots of the files I have
Table:
http://tinypic.com/1yr15c
MySQL:
http://tinypic.com/1yr240

How would I go about jamming all of those files into the .sql format that phpbb uses for restorations?
Any help would be much appreciated. :)

Posted: Mon Feb 28, 2005 8:50 pm
by DCrazy
In the future use mysqldump. :P

Temporarily, shut down mysql and move your existing .myi, .myd, and .frm files out of the data directory, then upload the old files. Then use mysqldump to extract all the data to a .sql, and revert the data files.

Posted: Tue Mar 01, 2005 8:18 pm
by Jon the Great
Thanks, I'll try that as soon as I get more time to work on this. :)