PDA

View Full Version : Import tables to databse by phpMyAdmin



sbox
09-03-2005, 08:05 AM
How could I import tables to databse by phpMyAdmin?
I have only *.MYD, *FRM & *.MYI files in MySQL. I would like to import those tables into a new server. After I've created a new database by web control panel, I could see the database in phpMyAdmin. But how could I import those tables (*.MYD, *MYI, *FRM)?

nobaloney
09-03-2005, 02:40 PM
If those are the only files you have then your only recourse is to copy them over the files of the same names created by DA.

Jeff

sbox
09-03-2005, 07:59 PM
I don't know the path of the those files created by DA. Where is it?
I'm using the server hosted by website company. I don't know where's the default path of those DB files.

nobaloney
09-04-2005, 05:02 PM
If you're the server administrator you can shell into the server as root, and run:

locate .MYD

If you're not, then you'll have to have your host do it for you as you won't be able to do it yourself.

Jeff