Mysql Database restore issues,

[ptemplin7]

I am trying to migrate from a production server to create a development box. I have gotten sugar files to update OK just need to restore the database. The original backup was an --all-databases backup. I went ahead and deleted out the the other databases.
Tried mysqlimport and mysql as suggested elsewhere but no luck.
Using phpMyAdmin tool I get the following error.

-- MySQL dump 10.9
--
-- Host: localhost Database:
-- ------------------------------------------------------
-- Server version 4.1.20
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

MySQL said: Documentation
#1064 - 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 '' at line 1

I assume its complaining about the /* stuff. The sql file was create using mysqldump

Any ideas?

Using Sugarcrm 4.5.1a, Trixbox 2.0, Linux Cent OS4.4, Apache webserver PHP 4.3.11

Thanks Paris

[ptemplin7]

OK my bad. I think I have this figured out!

Forgot to make sure I had used dos2unix to convert the file! Thus stripping out all those nasty LF characters.

On a seperate note:

What do you all prefer to use: mysqldump --all-databases or mysqldump sugarcrm along with the various other options?

Thanks for reading,
Paris