Importing Difficulty >Backwards Compatibility?

[Nick Kerzman via MySQLMonster.com]

Any assistance would be greatly appreciated. I'm relatively new to working with MySQL.

I exported my DB with phpMyAdmin 2.6.0-pl3 running MySQL 4.1.7

I'm trying to import it with phpMyAdmin 2.5.7-pl1 running MySQL 4.0.20

Is this possible? I seem to be getting this error:

MySQL said:

SQL-query :
CREATE DATABASE `win2ksh_aspsup port` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ ci
MySQL said:

#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 'DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ ci' at line
Is it an issue with versions of MySQL and backwards compatibility?

Thanks, I appreciate the help.

~Newbie Nick

--
Message posted via http://www.mysqlmonster.com

[Bill Karwin]

Nick Kerzman via MySQLMonster.co m wrote:

Is it an issue with versions of MySQL and backwards compatibility?

Yes. Read this page: http://dev.mysql.com/doc/mysql/en/CREATE_DATABASE.html

Bill K.

[Nick Kerzman via MySQLMonster.com]

Thanks Bill,

I took a look at that article and some other supporting information. It appears it has to do with a new way of representing character sets and collations.

Is there any easy way to covert or modify the data I exported so I can go back?

Thanks.

Nick

--
Message posted via http://www.mysqlmonster.com

[Bill Karwin]

Nick Kerzman via MySQLMonster.co m wrote:

Is there any easy way to covert or modify the data I exported so I can go back?

I haven't written any application working with non-default character
sets or collations, but the documentation seems to say that the MySQl
4.1 support for character sets is far more sophisticated than in MySQL
4.0. I can't find any indication that you can specify a database-wide
default character set or collation in MySQL 4.0.

There's a page on upgrading from 4.0 to 4.1:
http://dev.mysql.com/doc/mysql/en/Ch...upgrading.html

But I don't know what solution exists if you need to _downgrade_. The
easiest path is probably to upgrade your new server to MySQL 4.1, if you
have the privilege to do that.

Other than that, you can read the documentation as easily as I can.
Section 10 seems to be about character set support.

Regards,
Bill K.

[Nick Kerzman via MySQLMonster.com]

Thanks again Bill for the assistance.

I read the documentation and that's what I gathered too. I contacted the host and they said they would not be upgrading to MySQL 4.1.. anytime soon. So they reccomended installing the newer release since I have root access or trying to import a CSV.

I'd rather not go through upgrading MySQL but I will take a look at the documentation.

Thanks

Nick K

--
Message posted via http://www.mysqlmonster.com