var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
Phpmyadmin wont dump file! HELP
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.
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.
Thats what I was trying to do...
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)
mysqldump --opt -uUSERNAME -p PASSWORD databasename > dumpfile.sql
i always use this for my large databases. works great.
mysqldump -uUSERNAME -pPASSWORD dbname | gzip > dbname.sql.gz
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.