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

View all DB's and Tables at MySQL4

ingod posted 11 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 11 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 11 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.