Best way to backup?

[whateveramen]

Currently I download my 'forum' folder from the ftp, is this sufficent? Whats best way to back up? I tried in the vb admin bit but got loads of errors

Thanks

[Marco van Herwaarden]

Usually your MySQL database will not be located in your forum folder. Looks to me that you are backing up the software, but never the data.

[Colin F]

See this page for information about backing up your database: http://www.vbulletin.com/docs/html/m...nce_ssh_backup

[mkdevo]

Originally Posted by whateveramen

Currently I download my 'forum' folder from the ftp, is this sufficent? Whats best way to back up? I tried in the vb admin bit but got loads of errors

Thanks

you might want to check this out for a simple, automated solution..

[whateveramen]

Originally Posted by mkdevo

you might want to check this out for a simple, automated solution..

Thanks, can anyone help me with it pls and maybe back up my forum?? I can pay something small if need be.

[Marco van Herwaarden]

Please start by either looking into that hack, or read the chapter on backup in the vBulletin manual. A backup is something that has to be done regular, not so much use to pay someone to do it 1 time. You really should learn to do it yourself, so you can repeat it on a regular basis.

[Regs]

Originally Posted by Colin F

See this page for information about backing up your database: http://www.vbulletin.com/docs/html/m...nce_ssh_backup

If you value your attachments/avatars/profile pictures, DO NOT use those instructions for backing up your database unless you do some further investigation (version of MySQL being used would be the main one apparently).

I got burned last night because of this and am still fuming about it

vB.com is apparently aware of the issue and is yet to let their customers know the pre-cautions needed, if they ever will. As far as I'm concerned, this is a huge failure of communication on their part.

[Marco van Herwaarden]

The topic of that is titled ' Backing Up The Database via SSH/Telnet'.

These are instructions on how to backup your database. Everything not in the database is obviously not covered by that topic.

There is 1 issue with MySQL 4.1 and certain fieldtypes, but this is a bug in MySQL and has nothing to do with vB.

[Regs]

There is 1 issue with MySQL 4.1 and certain fieldtypes, but this is a bug in MySQL and has nothing to do with vB.

Don't attempt to gloss this over and say everything is hunky-dory

vB is aware of the issue and has not warned their customers through proper channels. A developer has even given 3 queries to run on your vB database in order to combat the so-called MySQL bug. These instructions are hidden in some obscure thread over on vB.com and a search would only turn them up after it may be 'too late'.

I cannot believe that you would even attempt to discredit my advise above in light of the known facts.

Where's your head at?

[Marco van Herwaarden]

Those instructions have been acurate and are still acurate for any backup/restore situation within the same MySQL version AFAIK. There is a bug in MySQL causing problems moving from MySQL 4.0 (and maybe before) to 4.1, and Jelsoft (not MySQL!!!) have spend a lot of time in finding what have been causing this problem and find a work around for it. The majority of the customers will never encounter this problem, only when they try to move to 4.1.

Once again the bug is in MySQL and not in vBulletin, and the reason and work around for it have only recently been found. The way your warning is put in your thread above make it looks like all vB customers will run into this issue, and that it is Jelsoft's fault that it is happening. I didn't deny the problem, i only tried to put your post in the correct perspective.

If you feel that Jelsoft makes a mistake on this issue, please contact Jelsoft about this, or post at the official support forum vBulletin.com.

vB.org has nothing to do with official support, and is not the place to make complaint about that.