PhpDig.net - View Single Post - 2 how-to questions backups, and Crons

Charter · 03-25-2004, 10:07 PM

Hi. At least one of the following shell commands should backup your database:

mysqldump -h HOST -p DATABASE > BACKUP.sql
mysqldump -h HOST -p --opt DATABASE > BACKUP.sql
mysqldump -u USER -p PASSWD DATABASE > BACKUP.sql
mysqldump -u USER -p PASSWD --opt DATABASE > BACKUP.sql

You can also gzip the backup like so:

mysqldump -h HOST -p DATABASE | gzip > BACKUP.sql.gz

Otherwise, maybe use phpMyAdmin to make a backup.

As for cron jobs, there is a tutorial in this thread.

The ads showing in the commercial script are not targted; they are just HTML examples of ads.

03-25-2004, 10:07 PM	#2
Charter Head Mole Join Date: May 2003 Posts: 2,539	Hi. At least one of the following shell commands should backup your database: mysqldump -h HOST -p DATABASE > BACKUP.sql mysqldump -h HOST -p --opt DATABASE > BACKUP.sql mysqldump -u USER -p PASSWD DATABASE > BACKUP.sql mysqldump -u USER -p PASSWD --opt DATABASE > BACKUP.sql You can also gzip the backup like so: mysqldump -h HOST -p DATABASE \| gzip > BACKUP.sql.gz Otherwise, maybe use phpMyAdmin to make a backup. As for cron jobs, there is a tutorial in this thread. The ads showing in the commercial script are not targted; they are just HTML examples of ads. __________________ Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension.