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.
+2
A:
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
Henrik P. Hessel
2009-07-15 08:59:10
Thx for that - I'm aware of different ways of doing this, and your suggestion is probably the best option for exporting tables. However i'm looking at various sql queries to export data from. I suppose I could always create temporary tables..
DBMarcos99
2009-07-15 09:03:54
What about the MySQL Query Browser?
Henrik P. Hessel
2009-07-15 09:16:17
You're right, there are various workarounds rAyt - thanks for your suggestions. I was just wondering if there was a phpmyadmin setting I could change to enable exporting (in this case to csv files) from phpMyAdmin where a query brings back more than 100 rows. If there isn't I'll continue with a workaround, so no big deal.
DBMarcos99
2009-07-15 09:21:50