Web Hosting Talk







View Full Version : Phpmyadmin wont dump file! HELP


dallassmith
08-20-2002, 02:16 PM
Hi, I went into a sql db and tryed to dump the data & structure or w/e and it acts like it is loading and just goes to a blank screen. When I try the same thing on my smaller db it does it fine, but since this one is 120mb is that why it is messing up? If so how do I fix it.

-Aaron-

Annette
08-20-2002, 02:19 PM
It might be because it is so large, yes. You can have phpMyAdmin send it as a file instead, and then just save it locally to your machine.

dallassmith
08-20-2002, 02:22 PM
Thats what I was trying to do...

sonic
08-20-2002, 02:45 PM
log into your ssh/telnet and dump database manually.

phpmyadmin cant backup/restore large database .
and "4MB" database is considered as "large" for data restore
(however, for backup, it may support up to 10MB)

Jedito
08-20-2002, 03:35 PM
Try using

mysqldump --opt -uUSERNAME -p PASSWORD databasename > dumpfile.sql

skylab
08-20-2002, 03:45 PM
i always use this for my large databases. works great.

DUMPING
mysqldump -uUSERNAME -pPASSWORD dbname | gzip > dbname.sql.gz

RESTORINE
gunzip < dbname.sql.gz | mysql -uUSERNAME -pPASSWORD dbname


of course in plesk it's all funky and a tad different, but, works fine for me.