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.