CODEWITHSUNDEEP
mysqlexcelcsv
DBMarcos99
DBMarcos99

Reputation: 465

Annoying PhpMyAdmin export feature

I wonder if any other users of PhpMyAdmin for Mysql have come across this niggle? Normally when exporting the results of a sql query, you're given options (eg what format to export in , name of filename etc). However above a certain number of rows, these options are not available and you can only see the sql on the normal window. Obviously there are workarounds (I do a copy => Paste Special => Unicode text) but I wonder if anyone's got it working correctly? Changing the Show and Repeat Headers value on the screen doesn't seem to enable the export to csv option for larger (ie > 100) data sets.

Upvotes: 0

Views: 1301

Answers (1)

Henrik P. Hessel
Henrik P. Hessel

Reputation: 36627

Phpmyadmin is always limited by the local PHP Settings. If you have shell access, I would recommend you using the mysqldump command.

shell> mysqldump [options] db_name [tables]
shell> mysqldump [options] --databases db_name1 [db_name2 db_name3...]
shell> mysqldump [options] --all-databases

Upvotes: 2

Related Questions