HELP!!! DATABASE GONE

[dadms]

I need some help. For some reason my host had moved my site to another server. They were not able to restore the database but do have it saved in a file. The files are: (there is only 1 table in the DB)
mysql.sql
folder:mysql
folder: _games (this the name of the database)
sbmt.frm
sbmt.MYD
sbmt.MYI

Any suggestion on how to restore it. The information is there. I do have access to PHPmyadmin.

 

[sleipnir214]

Yeah, those are the standard three files MySQL uses to store a table. The table was called "sbmt", right?

Create a database on the new server, and have your HSP move those files into the directory MySQL creates for the database. There's an excellent chance the tables will automagically appear.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!