Backing up your database

[grant]

I suggested the cpanel way because I've had cron jobs fail on me more times than I'd like to share. Plus, it's just easier to do and there's not scripting invoved.

[dkinzer]

I was actually trying to debug why Wolf's db_backup script aint working. [...] Seems to work but it doesn't send the email from the script successfully like it does in PHP4 host

The problem is that the SMTP server at BlueHost requires user authentication and Wolf's script doesn't do that. I modified it to optionally use SMTP authentication and it works great.

I sent a patch file to Wolf for the changes. I haven't heard anything back so I don't know if the changes will be incorporated. I can provide a link to the patch file if anyone's interested.

Don Kinzer
http://www.zbasic.net

[jamesd116]

Thanks for the great tip, timberford! Now that I'm starting to work with these databases, it would be a VERY good idea to have backups just in case.

I used this process to do back ups every hour on my databases now that i have thisinformation coming to my email i look at it and see a bunch of gibberish to a newbie like me if i was to restore this would t be easy or should i find a different way.
Basiclly i guss what im asking is if i deleted everything or just lost all my db info would i just go to my email account copy it aand paste it nto a file and everything would be back to normal
something istelling me itss not that easy
im thiinking once the database is recreated i would have to manually insert information
wold it be better for me to do backups to my hard drive with the zip file
is there a better way for me to back up my sites hopefully in its entirety in one shot without having all the separate files
Maybe going to copy and paste ftp and public_html my computer unlesss someone can tell me an easy way of backing up my sites in a one button click and it gives me what i need to my email periodically
Thanks James
http://www.4spotlight.com
Looking for Local Musicians
Local Music for Local People

[shirleymixon]

MySQL database backup
=====================
http://restkultur.ch/personal/wolf/scripts/db_backup

I use the above to backup to a second server on bluehost
(not the same one - it's cheap at $7/month) and send myself an email that it got done...I call it each morning from a cpanel cron job...you can set the program to do what you want...

[piku]

Has anyone have any problems with Wolf's script above on PHP5?

[Syntholis]

Hey guys...

I'm backing up two different mysql databases via "backup" on the control panel... tried to restore one today, and discovered that they are being chopped at 147k... so they're useless...

If I back them up from phpmyadmin, same thing... the .gz files are corrupt...

Any ideas? A little nervous here...

[chrism]

I did a backup using the control panel earlier today... and restored it... it worked fine...

[Syntholis]

Even the daily backups, and such are doing it...

A FULL backup comes down, but it doesn't have sql backups in it...

ANd it is on multiple machines... so that's not it...

Can you go through the process, step by step for me, maybe I missing something...

My 9-8-06 backup was fine, but they've all been broken since then.

[chrism]

These are the steps:
1) go to control panel
2) go to System Tools
3) go to Backup
4) ... (I'm waiting for the server to respond... will continue when that happens)

[Syntholis]

Just in case this server won't let you post twice in a row...