Backup MySQL DB With PHP

[hellonoko]

I have been looking for a tutorial for a script to backup my DB but haven't been able to find anything that seems to work.

 

Can someone point me to a good tutorial or give me a simple example.

 

Thanks for your time,

ian

[marcus]

http://www.php-mysql-tutorial.com/perform-mysql-backup-php.php

 

excellent tutorial for what you should look into.

[hellonoko]

I looked at that one but it has 3 include files that it does not show.

 

So unless I already knew what I was doing its no good.

 

Played with it a bit but couldn't get it to work.

 

 

[marcus]

Haha. Just remove the includes, and connect to your database, you should be set.

[hellonoko]

Gave that I try. Page seems to work fine. But where is this backup going? Cant find it anywhere. Running on WAMP btw.

 

<?php

 

include 'dbconnect.php';

 

$dbname = "idea";

 

$dbhost = "localhost";

$dbuser = "idea";

$dbpass = "idea";

 

 

$backupFile = $dbname . date("Y-m-d-H-i-s") . '.gz';

$command = "mysqldump --opt -h $dbhost -u $dbuser -p $dbpass $dbname | gzip > $backupFile";

system($command);

 

 

?>

[marcus]

Should go in the same folder.

 

Most likely your connection is wrong.

 

Do:

 

$backupFile = "idea_" . date("Y-m-d-H-i-s") . ".gz";
$command = "mysqldump --opt -h localhost -u root idea | gzip > $backupFile";
system($command);

[hellonoko]

Nothing. No errors. But not file created either.