Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-29-2011, 05:35 PM
Sharkyman Sharkyman is offline
 
Join Date: Jun 2010
Posts: 81
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Help please

My hosts closed but luckily before they folded I backed up the database, as I did every week. I have installed vbulletin on a server I have bought elsewhere and that went fine. BUT I can't get it to accept the database (300mb) I have sat here on my laptop. I've had to split it using SQL Dump Splitter (as the maximum is 10mb) but get this error code for almost everything.

Help.
Reply With Quote
  #2  
Old 01-29-2011, 06:10 PM
markbolyard's Avatar
markbolyard markbolyard is offline
 
Join Date: Apr 2005
Location: Maryland
Posts: 629
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Whats the error you get?
Reply With Quote
  #3  
Old 01-29-2011, 07:57 PM
Sharkyman Sharkyman is offline
 
Join Date: Jun 2010
Posts: 81
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Oh the error code is

Quote:
#1136 - Column count doesn't match value count at row 1
Reply With Quote
  #4  
Old 01-29-2011, 08:18 PM
TheLastSuperman's Avatar
TheLastSuperman TheLastSuperman is offline
Senior Member
 
Join Date: Sep 2008
Location: North Carolina
Posts: 5,844
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Try using Big Dump or MySQL Dumper to import the file then there's no need to split it up .

Some links and info here that should be useful:
https://vborg.vbsupport.ru/showthread.php?t=227933
Reply With Quote
  #5  
Old 01-29-2011, 08:35 PM
markbolyard's Avatar
markbolyard markbolyard is offline
 
Join Date: Apr 2005
Location: Maryland
Posts: 629
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Your problem is (I think) you are importing a database from a different version of mysql. Make sure the mysql version you made the backup from and the new host are the same.

That error has nothing to do with it's size.
Reply With Quote
  #6  
Old 01-29-2011, 08:44 PM
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Posts: 2,559
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Actually the error doesn''t have anything to do with versions of Mysql but it is most likely due to the db backup not being split properly.

We would need to see the exact full error to tell you where it went wrong. But try TheLastSuperman's suggestion to restore the backup as a whole.
Reply With Quote
  #7  
Old 01-29-2011, 08:56 PM
TheLastSuperman's Avatar
TheLastSuperman TheLastSuperman is offline
Senior Member
 
Join Date: Sep 2008
Location: North Carolina
Posts: 5,844
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by markbolyard View Post
Your problem is (I think) you are importing a database from a different version of mysql. Make sure the mysql version you made the backup from and the new host are the same.

That error has nothing to do with it's size.
We're not aware the condition of the files he's using after splitting there could be an extra " or ' the program placed for something selected in options etc so best bet is to use one of the methods I listed and then no need to split the file and you can bypass the 10mb limit although it could be as simple as you say we need to see the full error or more info really .
Reply With Quote
  #8  
Old 01-30-2011, 12:56 PM
Sharkyman Sharkyman is offline
 
Join Date: Jun 2010
Posts: 81
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

OK. I've installed it (MySQL Dump) and I can't figure out how to upload the database I have here on my lappy.
Reply With Quote
  #9  
Old 02-01-2011, 12:56 PM
Sharkyman Sharkyman is offline
 
Join Date: Jun 2010
Posts: 81
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Reet, installed it and tried to install the database. It gets to record 700K odd and I get this error message;

Quote:
Sql: <br /> Erweiterte Inserts: 0 unknown SQL-Command: Warning: Cannot modify header information - headers already sent by (output started at /usr/share/phpmyadmin/export.php:150) in /usr/share/phpmyadmin/libraries/ob.lib.php on line 61
Any ideas?
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 09:31 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.09330 seconds
  • Memory Usage 2,239KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (9)post_thanks_box
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (9)postbit
  • (9)postbit_onlinestatus
  • (9)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete