phpmyadmin database export

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.
 
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.
 
Code: 
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.
 
In the change log for 11.38.2.7:
  • Fixed case 77013: Apply phpMyAdmin patch for large table export problem.
 
You must log in or register to reply here.
Top