Page 1 of 1
automattical db backup
Posted: Sun Apr 28, 2002 8:30 am
by ZiLL
is there a possible way to backup the content of a MySQL database automatically (make a .sql file) and if even possible mail it.
I ve made a full phpmysql based site for a client and it would be very usefull to have a backup very often.
Anyone has experience with this??
Thanx
ZiLL
Posted: Sun Apr 28, 2002 9:03 am
by twigletmac
You can easily make a backup using the latest version of phpMyAdmin.
http://www.phpmyadmin.net/
Mac
Posted: Sun Apr 28, 2002 9:34 am
by ZiLL
and without phpmyadmin??
Posted: Sun Apr 28, 2002 10:48 am
by twigletmac
Posted: Sun Apr 28, 2002 11:14 am
by ZiLL
well, thanx a lot for your help.. but i would need a php script for it, since i dont have access to mysql that way on my sites server.
Posted: Sun Apr 28, 2002 1:21 pm
by twigletmac
Posted: Sun Apr 28, 2002 1:25 pm
by ZiLL
thanks for your help !!

i ll try this right now

Posted: Sun Apr 28, 2002 1:41 pm
by sam
Here is a very small script that works well for dumping sql data...
http://www.evilwalrus.com/viewcode.php?codeEx=486
Cheers Sam
Posted: Sun Apr 28, 2002 2:20 pm
by ZiLL
twigletmac
your link worked on my local server, but didn't at a client site..
testing it later on some different servers.
and sam..
thanx for the link

testing it..
Posted: Sun Apr 28, 2002 2:25 pm
by sam
I have only tested mine on mysql versions 1.3.29 and 1.3.43
It might not work on older versions.
Cheers Sam
Posted: Sun Apr 28, 2002 3:23 pm
by EvilWalrus
I have only tested mine on mysql versions 1.3.29 and 1.3.43
I sure hope those version numbers are typos...
Posted: Mon Apr 29, 2002 11:07 am
by sam
Yeah oops, I'm all over the place. I meant: 1.23.19 and 1.23.43 I got them confused with apache version syntax... Will you ever forgive me
Cheers Sam