CODEWITHSUNDEEP
phpmyadmin
yarek
yarek

Reputation: 12054

How to save customized config export in phpmyadmin?

I want to use "CSV for Excel" in export as default method in phpmyadmin.

I read that doc, but cannot find the infot I am looking for.

Any clue ?

Upvotes: 2

Views: 1375

Answers (2)

Isaac Bennetch
Isaac Bennetch

Reputation: 12432

Edit config.inc.php and add the line 

$cfg['Export']['format'] = 'csv';

You can see a lot more export options in libraries/config.default.php if you wish to further customize your export defaults.

Upvotes: 3

Rajiii4u
Rajiii4u

Reputation: 1

Open your phpmyadmin. be sure phpmyadmin version > 3.0 Click "Export" tab Select "Custom - display all possible options" button in "Export Method:" Select Required tables. Select "CSV for MS-excel" in "Format" Select field, to receive "CSV" file

Upvotes: -1

Related Questions