phpmyadmin database export

[doulos]

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

This interface does not work with large databases or large tables. Please see phpMyAdmin bug 4046.

Results of an attempt to export a large db:

Firefox can't find the file at https://xxx.xxx.xxx.xxx:2083/cpsess3583879531/3rdparty/phpMyAdmin/export.php.

I can't even export a single small table.

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

 

[Dave G]

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

 

[Dan]

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.

 

[doulos]

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

 

[NamiFlop]

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

 

[doulos]

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]

mysqldump -ae -u username -p dbname table1 table2 table3 > output.sql

is going to dump only the specified table1, table2 and table3 tables.

 

[NamiFlop]

mysqldump -ae -u username -p dbname table1 table2 table3 > output.sql

is going to dump only the specified table1, table2 and table3 tables.

i forgot about that one

 

[doulos]

Thanks. Any way to limit the maximum length of a query using the above method. Several of my tables contain large amounts of data.

 

[zombie]

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.

 

[Dan]

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

 

[Dan]

In the change log for 11.38.2.7:

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