How to upload a *.sql to a MySQL server through PHPMyAdmin?

[Farid]

OK here's the story :

I am hosted on a shared server, so I do NOT have access to the MySQL server through Telnet. The only access I have is through PHPMyAdmin.

My database is currently on server A, and I have made a *.sql back-up of it through PHPMyAdmin (Structure + Data). Now, I want to put my database on Server B, also through PHPMyAdmin.

Is it possible to do that??? Is there a MySQL query I'm supposed to use? Do I need to copy everything field by field (my database is 20 Mb :o)? :confused:

Thank you very much.

[Mac Users Group]

In phpMyAdmin, click on the name of the database, and scroll down on the right frame. There is an upload box. Click Browse, then locate the *.sql file you wish to execute.

[Farid]

...here are the only options I have in PHPMyAdmin :

1. When I logon to PHPMyAdmin

http://www.dtourism.com/media/phpmyadmin1.gif

2. When I click on my database in the left frame

http://www.dtourism.com/media/phpmyadmin2.gif

3. And when I use the "Location of the textfile" box and hit go, it says connecting to "db_readdump.php..." then I get this screen after a while and my database remains empty :

http://www.dtourism.com/media/phpmyadmin3.gif

That's why I am clueless... :(
Any help is much appreciated!

[eva2000]

you need to ask your web host to do a mysql .sql file import via shell/telnet for you..

uploading via phpmyadmin will give your problems

[Farid]

Thanks Eva
Originally posted by eva2000
you need to ask your web host to do a mysql .sql file import via shell/telnet for you..
Unfortunately the guys at my webhost are a bunch of dumb guys... The time they copy my database, put it on server B, send me an email to tell me they did it (so I can point my forum to the database on server B), it takes them 3 days and meanwhile, I have 500 new messages in my database on server A. Moreover, I cannot afford turning off my forum for all that period of time...
Originally posted by eva2000
uploading via phpmyadmin will give you problemsBut, is it *possible* to upload it via phpMyAdmin through the options you can see in the screenshots??? :confused: I have nothing to lose in trying...