How to backup mysql database through php?

[jdock1]

I looked into this everywhere,but the code does not make sense, is not properly documented and is outdated.

 

 

Ive been trying to achieve this for the past hour.

 

Anybody know how I can do this?

[QuickOldCar]

This script can do it.

 

http://www.dagondesign.com/articles/automatic-mysql-backup-script/

[jdock1]

This script can do it.

 

http://www.dagondesign.com/articles/automatic-mysql-backup-script/

 

Thanks, but that shit sucks. I cant get it to work on my server

 

Anybody else got a solution? A simple one with a few lines of code. That script is alot of code for a relatively simple thing

[dreamwest]

http://www.wizecho.com/nav=php&s=php_mysql_backup

[eMonk]

I've read it's bad to use php and other web applications to backup mysql databases (for big sites).

 

If it timeouts the file becomes corrupt. Backing up via SSH seems more solid.

 

Backup via SSH:

 

mysqldump --opt -u user -p dbname > {path}/backup.sql

 

Restore via SSH:

 

mysql -u user -p dbname < {path}/backup.sql

[dreamwest]

or you can use shell_exec() if you still want to use php

 

<?php
if(shell_exec("mysqldump --opt -u user -p dbname > {path}/backup.sql")){
echo "Backed up!";
}else{
echo "Failed";
}
?>