distal-attribute
distal-attribute
distal-attribute
distal-attribute

View all DB's and Tables at MySQL4

User, date Message
Written by ingod
3 months ago
Category: Import/Export
1 posts since Wed, 07 May 14
Hi,

I need a Tool to export all Databases and Tables in a CSV File (only the Information about it).
In the "Database SQL Export" is, after the execution of an export, a fantastic Grid, it shows all database and Tables, but this Grid is not exportable.
Is there any way to export the Grid in a file (Only the Information about Database, Tables, Rows)?

Thanks
Ingo
Written by kalvaro
3 months ago
587 posts since Thu, 29 Nov 07
No, it isn't possible.

However, you can export regular "Data" tabs. Just open the desired table from the information_schema database, right click on it and select "Export grid rows". Alternatively, compose your own SQL query to obtain the exact data you need.
Written by kalvaro
3 months ago
587 posts since Thu, 29 Nov 07
Oops... Did you say MySQL/4? information_schema hadn't been invented yet. You'll have to run some queries manually:

SHOW DATABASES

SHOW TABLES

SHOW COLUMNS
 

Please login to leave a reply, or register at first.