vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   Which tables to transfer over (https://vborg.vbsupport.ru/showthread.php?t=198914)

JPforFree 12-15-2008 08:13 AM
Which tables to transfer over
 
We are changing hosts, which tables should I import from our database, to transfer over members list, posts, forums etc.

Dismounted 12-15-2008 08:25 AM
All of them, if you want to keep everything.

JPforFree 12-15-2008 08:39 AM
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 7
STR: /><
SQL:

<br /><strong>Warning</strong>: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Unable to save result set in <strong>[path]/includes/class_core.php</strong> on line <strong>408</strong><br /><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>TDRgaming.com | Forums Database Error</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" />
<style type="text/css">
<!--
body { background-color: white;

SQL query:

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

when importing the .sql file backup, I get this error, anyone have a clue as to what its meaning is?

Marco van Herwaarden 12-15-2008 08:49 AM
How was the backup created?
How is it restored?
What is the MySQL version on both servers?
How was the backup file transfered to the new host?

JPforFree 12-15-2008 02:31 PM
Through both phpmyadmin, and through the admincp (both got super similar errors)
Through PhPmyadmin
ver. 5.0.67
When you say backupfile...which are you asking about?

SEOvB 12-15-2008 07:14 PM
Quote:
Originally Posted by JPforFree (Post 1685913)
Through both phpmyadmin, and through the admincp (both got super similar errors)
Through PhPmyadmin
ver. 5.0.67
When you say backupfile...which are you asking about?
How large was the backup, phpMyAdmin can sometimes cause errors larger backups. SSH using mysql dump is the preferred method.

Are both the old host, and the new host using 5.0.67 MySQL

When you created the backup, you should have gotten a .sql or a .sql.gz file to restore on your new host. Did you upload it using a FTP, or are you trying to restore via phpMyAdmin?

Marco van Herwaarden 12-16-2008 07:23 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


All times are GMT. The time now is 03:29 AM.

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.02583 seconds
  • Memory Usage 1,725KB
  • 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)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)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