DB migration error

[hafzon]

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 ;;

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]

You will have to ask at the bigdump support website.

[vBsquad]

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

[hafzon]

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 1222102238 at 1222102238 ---------------

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]

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

Specifically what caused you trouble with MySQLDumper?

[hafzon]

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]

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.