Getting this error now after the update:

Ok. Fixed both.

Magic runtime quotes is another deprecated function I wasnt aware of, added a php version check for that as well.

The syntax error was a semi-colon that mysteriously went missing, which I have now put back.


This version actually contains some experimental code that attempts to do backups via mysqldump (rather than all via php).

If you want to try that feature, you must edit a line in the mysqlbackup.php file.

I'll give it a shot now, for adding that code.

Cheers


Edit I can confirm that this works for both php and mysql :D


Best mod on here!

Ok, I know this isn't your problem, but I could use some advice on how to fix an issue with the automatic backups not completing.
Occasionally, the backup completes. If I try it a number of times, it will complete maybe 1 in 10 times. When it doesn't complete, the backup gets as far as the "user" table and then stops.
I've tried all the settings in the options, like locking, block processing, separate vs single table backups, etc. but nothing seems to fix it.

Just looking for some advice on what setting I might need to change in php or MySQL to stop it from timing out? (I assume it's timing out - I have no access to any logs on the shared server)

There is probably someone who knows what logs to look in to see the problem, but that's not me.... Meanwhile:

Is the user table ok? Try repairing it. You may need to stop mysql first for a successful repair on the user table:

----------
To repair all the tables in the database in centos we stopped it first.
# /etc/init.d/mysqld stop
Then navigated to the database files:
# cd /var/lib/mysql/[databasename]/
Then run the following command:
# myisamchk -r *.MYI
And once complete restart MySQL:
# /etc/init.d/mysqld start
-----------

If it's ok, then do you have a busy forum / is your server powerful enough? I had some odd behaviour until I upgraded and then everything magically worked perfectly.

Thank you for your reply.
As I mentioned, I'm on a shared server. No SSH, logs or anything useful available.
I can add a php.ini file to make changes and that's about it.
I've repaired the tables using the vBulletin admincp, makes no difference.

I'm hoping there would be a timeout setting that affects whether the backup completes as it's pretty random. I just don't know enough about all the php and mySQL settings.

If you view php info in vbulletin maintenance area, what are all the timeouts set at?

Most likely php timing out, but really hard to say.

If you use the latest version, you could try the experimental mysql backup method - see post #952

This has always worked well for me and I've used it on a few sites for a long, long time. Thanks Paul! one of the most useful mods here.

Figured I should install this now, I keep forgetting to do regular back ups :P