Take Backup of MySQL database using PHP

Why not have your PHP exec a shell script that does the backup for you?

for example…

[code]
#!/bin/bash
date=`date "+%Y-%m-%d"`
mysqldump -u dbUsername -pPassWord databaseName > /var/backup/databaseName-backup$date.SQL
[/code]

Why not have your PHP exec a shell script that does the backup for you?

for example…

[code]
#!/bin/bash
date=`date "+%Y-%m-%d"`
mysqldump -u dbUsername -pPassWord databaseName > /var/backup/databaseName-backup$date.SQL
[/code]

By using this script, you can easily take backup of your database.The generated backup file is .SQL file which is easily import in your database. It is the easiest way.

By using this script, you can easily take backup of your database.The generated backup file is .SQL file which is easily import in your database. It is the easiest way.

Probably not the most practical or scalable method here. If you didn’t save everything into $return and just write on each row or buffered it and write to the file when the buffer is full, then you won’t run out of memory

Probably not the most practical or scalable method here. If you didn’t save everything into $return and just write on each row or buffered it and write to the file when the buffer is full, then you won’t run out of memory

Ya Matth, In any programming language, if you want to write in file , you have to put that data in one variable.
Here $return is a variable.And i taste this script with that database which has 9 to 10MB data and have above 130 tables. And it works fine.

Ya Matth, In any programming language, if you want to write in file , you have to put that data in one variable.
Here $return is a variable.And i taste this script with that database which has 9 to 10MB data and have above 130 tables. And it works fine.

Its just that you are concatenating to $return for every row instead of appending to the backup file. So instead of creating a gigantic variable, you could make a smaller one, write to disk and repeat. Simply append with fwrite (a) or do a

file_put_contents(’db-backup-’.time().’-’.(md5(implode(’,’,$tables))).’.sql’, $return, FILE_APPEND);

after the last two $return assignments ( $return.= “);n” and $return.=”nnn”; )

Its just that you are concatenating to $return for every row instead of appending to the backup file. So instead of creating a gigantic variable, you could make a smaller one, write to disk and repeat. Simply append with fwrite (a) or do a

file_put_contents(’db-backup-’.time().’-’.(md5(implode(’,’,$tables))).’.sql’, $return, FILE_APPEND);

after the last two $return assignments ( $return.= “);\n” and $return.=”\n\n\n”; )

Thanks for your suggestion.

Thanks for your suggestion.

[...] Take Backup of MySQL database using PHP – PHP Genious [...]

BUT………………….
How can we restore database using this .sql file? it is impossible i tried. pls help me……

BUT………………….
How can we restore database using this .sql file? it is impossible i tried. pls help me……

Hi, Thanx a lot..This is a good script .This is very helpful for me.. thanx a lot once again..

i had button to call this function….how to pass values to this function

how to backup mysql database values using php to dreamweaver editer

hi i m new to php so plz help me in this prblem….

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in C:xampphtdocsphp_admindb_backup.php on line 18

Hi,

Thanks for comment. Please add connection in bracket after comma.
Like Ex: mysql_fetch_row($results,$conn)

Here $conn is the DB connection.

//get all of the tables
if($tables == ‘*’)
{
$tables = array();
$result = mysql_query(‘SHOW TABLES’);
while($row = mysql_fetch_row($result, $conn))
{
$tables[] = $row[0];
}
}
else

but still i m getting prblem………..

Hi,     Thanks a lot. This is very nice script ………..
but if we want to take backup in  excel sheet then.       
Please tell me about that how i take…….