How do I restore a Database with phpmyadmin?
 

Hi, I am moving servers, and I made a dump of my db....I want to restore it on the other server, but I don't know how to use Telnet, how do I go about doing it through phpmyadmin?

Please can anyone help me? :(

Don't use phpMyAdmin, it's very unreliable for dumping / loading data.
http://www.vbulletin.com/manual/movingservers.html

(and don't bump your post every 2 hours please)

Well I did the dump thru phpmyadmin :-/

Now my account has been deleted....now will I be able to use the dump I got from phpmyadmin and use telnet and restore it?

You should be able to do that.

Also, how do I do it thru phpmyadmin anyways??

Just in case :)

Thanks

Use that box that allows you to run a query or us a text file.

Thank You...
It takes long rite?

Depends on your database size.

Hi,
I got couple of problems :(


Once few days ago, I went to do the dump in phpMyADMIN, when I clicked it, then it gave me over 10 000 lines of queries I believe. I didn't know what to do so I copied the whole thing, and pasted it into 3 text documents. One saved as .txt, one saved as .sql, and the other .bck. Well today I went to restore it, and when I tried to restore it through the little box which says use a text file, it says something sucessfully executed, no tables found.

I then attempted to add it manually, so I opened it up and started adding, it took me an hour, because I never did this before. It worked I got 36 tables. I thought there was more, but I was at the end, then I went to the admin panel, when I clicked place there were different mysql errors

What do I do