By Manpreet Vohra (administrator) on 17 January, 2010
Basically a database is a collection of tables.
So the size of the database is sum total of size of its individual tables.
Last modified: 17 January, 2010
Calculate size of Mysql database with it's tables
Basically a database is a collection of tables.So the size of the database is sum total of size of its individual tables.
Size of the table = Size of its Data + Size of its Indexes.
Size of database = Sum of {Individual Table Size}
Size of database = Sum of {Individual Table Size}
The following script uses that above logic to compute the overall size of the database by computing the size of its individual tables. This can be used to understand why and where the database size is growing.
By Manpreet Vohra (administrator) on 17 January, 2010
Last modified: 17 January, 2010
How to connect and execute query mysql database?
A very basic and essential snippet for any one starting with php and mysql database i.e. to connect to a given database, execute a custom sql and retrieve the results. The snippet can be modified to execute more than one query or execute an update or insert command instead of the query. The following snippet show exactly how to do so..
By Manpreet Vohra (administrator) on 17 January, 2010
Last modified: 17 January, 2010
Check if Table Exists in a Database?
At times we want to find if a tables exists in a database.The snippet below shows how this can be done.
It open a db connection or reuse an already db connection, then selects the given database and finally executes a sql to find out whether the table exists or not.
