How often do you back up your database

[Wayne Luke]

What is a backup?

[tgillespie]

One of those things that gets lost on my ToDo list. Pshhhhh. Who needs backups

[Beth]

It sounds like you did this backup via the vBulletin Admin CP

I did it that way. Isnt that what is for?

I dont understand much about web languages or techie talk so the other one you mentioned is waaaaaay over my head. sorry

[tgillespie]

The most 'techie' way is via Telnet. This is taken from vBulletin userguide.

Step One - Backup current database:

• Telnet/SSH into your system (we'll call it machine1)
• from the root directory, type
  mysqldump --opt -uUSERNAME -p databasename > /path/to/dump.sql
• this should only take about than 30 seconds to a few minutes, depending on your database size
• when it is completed, it will bring you back to the prompt
• verify that you have a dump.sql in the /path/to area you specified

• That is taking into consideration you know how to open Telnet and connect. This way has proven faster and very reliable to me.

[Beth]

Thank you for taking the time to reply tgillespie. All that kind of stuff goes way over my head though
I've heard of Telnet through these forums but other than that it means noting to me.

Thank you anway

[Wayne Luke]

Telnet is a way to connect directly to a remote Unix/Linux machine and run commands directly on that machine. Considered insecure, Telnet has pretty much been replaced with ssh (secure shell).

The Windows equivalent is called Windows Terminal Server and has various front-ends like PCAnywhere and Citrix Terminal.

http://searchnetworking.techtarget.c...213116,00.html

[Babylon]

sadly my host doesn't allow me telnet or ssh but i can still run cron jobs so that's something at least.

I backup every few months, but i really mean to backup every few days... I just get lazy

[Wayne Luke]

sadly my host doesn't allow me telnet or ssh but i can still run cron jobs so that's something at least.

I backup every few months, but i really mean to backup every few days... I just get lazy

There is a script in the MySQL forum that you can run as a cron job. It will backup your forum and you can have them emailed to you on your schedule.

[Babylon]

There is a script in the MySQL forum that you can run as a cron job. It will backup your forum and you can have them emailed to you on your schedule.

Thanks, i'll have a look for it
I was writing my own but i got lazy again

[Mijae]

I have never backed up my database, and my site has been up running for 350 days now. Very close to our one year birthday. Also, the DB is about 65MB, and I have a slow download speed (11kb/s, IDSN line).

[Lacrosse Boy]

Once a week

[Raz Meister]

gzipping, or even bzipping usually shrinks the SQL file 10 fold.

[Water[EFE]]

Every Friday.

[Bane]

Every Friday.

Every 12 hours backup and gzip by cron with 4 backups in case something is wrong with one, or two, or three. We also back up the site daily, and I drop a copy to my hdd every 2 weeks or so.