How to import tables with phpMyAdmin ?

[Anon]

Hello,

I use PHP/MySQL on an online site hosted by an French ISP.

But the ISP does not give us access to the MySQL shell. We use phpMyAdmin.

I'd like to import our database hosted by our ISP at home.

Has anyone managed to do that with phpMyAdmin ?

(without phpMyAdmin, we could process a SELECT * FROM TABLE INTO OUTFILE "file.sql", but we cannot access to that file since we don't have access to their directories)

[Anon]

just do a "structure and data" dump from phpmyadmin......copy this to notepad (or similar) and then paste this in to a version of phpmyadmin on your home machine where it says something about "type in your sql" into the textarea.

rgds,
scott d~

[Anon]

Eric, this is really easy, and is exactly why phpMyAdmin was invented.

Dump the schema and the data from your old database. The result should be a big .sql file.

FTP it from your old server to your desktop PC.

Using phpMyAdmin, create the new database on your new ISP.

Click on the new database's name when it shows up in the left rail.

In the main portion of a page you should see a window labeled " Run SQL query/queries on database" followed by the database name. You can cut/paste your SQL into the window right below that ... or, better yet, look right below it, where you're offered the option of uploading. Do that. Slick as a bunny, your SQL is uploaded from your PC and executed, loading your old schema and data into the new db.