DaniWeb Forum Index > Web Development > PHP

PHP script to backup mysql

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Apr 2008

Posts: 490

Reputation: veledrom is an unknown quantity at this point

Solved Threads: 0

veledrom

Offline

Posting Pro in Training

PHP script to backup mysql

Sep 10th, 2009

Hi,

I am trying to backup one of my Mysql database with a PHP script.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
$host="localhost";
$database="toy";
$username="root";
$password="";
 
$connection=mysql_connect($host, $username, $password);
if(!$connection) {
	die("ERROR: Couldn't connect to the server.");
} else {
	$dbSelect=mysql_select_db($database);
	if(!$dbSelect) {
		die("ERROR: Couldn't select the database.");
	} else {
		$mysqldumpPath="/usr/bin/mysqldump";
		$backupFileName = "Desktop/toy-`date +%d-%m-%Y-%H:%M:%S`.sql";
		$createBackup = $mysqldumpPath." -u ".$username." -h ".$host." ".$database." > ".$backupFileName;
		exec($createBackup);
	}
}
?>
<?php
$host="localhost";
$database="toy";
$username="root";
$password="";

$connection=mysql_connect($host, $username, $password);
if(!$connection) {
	die("ERROR: Couldn't connect to the server.");
} else {
	$dbSelect=mysql_select_db($database);
	if(!$dbSelect) {
		die("ERROR: Couldn't select the database.");
	} else {
		$mysqldumpPath="/usr/bin/mysqldump";
		$backupFileName = "Desktop/toy-`date +%d-%m-%Y-%H:%M:%S`.sql";
		$createBackup = $mysqldumpPath." -u ".$username." -h ".$host." ".$database." > ".$backupFileName;
		exec($createBackup);
	}
}
?>

Executed code works fine in Linux terminal (toy-10-09-2009-16:15:49.sql) but when i run this PHP script it doesn't work. No error too.

What do you think i miss?

Thanks

Last edited by veledrom; Sep 10th, 2009 at 12:34 pm. Reason: .

•

Join Date: Jun 2007

Posts: 1,227

Reputation: kkeith29 has a spectacular aura about

Solved Threads: 167

kkeith29

Offline

Nearly a Posting Virtuoso

Re: PHP script to backup mysql

Sep 10th, 2009

On this line:

Help with Code Tags

PHP Syntax (Toggle Plain Text)

$backupFileName = "Desktop/toy-`date +%d-%m-%Y-%H:%M:%S`.sql";

You probably are going to need the absolute path to where the file needs to be stored.

Google is your friend.

Use [code] tags.

If you have found a solution to your problem, please mark the thread as SOLVED.

•

Join Date: Sep 2007

Posts: 1,429

Reputation: cwarn23 has a spectacular aura about

Solved Threads: 132

cwarn23

Offline

Nearly a Posting Virtuoso

Re: PHP script to backup mysql

Sep 11th, 2009

No error. That's because you didn't echo the exec function. Line 18 should be as follows:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
echo exec($createBackup);
echo exec($createBackup);

Try not to bump 10 year old threads as it can be really annoying.
Like php then read my website at http://syntax.cwarn23.net/
Star-Trek-Atlantis - now that's what I call a movie ^_^
My favourite PC. - MacGyver Fan
Bad english note: dis-iz-2b4u

•

Join Date: Apr 2008

Posts: 490

Reputation: veledrom is an unknown quantity at this point

Solved Threads: 0

veledrom

Offline

Posting Pro in Training

Re: PHP script to backup mysql

Sep 11th, 2009

Still doesn't work. Also no error for echo exec($createBackup);.

I changed the path to /usr/bin/mysqldump -u root -h localhost toy > /var/www/toy/toy-11-09-2009_10:03:41.sql but, still doesn't work in the script.
As i said before, it works fine in Ubuntu terminal. I also, tar it in the terminal without any problem with same path.

Thanks

•

Join Date: Sep 2007

Posts: 1,429

Reputation: cwarn23 has a spectacular aura about

Solved Threads: 132

cwarn23

Offline

Nearly a Posting Virtuoso

Re: PHP script to backup mysql

Sep 11th, 2009

In Ubuntu. ok. I found this problem when I first got a Virtual Private Server. The server had a different file structure than what my Ubuntu did. So try to browse around your server to make sure those are the locations for your servers Operating System. There seems to be two mains sorts of systems of sorting files from my experience.

•

Join Date: Sep 2005

Posts: 1,073

Reputation: digital-ether is just really nice

Solved Threads: 66

digital-ether digital-ether is offline

Offline

Veteran Poster

Re: PHP script to backup mysql

Sep 11th, 2009

•

Originally Posted by veledrom

Still doesn't work. Also no error for echo exec($createBackup);.

I changed the path to /usr/bin/mysqldump -u root -h localhost toy > /var/www/toy/toy-11-09-2009_10:03:41.sql but, still doesn't work in the script.
As i said before, it works fine in Ubuntu terminal. I also, tar it in the terminal without any problem with same path.

Thanks

Does PHP have write privileges to: /var/www/toy/

Does your root account on mysql have no password? Just wondering...

www.fijiwebdesign.com - web design and development and fun
Cpanel Email - Let users Register email accounts on your website upon registration
Ajax Chat - Fully browser based chat!

•

Join Date: Apr 2008

Posts: 490

Reputation: veledrom is an unknown quantity at this point

Solved Threads: 0

veledrom

Offline

Posting Pro in Training

Re: PHP script to backup mysql

Sep 15th, 2009

Hi digital,

I don't know how to check if PHP has R+W privilages !!!
No password for MySQL. I didn't set it.

Thanks

•

Join Date: Aug 2007

Posts: 70

Reputation: smartness is an unknown quantity at this point

Solved Threads: 10

smartness

Offline

Junior Poster in Training

Re: PHP script to backup mysql

Sep 15th, 2009

I use the class on the attachment to backup my CMS!

Attached Files

DB-Backup-Class.zip (3.6 KB, 3 views)

•

Join Date: Sep 2005

Posts: 1,073

Reputation: digital-ether is just really nice

Solved Threads: 66

digital-ether digital-ether is offline

Offline

Veteran Poster

Re: PHP script to backup mysql

Sep 15th, 2009

•

Originally Posted by veledrom

Hi digital,

I don't know how to check if PHP has R+W privilages !!!
No password for MySQL. I didn't set it.

Thanks

A simple check is to have PHP write a file to where ever you want to check.

eg:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$result = file_put_contents('/var/www/toy/test.txt', 'hi');
var_dump($result);
$result = file_put_contents('/var/www/toy/test.txt', 'hi');
var_dump($result);

www.fijiwebdesign.com - web design and development and fun
Cpanel Email - Let users Register email accounts on your website upon registration
Ajax Chat - Fully browser based chat!

•

Join Date: Apr 2008

Posts: 490

Reputation: veledrom is an unknown quantity at this point

Solved Threads: 0

veledrom

Offline

Posting Pro in Training

Re: PHP script to backup mysql

#10

Sep 16th, 2009

I have this info in 'User Settings'

Name-------Login name--------Home directory
veledrom ubuntu /home/ubuntu (this is active-bold and black coloured)
root root /root (this looks inactive-grey coloured)

This is what i did before.
ubuntu@ubuntu:~$ sudo chown -hR root /var/www/toy

I realise that i use root to login to mysql but in the terminal it shown ubuntu. Is ubuntu still root?

What can i do now? I bet it is something to do with users and permitions as you said, digital