Internet Marketing Forum

For Webmasters and Entrepreneurs

Welcome, Guest. Please login or register.
Did you miss your activation email?
May 21, 2012, 02:59:11 PM

You have to have confidence in your ability, and then be tough enough to follow through.

- Rosalynn Smith Carter

Home

Privacy

Internet Marketing Forum > Online Business Discussions > Website Design and Maintenance > Database

Need an example of how to use mysqldump

0 Members and 1 Guest are viewing this topic.

Pages: [1]

Author

Topic: Need an example of how to use mysqldump (Read 1450 times)

Galaxian

Senior Member

Joined: Oct 2007
Posts: 286

The internet is my playground.

$View Galaxian\s Profile$
Gender: Male

United States

Feb 08, 2008, 11:55:30 AM

Can anyone please write out a complete php working example of how to do a mysqldump on an entire database?

Please, I would like to automate my backupprocess with a PHP script.

MrMango

Junior Member

Joined: Jan 2007
Posts: 63

$View MrMango\s Profile$
MrMango is from United Kingdom

United Kingdom

Feb 08, 2008, 01:00:46 PM

The most common use of mysqldump is probably for making a backup of an
entire database:

shell> mysqldump --opt db_name > backup-file.sql

You can read the dump file back into the server like this:

shell> mysql db_name < backup-file.sql

Or like this:

shell> mysql -e "source /path-to-backup/backup-file.sql" db_name

My Website http://ebizwebbiz.com/mangoinstyle/earn/

AceCoder

Junior Member

Joined: Oct 2007
Posts: 79

$View AceCoder\s Profile$

United States

Feb 10, 2008, 07:58:15 PM

That's fine if you have access to the command line but how can you do these in PHP?

Latest Blog Post : PHP – Pass by Reference or Pass by Value

AceCoder's Programming Tips

Code4Gold

Administrator

Joined: Jan 2006
Posts: 6215

Administrator

$View Code4Gold\s Profile$

United States

Feb 10, 2008, 10:30:38 PM

You could do something like this in PHP using the PHP system() command

Code:

$backupFile = $dbname . date("Y-m-d-H-i-s") . '.gz';
$command = "mysqldump --opt -h $dbhost -u $dbuser -p $dbpass $dbname | gzip > $backupFile";
system($command);

Otherwise you could use a SQL statement to dump the data

Code:

$backupFile = '/path/to/backup/mytable.sql';
$query = "SELECT * INTO OUTFILE '$backupFile' FROM myTable";
$result = mysql_query($query);

You could read that back in like this...

Code:

$backupFile = 'mytable.sql';
$query = "LOAD DATA INFILE '$backupFile' INTO TABLE myTable";
$result = mysql_query($query);

If you have any question, ask away...

Latest Blog Post : 8 Tips for Creating a Marketing Buzz

Best Affiliate Programs Ξ SocialNews Ξ Blogger Forum Ξ Wealth Watching

Pages: [1]