D
D
des1roer2016-02-17 14:03:28
MySQL
des1roer, 2016-02-17 14:03:28

Mysql database size?

version 4.1.22-community-nt-log
try

SELECT table_schema "database_name", sum( data_length + index_length )/1024/1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema;

I get 2 Table 'information_schema.tables' doesn't exist SQL1.sql 1 1

Answer the question

In order to leave comments, you need to log in

3 answer(s)
I
Igor, 2016-02-17
@des1roer

SHOW TABLE STATUS FROM DBNAME
this was the command before

M
Melkij, 2016-02-17
@melkij

mysql 4.1?
Hmm. Look in the archives for at least 10 years ago, as then it was possible to calculate the size.
information_schema, I remember, only appeared in 5.0.

E
eskrano, 2016-02-17
@eskrano

It says that the table does not exist.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question