vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Weird error when moving to another location (https://vborg.vbsupport.ru/showthread.php?t=95958)

utw-Mephisto 09-09-2005 11:56 PM
Weird error when moving to another location
 
Ok,

I was getting a dump file from the complete database via phpmyadmin.
As the database is quite big I got a lot of erros like

Code:
"ERROR 1153 at line 6441: Got a packet bigger than 'max_allowed_packet'"


After I increased the max_allowed_packet to 16MB instead of 1MB, I could insert the dump file via ssh almost without problems.

Now I have two questions :

1. When importing the dump file into the database, I get this error :

Code:
Query OK, 9 rows affected (0,00 sec)
Records: 9  Duplicates: 0  Warnings: 0
Query OK, 0 rows affected, 1 warning (0,01 sec)
Query OK, 0 rows affected, 1 warning (0,00 sec)
Query OK, 0 rows affected, 1 warning (0,00 sec)
Query OK, 0 rows affected, 1 warning (0,00 sec)
Query OK, 0 rows affected, 1 warning (0,00 sec)
Query OK, 79 rows affected (0,00 sec)
Records: 79  Duplicates: 0  Warnings: 0
Unfortunately it does not say what kind of error. Is there any log I can check ? I don't see any problems on the board so far, but warning is warning imho.

2. When exporting the dumpfile using phpmyadmin, which options do I use ?

http://img259.imageshack.us/img259/2622/untitled6dg.jpg

like extended etc. ?

Marco van Herwaarden 09-10-2005 06:12 AM
You problem is that some information was already inserted into the database the first time. When you tried again with SSH, there where duplicate rows.

You should start with an empty database, or select 'Add DROP TABLE' when creating the export.

utw-Mephisto 09-10-2005 06:15 AM
1. What do I have to chose in the data section ? Complete inserts or extended >?

2. I DID use an empty database. I just created the database a step before the import


All times are GMT. The time now is 08:41 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.01369 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
  • (2)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)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