Create / Export MySQL Database backup using PHP

How can you create a MySQL Database backup using PHP.If you think the database is too large as GB how do you get a fastest backup?In this post will describes how to create a MySQL Database backup/dump quickly instead of using phpmyadmin access using PHP.Also you can save your time to get backup.
Continue reading Create / Export MySQL Database backup using PHP

Import a MySQL database using PHP

How can I import MySQL database using PHP? Also if you have to import large size of MySQL dump, how do you import it easily? In this article is describing how to import MySQL database using PHP.In this method you can save your time instead of you import sql file in the phpmyadmin or database software.As my personal experience I tested this script using 2.125GB large database dump file. Continue reading Import a MySQL database using PHP

How can I get database table sizes?

If you want to get database tables sizes using MySQL you can do it as follows.
MySQL system database called information_schema. It has right information for those who want to get DB table real size.
First of all you must go to the MySQL “information_schema” and get “schema name” of the database from the “SCHEMATA” table. Continue reading How can I get database table sizes?