PDA

View Full Version : can't do a backup


haythamghareeb
Wed 22nd Nov '06, 10:51am
Hi,
Originally I had a 3.5 then I realised I had to get a licence so I did. I upgraded to 3.6 and from that I upgraded until I got to 3.6.3 problem now is that I have to do my backups manually through MyPhP Admin.
If I try to use my Admin CP I get these errors:

Invalid SQL:
SHOW CREATE TABLE postparsed;
MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
====================
Invalid SQL:
SHOW CREATE TABLE product;
MySQL Error : Lost connection to MySQL server during query
Error Number : 2013

so any solutions to this? My guess is that tables have changed names or something but now since I am on 3.6.3 how do I fix this?
And shouldn't the upgrade have fixed table names?

Boxy
Wed 22nd Nov '06, 10:57am
The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the AdminCP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file.
See the online manual for instructions on manually backing up and restoring your database:
http://www.vbulletin.com/docs/html/manual_database_backup
http://www.vbulletin.com/docs/html/manual_database_restore