<div>
Awesome.<br />
<br />
Thank you very much!<br />
<br />
/David C.
</div>


Awesome.

Thank you very much!

/David C.

<div>
Perfect! Exactly what I needed. Thank you!
</div>


Perfect! Exactly what I needed. Thank you!

<div>
<div class="content wysiwyg-content">
Hello everyone -<br />
<br />
I used to have a select statement that I would copy and paste into the MySQL command line client that would return the total amount of data contained within the MySQL server databases.<br />
<br />
It included the total data stored in addition to the data size of all indexes, etc.<br />
<br />
It was excellent for planning how much space I would need during migrations.<br />
<br />
However, I have lost access to that statement.<br />
<br />
Would anyone be able to help me formulate a new select statement to address the above?<br />
<br />
Thank you very much in advance.<br />
<br />
/David C.
</div>
</div>


Hello everyone -

I used to have a select statement that I would copy and paste into the MySQL command line client that would return the total amount of data contained within the MySQL server databases.

It included the total data stored in addition to the data size of all indexes, etc.

It was excellent for planning how much space I would need during migrations.

However, I have lost access to that statement.

Would anyone be able to help me formulate a new select statement to address the above?

Thank you very much in advance.

/David C.

SELECT Statment to Determine Total Amount of Data

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.