phpmyadmin database export

Dan

Moderator
#3
Hi duolos,

I don't know that there's much you can do about that. If it's a phpMyAdmin problem you should be able to export it from the command line though. Otherwise I see it's being worked on by phpMyAdmin and with something like that I am sure cPanel will implement the fix as soon as they can.
 
#5
If the database is large enough that phpmyadmin cant support it login to ssh and do the following command

Code:
To export use this command:
mysqldump -u USER -p PASSWORD DATABASE > filename.sql

To import database from dump file (in this case called filename.sql) use:
mysql -u username -p password database_name < filename.sql
 
#6
Yes, thanks. I am able to backup the db outside of phpmyadmin. However, I like to be able to export only a few tables at a time and was able to do this easily with previous versions of phpmyadmin.
 

KH-Dmitry

Administrator
Staff member
#7
Code:
mysqldump -ae -u username -p dbname table1 table2 table3 > output.sql
is going to dump only the specified table1, table2 and table3 tables.
 
#9
Thanks. Any way to limit the maximum length of a query using the above method. Several of my tables contain large amounts of data.
 
#10
It's a known bug in phpmyadmin. I've been anxiously awaiting it to be fixed but it hasn't to-date.
Make sure your cpanel is set to auto-update so you receive the earliest update.
 
Top