vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Database Backup Error (https://vborg.vbsupport.ru/showthread.php?t=211916)

Racecar 04-22-2009 02:30 PM
Database Backup Error
 
I get the following error when trying to backup the database

Warning: mysql_query() [function.mysql-query]: Unable to save result set in [path]/includes/class_core.php on line 408

Not sure what I need to do to fix. I have re-installed vbulletin but get the same error each time.

Lynne 04-22-2009 03:13 PM
You should not backup your database from the admin cp. This is from the manual:
Backing Up The Database via SSH/Telnet or
Backing Up The Database via phpMyAdmin

Restoring The Database via SSH/Telnet or
Restoring The Database via phpMyAdmin

If you don't have shell access, some people have also reported success with these scripts:
MySQLDumper
MySQLHotxcopy
Bigdump

Powlo 04-22-2009 03:21 PM
The software i use is mysql Administrator, it makes life so easy to backup & restore you can also set up backup schedules. I backup twice a day since ive being hacked.

Oh and guess what... its FREE!!

http://dev.mysql.com/downloads/gui-tools/5.0.html

snakes1100 04-22-2009 04:16 PM
It appears that sql is running out of memory when trying to do the dump, have your host check, what are you using when trying to do the sql dump?


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

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01036 seconds
  • Memory Usage 1,713KB
  • 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
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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