Database Back-up Issue

[cyn0r]

First off, i can make saves using my phpmyadmin no problem. However, when i use the vbulletin database backup option i get this error:
Warning: mysql_query() [function.mysql-query]: Unable to save result set in [path]/includes/class_core.php on line 408
Database Error Database error

I even tried downloading the automatic database backup mod you guys have here and nothing as well. That also creates an error. I'm not sure what's going on at all. If anyone could help that would be very much appreciated, thanks.

Kevin

[snakes1100]

You need to post the complete mysql error.

Right click and view page source if need be to get the complete error msg.

[theFM]

i say you add a support ticket if you are having no solutions

or

try to use mysqldumper to upload and install your database

[cyn0r]

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT * FROM attachment;

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Request Date : Tuesday, August 18th 2009 @ 08:23:10 PM
Error Date : Tuesday, August 18th 2009 @ 08:23:16 PM
Script :
Classname : vb_database
MySQL Version :

[snakes1100]

The lost connection to the server is a mysql setting and its timing out, that is why only using mysqldump from the command line is the only reliable way to dump or import a DB backup file.

If phpmyadmin works, then use it if you dont have shell access to the server.

Do not use the dump feature in the admincp, its NEVER been reliable and IMO it shouldnt be there anyways.


i say you add a support ticket if you are having no solutions

or

try to use mysqldumper to upload and install your database

He is trying to dump the db, not upload it.

[cyn0r]

One quick question. Is backing up my database with phpmyadmin the same as backing up my forum database from let's say, the admincp? If not, what are the differences?

Thanks
Kevin

[theFM]

thats only i mean by

if you are dumping your database use bigdump software , just search google
using phpmyadmin causes big problems , it is very problematic as it causes many timeout errors

and when you dump a database like i have which is over 500 MB , it causes huge problems
so best use bigdump , it's very easy and reliable :)

[Dismounted]

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 Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/maintenance_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/maintenance_ssh_restore

P.S. If you don't have shell access, some people have also reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showthread.php?t=134821&highlight=mysqlhotcopy

Bigdump:
http://www.ozerov.de/bigdump.php

[cyn0r]

I'm using putty. Any reason when i enter the password i get this: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

--------------- Added 1250673588 at 1250673588 ---------------

I got mysqldump to work. So basically, i'm just making a back up of my database installed on my server? I'm using godaddy and i just noticed Godaddy has a server side program installed to allow you to backup/restore databases. Anyone else familiar with godaddy and their services?

[snakes1100]

From the command line type this, hit return/enter and post the results:

mysql_config --socket