PDA

View Full Version : How do I restore a Database with phpmyadmin?

DrkFusion
03-09-2002, 02:34 PM
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
03-09-2002, 04:10 PM
Please can anyone help me? :(
Admin
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
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
03-10-2002, 10:17 AM
You should be able to do that.
DrkFusion
03-10-2002, 07:34 PM
Also, how do I do it thru phpmyadmin anyways??

Just in case :)

Thanks
Admin
03-11-2002, 11:08 AM
Use that box that allows you to run a query or us a text file.
DrkFusion
03-11-2002, 04:55 PM
Thank You...
It takes long rite?
Admin
03-11-2002, 05:00 PM
Depends on your database size.
DrkFusion
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
TECK
03-12-2002, 04:33 AM
use telnet. you will be save all the time. i just dont trust phpMyAdmin. the queries that i run.. i do it with my own little script, or EMS.. not the phpMyAdmin.
Admin
03-12-2002, 09:21 AM
phpMyAdmin is safe to use with small queries, nakkid. The problem with it is it's a Web based application, and as such it has timeout limitations. For running a simple UPDATE query it's great, but when you're dealing with thousands of records it will most likely time out in the middle and you'll be stuck with half-a-database.
DrkFusion
03-13-2002, 02:37 AM
err my host can't give me Telnet access :(

What do I do?

I uploaded the db to a site, and then in the upload from text file, I put in the URL, it did it faster, but it says no Tables Found
cditty
03-13-2002, 02:41 AM
I would suggest going with the EMS program that Nakkid suggested. It has a 30 trial period.

Does your current host not have some sort of import feature for you?

Chris
DrkFusion
03-13-2002, 07:31 PM
Uhh where can I get EMS
DrkFusion
03-13-2002, 07:33 PM
But it says no tables found :(
cditty
03-13-2002, 07:58 PM
Do a search on the forums for EMS.

Chris