On Thu, May 16, 2013 at 4:09 PM, Marc Delisle
<marc(a)infomarc.info> wrote:
Le 2013-05-14 20:12, ayush choubey a écrit :
On Wed, May 15, 2013 at 4:37 AM, Marc Delisle <marc(a)infomarc.info
<mailto:marc@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.
You probably meant "when we have to export a
database" ?
Oh, yeah, sorry, i meant Database, by mistake i wrote it as server.