It seems that current behavior is that, by default, when exporting multiple databases at once the CREATE DATABASE statement is omitted. I suppose it's possible that someone would want to export multiple tables for import in to only one database, but that's certainly not what I would think is normally expected behavior.
I'd like to discuss how we can make this better. I propose that we make the default $cfg['Export']['sql_create_database'] = true; (it's currently false) in all cases, but I don't recall from the initial commit 77e67c3f whether there was a reason this was false by default.
Any comments on this idea?
Le 2014-06-24 09:31, Isaac Bennetch a écrit :
It seems that current behavior is that, by default, when exporting multiple databases at once the CREATE DATABASE statement is omitted. I suppose it's possible that someone would want to export multiple tables for import in to only one database, but that's certainly not what I would think is normally expected behavior.
I'd like to discuss how we can make this better. I propose that we make the default $cfg['Export']['sql_create_database'] = true; (it's currently false) in all cases, but I don't recall from the initial commit 77e67c3f whether there was a reason this was false by default.
Any comments on this idea?
After reading https://sourceforge.net/p/phpmyadmin/bugs/4019/
I notice that I set the default to false, to help users on shared hosting where db creation is done via an external control panel.
Default values for parameters cannot be right for all situations; we have to pick the best one for the majority, which is probably users on shared hosting.
-
Isaac Bennetch -
Marc Delisle