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

View all DB's and Tables at MySQL4

ingod posted 7 months ago in Import/Export
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
kalvaro posted 7 months ago
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.
kalvaro posted 7 months ago
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.