Unable to import DB on new hosting service

[elliatt]

I am looking to move my sites to a new hosting service.

I've set-up an account and SMF forum at a new site to test their services out. I performed a clean install and had no problem setting up 1.1.4.

On my old site I exported the forum database from within SMF (and also from mysql as well).

The new hosting service is not able to import the information.

I am receiving errors such as the below but lengthier (this is just the first portion). The hosting service keeps trying, I keep trying and yet nothing is happening.

Old service hosting: My SQL Client API version    3.23.58
New Service hosting: MySQL client version: 4.1.21

Does anyone have any ideas on what the problem could be? I've tried this with backups, fresh exports and even from a couple different forums I host on different sites. Though I am guessing that tech support should have figured it out - could it be possible the old hosting service is using too old a copy of the database software? Is there a way to convert an exported database to a newer version prior to uploading?

Koodi [Valitse] Laajenna

Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 9411
STR: =.
SQL: # ==========================================================
#
# Database dump of tables in `smf`
# April 09, 2008, 12:01:54 PM
#
# ==========================================================


#
# Dumping data in `smf_attachments`
#

INSERT INTO `smf_attachments`

[elliatt]

Nobody?

[Spaceman-Spiff]

Hi elliatt,

Did you use phpmyadmin to do the database dump/backup? If not, what did you use, and also what do you use on the new hosting.

[elliatt]

Yes, I used phpmyadmin on both hosting sites.

[Spaceman-Spiff]

It's possible that different major versions of MySQL will have slightly different db structures. The current version of phpMyAdmin only supports MySQL 4.1 and 5.x. It's possible that the dump file needs to be converted to get it working properly with MySQL 4.1.

If your database dump file isn't too huge, perhaps I can take a look at it.