What are my backup options?

[szybszy]

I understand I have the following backup options:

1) simply store all the files on my harddrive - but that generates excessive traffic

2) ask my provider to back up files - I have yet to check that

My lamer type of question is - how do I make a compressed file ON the server?

Thanks!!!

[Shoeb Omar]

u cant

unless someone here will write a script for ya

[szybszy]

Thanks, Omario - at least I know where I am.

Could you or anybody help me revise the list below - "Backup Essentials" i.e. files I HAVE TO back up once in a while.

- messages file (which one is it?)
- user profiles file (which one is it?)
- settings.php
- "language".as.yp (if changed)
- template.php

What else?

Thanks!!!

[Greg Robson]

After hunting high and low across the entire web for a:

simple, effective, needs-no-configuration, PHP, working backup script...

...I eventually found one  

It's called XT Dump and it's less than 20kb in size

Upload it, check the folder and file permissions.

Then run it through your web browser - give it the user, password, database name, and then let it give you a list of all the tables.

Select them all and make sure the 'drop tables if they exist' is NOT checked.

It will then create a sql file on the server which you can restore from.

Download it at:
http://www.hotscripts.com/cgi-bin/dload.cgi?ID=13447

So long as it doesn't take longer than 30 seconds (script will time out) it should work. I haven't tested it fully and it is only v0.5 - but so far so good....

[szybszy]

THanks!!!! I'll let you know how it worked for me.

[Greg Robson]

I spent so much time looking for it - I thought that others should benefit from my hunting  

[Joseph Fung]

Greg - do you know if it works on servers running in safe mdoe?

[Greg Robson]

My server runs in safe mode and I've had no problems - it's an amazing little script - version 0.5 - it works, it's compact and it doesn't require configuring!

[Hypocrite]

Great program!

[Greg Robson]

I know - I'm hoping to use its code in a (very) simple YaBB SE backup script.

I'm going to call it yabb2sql (original huh!)

Hope to code it in the next few days

[CyCLOS]

Hi,

Great script, tested it and it works. Cause I am not a mysql guru can anyone tell me how to restore this kind of backup? Do I need a script too or....

Cya!

[Compuart]

ZZEE Active SQL Backup is also a nice backup script. It can send an e-mail with the .gz file attached to it. Only it's hard to configure and it's shareware

[Greg Robson]

Great script, tested it and it works. Cause I am not a mysql guru can anyone tell me how to restore this kind of backup? Do I need a script too or....

Yes, hmmmm, errr, I've got a re-edited version for backing up YaBB SE. Although I realised I haven't got a way to restore it - yet. I've been *Googling and I've got some leads - Expect me to release the script in the next week

* I like Googling

[CyCLOS]

Googling is the best

Can`t wait to get my hands on that release. Goodluck!

[NumberOne]

I'm certainly going to use this script. I know a bit about SQL, but since we do not have Telnet access to the host we're running our boards on, I guess I have to restore using webpages, which I don't have. I'm looking forward to a restore script. I will make backups anyway, because I've heard rumors about hackers hacking boards, emptying databases....