Web Enthusiastic, Nature Lover

Tag: MySql

Backup Your MySQL Database Using PHP

Here is the script to backup MySql database using php. Cheers! ‹?php // Check via PhpMyAdmin to see what character database is using mysql_query(‘SET NAMES utf8’); mysql_query(‘SET CHARACTER SET utf8’); $tables = ‘*’; //get all of the tables if($tables == ‘*’) { $tables = array(); $result = mysql_query(‘SHOW TABLES’); while($row = mysql_fetch_row($result)) { $tables[] =