Restoring Old Database Table

Jon the Great · Post by **Jon the Great** » Mon Feb 28, 2005 5:40 pm

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.

DCrazy · Post by **DCrazy** » Mon Feb 28, 2005 8:50 pm

In the future use mysqldump.

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.

Jon the Great · Post by **Jon the Great** » Tue Mar 01, 2005 8:18 pm

Thanks, I'll try that as soon as I get more time to work on this.