Welcome, Guest. Please login or register.
Did you miss your activation email?
Jan 06, 2009, 02:04:44 AM

I have never accepted what many people have kindly said — namely that I inspired the nation. Their will was resolute and remorseless, and as it proved, unconquerable. It fell to me to express it.

- Winston Churchill

Home

Help

Welcome Guest - Register or Login Now to remove these advertisments

Registration is completely free and only takes a few minutes to signup !

Entrepreneur Forum > Webmasters - Discuss Making Money Online > 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 369 times)

Galaxian

Senior Member

Joined: Oct 2007
Posts: 238

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.

Latest Blog Post : The Advantages of Water-Powered Car Technology

Got an eye for The Best Cars like a sizzling Ferrari sports car or the luxury of BMW?

MrMango

Junior Member

Joined: Jan 2007
Posts: 57

$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: 64

$View AceCoder\s Profile$

Germany

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

~Dave~

Administrator

Joined: Jan 2006
Posts: 6186

Building a Foundation

$View ~Dave~\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 : Social Media Optimization for Social Media Marketing

Best Affiliate Programs Ξ Recommend Us Ξ Blogger Forum

Pages: [1]