vb.org Archive - Database Back-up Issue

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)

- - Database Back-up Issue (https://vborg.vbsupport.ru/showthread.php?t=221196)

cyn0r

08-18-2009 04:38 PM

Database Back-up Issue

First off, i can make saves using my phpmyadmin no problem. However, when i use the vbulletin database backup option i get this error:

Code:

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

08-18-2009 05:24 PM

You need to post the complete mysql error.

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

theFM

08-18-2009 07:29 PM

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

08-19-2009 02:25 AM

Code:

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

08-19-2009 02:50 AM

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.

Quote:

Originally Posted by theFM (Post 1870031)

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

08-19-2009 06:36 AM

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

08-19-2009 07:17 AM

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

08-19-2009 07:45 AM

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/m...nce_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/m...ce_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/showt...t=mysqlhotcopy

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

cyn0r

08-19-2009 07:53 AM

I'm using putty. Any reason when i enter the password i get this:

Code:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

--------------- Added [DATE]1250673588[/DATE] at [TIME]1250673588[/TIME] ---------------

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

08-19-2009 10:10 AM

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

mysql_config --socket

All times are GMT. The time now is 08:42 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05026 seconds Memory Usage 1,739KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: