#8 Export operations

[Andrew Eddie]

I'm guessing export/dump operations would be high on
your list already. However, one useful operation
(other than export to file, table, other db) would be
to export to the clipboard.

I will often want to grab the structure of a single
table and put it straight back into the query window.
To date (with the likes of myFrontEnd) I need to save
it to an intermediate file first.

Other than that, absolutely brilliant program. Was
feeling lost after the demise of mySqlFront.

[J French]

Logged In: YES
user_id=412271

As far as table structures, if you right-click the table,
then Tools > Show Create > Execute, you'll be given the SQL
required to rebuild the table.

What we're working on now is actually copying whole tables
with their associated data and copying entire databases.
I've personally never actually seen the "Export Table"
option light up - this looks like there might already be
some code to work with, but I haven't actually looked under
the hood here.

[Pete Hurst]

Logged In: YES
user_id=2082521
Originator: NO

You can right-click on the "Tables" node underneath your database, then Tools > Show Create. You can then multi-select which tables you want to dump the schema for.

All this screen then needs are two tick boxes, "Export Schema" and "Export Data".

phpMyAdmin already provides this feature but it would be a really nice addition to mysqlcc.