phpmyadmin database export

Is there any fix for the bug that will not allow the export of large databases?

Results of an attempt to export a large db:

I can't even export a single small table.

---Edited to remove your server's ip---

 

Not sure what your trying to do with the DB, but a cPanel backup may work your DB will be in the backup.

 

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.

 

Sorry about the IP, wasn't thinking I guess.

 

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

 

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.

 

i forgot about that one

 

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.

 

The bug report in the original post says it's been fixed now. Hopefully soon!

 

In the change log for 11.38.2.7:

• Fixed case 77013: Apply phpMyAdmin patch for large table export problem.