phpmyadmin database export

Dave G

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

Dan

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

NamiFlop

New Member
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
 

doulos

Member
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
Code:
mysqldump -ae -u username -p dbname table1 table2 table3 > output.sql
is going to dump only the specified table1, table2 and table3 tables.
 

doulos

Member
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

Member
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

Moderator
In the change log for 11.38.2.7:
  • Fixed case 77013: Apply phpMyAdmin patch for large table export problem.
 
Top