[Phpmyadmin-devel] Regarding Export plugin for sql

[ayush choubey]

On Wed, May 15, 2013 at 4:37 AM, Marc Delisle <marc at infomarc.info> wrote:

> Le 2013-05-13 19:24, ayush choubey a écrit :
> > There were a couple of things that i wanted to know
> >
> > 1) I was going through the this feature request
> > https://sourceforge.net/p/phpmyadmin/feature-requests/1387/
> >
> > and i too wasn't able to figure out how to change database name. Has
> > that feature been implemented
>
> Click on the database, then Operations. You'll find a dialog to rename
> the database.
>

Well, i was thinking of adding a "export as" feature there for this Feature
request
that will take a name and thus generated sql file will have that exported
database name.
But i guess renaming it is better option.

>
>
>
> > 2) while exporting the database there is no create database sql statement
> >
> > for example :
> >
> > there is a db called test with certain number of tables. I selected the
> > database, clicked on export, clicked custom and exported it.
> >
> > However only the tables were exported. There were no create statement
> >
> > Shouldn't the entire database be exported with create database
> > statement? Is this a bug or was this not implemented intentionally
>
> I guess nobody ever felt the need for this. The CREATE DATABASE
> statement is generated when you export at the server level.
>

We have hierarchy in this fashion
Server->Database->tables

Now when we have to export a table, we click on export and we expect that
there will
be a CREATE TABLE statement and INSERT statement

But when we have to export a server there are just CREATE TABLE statements
and
INSERT STATEMENTS.

So, in case the user wants to export a DB named test and his target machine
has no test.
In this case he would like sql file to have CREATE DATABASE test followed
by tables

To achieve this he will have to go to :

server level -> click on export->select custom->select test-> export->Go

If we add one CREATE DATABASE IF NOT EXISTS at database export level, then
his steps would be
Select test->export->Go
>From the user point of view, i guess, this will be much more preferred as
it has less number
of steps.

>
>
> --
> Marc Delisle
> http://infomarc.info
>
>
> ------------------------------------------------------------------------------
> AlienVault Unified Security Management (USM) platform delivers complete
> security visibility with the essential security capabilities. Easily and
> efficiently configure, manage, and operate all of your security controls
> from a single console and one unified framework. Download a free trial.
> http://p.sf.net/sfu/alienvault_d2d
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20130515/22ed7f95/attachment.html>