The Arcive of vBulletin Modifications Site.

How do I restore a Database with phpmyadmin? · **Released**: 03-09-2002

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?

DrkFusion · #2 03-09-2002, 04:10 PM

Please can anyone help me?

Admin · #3 03-09-2002, 06:18 PM

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)

DrkFusion · #4 03-09-2002, 07:57 PM

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?

Admin · #5 03-10-2002, 10:17 AM

You should be able to do that.

DrkFusion · #6 03-10-2002, 07:34 PM

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

Just in case

Thanks

Admin · #7 03-11-2002, 11:08 AM

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

DrkFusion · #8 03-11-2002, 04:55 PM

Thank You...
It takes long rite?

Admin · #9 03-11-2002, 05:00 PM

Depends on your database size.

DrkFusion · #10 03-12-2002, 12:13 AM

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