You can create a batch file like this or if you want it to be in a web
interface much like phpmyadmin, but with your backup scheme you can use
the load data outfile command. This page from the mysql manual describes
both the infile and outfile methods:
http://www.mysql.com/doc/en/LOAD_DATA.html. This will tell you how to
use the syntax for the text files. It will let you do it with tabs,
commas, etc. Then you can use php to create the interface for your new
guy and make it as simple or complex as you like, but you don't even
have to use the filesystem functions to do it this way. Which does make
it a little simpler so that you can plan for 14 weeks of whatever you're
doing.
David Smith
On Wed, 2003-07-23 at 01:32, Stephen March wrote:
> 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
> >
> >
> >
> >
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
