automattical db backup

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
ZiLL
Forum Newbie
Posts: 5
Joined: Sun Apr 28, 2002 8:30 am

automattical db backup

Post 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
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

You can easily make a backup using the latest version of phpMyAdmin.

http://www.phpmyadmin.net/

Mac
ZiLL
Forum Newbie
Posts: 5
Joined: Sun Apr 28, 2002 8:30 am

Post by ZiLL »

and without phpmyadmin??
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

ZiLL
Forum Newbie
Posts: 5
Joined: Sun Apr 28, 2002 8:30 am

Post 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.
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

ZiLL
Forum Newbie
Posts: 5
Joined: Sun Apr 28, 2002 8:30 am

Post by ZiLL »

thanks for your help !!

:arrow: i ll try this right now :wink:
User avatar
sam
Forum Contributor
Posts: 217
Joined: Thu Apr 18, 2002 11:11 pm
Location: Northern California
Contact:

Post 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
ZiLL
Forum Newbie
Posts: 5
Joined: Sun Apr 28, 2002 8:30 am

Post 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
:arrow: testing it..
User avatar
sam
Forum Contributor
Posts: 217
Joined: Thu Apr 18, 2002 11:11 pm
Location: Northern California
Contact:

Post 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
User avatar
EvilWalrus
Site Admin
Posts: 209
Joined: Thu Apr 18, 2002 3:21 pm
Location: Springmont, PA USA

Post 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...
User avatar
sam
Forum Contributor
Posts: 217
Joined: Thu Apr 18, 2002 11:11 pm
Location: Northern California
Contact:

Post 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 :mrgreen:

Cheers Sam
Post Reply