importing DB problem from ssh
 

im getting this error why?

How was the backup created?
How was the backup file transfered to the new server (assuming you are moving)?
What is the MySQL version for both source and target server?

i created backup from phpmyadmin

im trying to transfer by using ssh(putty)

I dunt know abut MySQL version

I would start by creating the backup also from SSH.

You need to make sure binary strings are dumped as hexadecimal using the --hex-blob flag. I assume there is something for this in phhpmyadmin, but it would be a guess as I have never used it.

how do i backup from ssh?

See here: http://www.vbulletin.com/docs/html/m...nce_ssh_backup

but i dunt have the access to ssh on that hosting i was on.now im using a dedicated server for my forums and trying to use the same database

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

since i dunt have the shell access i downloaded the database from phpmyadmin and tried to import by using ssh and bigdum.php.both methods gave me errors.