View all DB's and Tables at MySQL4

[expired user #8058]'s profile image [expired user #8058] posted 10 years ago in Import/Export Permalink
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's profile image kalvaro posted 10 years ago Permalink
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's profile image kalvaro posted 10 years ago Permalink
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.