Can't Move To New Host - SQL Error #1064

My old host is using:
MySQL 5.0.24a-log
phpMyAdmin 2.4.0

My new host is using:
4.1.21-standard-log
phpMyAdmin - 2.9.0.2

When I export the database on my old host to a file and then try to import it to my new host, I get the following error:

I assume the error is caused by the fact that I am going from a newer version of SQL to an older version. Is there any work-around for this?

I simply want to move my databases from my old host to my new host. Does anyone know how I can do this? Or, at least, does anyone know where I can find out how to do it?

 

You can ask for a mysql upgrade with your new hosting.

 

Since I posted before, they did upgrade my hosting. They put me on a new server with SQL 5.

I still get the error, so now I don't have a clue what's causing it.

I've tried multiple databases, but none will import without causing that error.

 

When you say multiple databases, you meant those of different scripts? like one for WordPress, another for Joomla etc.

Not sure if this makes a difference: Don't save one entire DB as a .sql file and import it. Go inside a DB, select all the tables, save as .sql, create a new DB w/ the same name in your new host, then import the .sql inside it.

If still no dice and if no one has a better ideas and you want to, I can try if you give me access.

 

That's aready what I'm doing, but thanks.

If you wouldn't mind, just PM me.

 

My new host figured out the problem. The solution:

It worked!

Thanks everybody for your help and suggestions!

Added on edit: My new host is hostican. They have been great so far. Their customer support is very quick and effective.

 

Thanks for posting the fix. Adding this one to my list in case I come across it.