Re: Downloading Database?!?!

From: Date: Wed, 23 Jul 2003 06:32:52 +0000
Subject: Re: Downloading Database?!?!
References: 1  Groups: php.db 
Request: Send a blank email to php-db+get-29422@lists.php.net to get a copy of this message
Have you considered using the console-tool, "mysqldump " ? You could write a quick script ... say mysqldump -u adminuser -p adminpass --all-databases > backup.sql tar -zcvf backup.tar.gz backup.sql mv backup.sql /somepath/backup.sql if you're on Winders, a batch file: mysqldump -u adminuser -p adminpass --all-databases > backup.sql move backup.sql z:\somepath\backup.sql If you write a batch script, or shell script, all the "new guy" would have to do is run it. Create a cron job (on linux) or scheduled task (on windows) and the "new guy" just has to figure out the coffee machine :) Food for thought, ~Steve Brenton Dobell wrote:
Hello all, I am developing an Intranet page for my workplace, ATM i use phpmyadmin to do rutine backups ect, this is cool but i am going on long service leave for 14 weeks and during that time a new guy will attempt to continue to maintain the site and perform regular "backups"... I tried to show him how to use phpmyadmin but has proved too dificult for him to understand, how can i make a quick script to implement into a page that prompts you to download the entire sctipt in .txt form?? just like php myadmin, and starting tips and hints would be great. Cheers in advance Brenton


« previous php.db (#29422) next »