vb.org Archive - DB migration error

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

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

- - DB migration error (https://vborg.vbsupport.ru/showthread.php?t=191544)

hafzon

09-22-2008 03:07 AM

DB migration error

i moved my forum from server to another

i used bigdump.php to dump my SQL DB becoz it's big

but i get this errot

Error at the line 6264: DELIMITER ;;

Code:

Query: --

--

DELIMITER ;;



MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER' at line 3



Stopped on error

may i have help wiz that ?

Marco van Herwaarden

09-22-2008 09:19 AM

You will have to ask at the bigdump support website.

vBsquad

09-22-2008 10:51 AM

Try finding that line and editing it then attempting to restore again. Otherwise try using MySQLDumper.

hafzon

09-22-2008 01:09 PM

i tried to use MySQLDumper .. but i couldn't understand how it works
can u plz gimme link to guide explaining how to use it
ty

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

i was checkin same problems here .. i found some guides about backuping and restoring via SSH ..
but u have small question : do i have 2 backup my DB using SSH to be able to restore it via SSH too from another server?

" mine is generated from full backup from cpanel not from SSH "

ty

vBsquad

09-22-2008 05:20 PM

If you have root access to the server then doing it via SSH is fine.

Specifically what caused you trouble with MySQLDumper?

hafzon

09-22-2008 08:20 PM

na i don't have root axx .. but i may contact wiz the admin

concerning the SQLdumper .. i don't no how it's workin .. lol

i need guide or tut. for how 2 resotre DB via it

ty

vBsquad

09-22-2008 08:53 PM

Basically you need to transfer/upload the database you want to restore to the /work/backups/ folder then use the restore feature.

However you may need to use MySQLDumper to backup on the old server first in order to fully resolve this.

Apart from that you may just need to get your hands dirty and manually edit the SQL file.

All times are GMT. The time now is 09:54 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01045 seconds Memory Usage 1,717KB 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_code_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
Messages: