Making phpMyAdmin and In-Portal more integrated
- Alex
Imported From: http://groups.google.com/group/in-portal-dev/browse_thread/thread/594beb2bcb7e819d#
I use phpMyAdmin as my primary database tool when I work with In-Portal.
However I need to uncheck a lot of checkboxes on export screen to make
resulting SQL look like I need it to look for usage in install_*.sql and
upgrades.sql files.
Here are some config setting overrides (place in config.inc.php file in
root directory of phpMyAdmin installation) to make it work better:
$cfg['Export']['sql_if_not_exists'] = false; // use CREATE TABLE
instead of CREATE
TABLE IF NOT EXISTS
$cfg['Export']['sql_auto_increment'] = false; // don't add AUTO_INCREMENT
number
$cfg['Export']['sql_backquotes'] = false; // don't use "`" in field names
unless it's really needed (like in case with MySQL keywords)
$cfg['Export']['sql_columns'] = false; // don't list table columns in
INSERT statement
$cfg['Export']['sql_extended'] = false; // don't combine multiple INSERT
statements to same database table into multi-insert statement
$cfg['Export']['asfile'] = false; // don't export to file
--
Best Regards,