phpmyadmin database export


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.
If the database is large enough that phpmyadmin cant support it login to ssh and do the following command

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
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.


Staff member
mysqldump -ae -u username -p dbname table1 table2 table3 > output.sql
is going to dump only the specified table1, table2 and table3 tables.
Thanks. Any way to limit the maximum length of a query using the above method. Several of my tables contain large amounts of data.
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.