473,320 Members | 1,922 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Importing Difficulty >Backwards Compatibility?

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_aspsupport` 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
Jul 20 '05 #1
4 2204
Nick Kerzman via MySQLMonster.com 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.
Jul 20 '05 #2
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
Jul 20 '05 #3
Nick Kerzman via MySQLMonster.com 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.
Jul 20 '05 #4
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
Jul 20 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

63
by: Tristan Miller | last post by:
Greetings. Do any popular browsers correctly support <q>, at least for Western languages? I've noticed that Mozilla uses the standard English double-quote character, ", regardless of the lang...
61
by: Toby Austin | last post by:
I'm trying to replace <table>s with <div>s as much as possible. However, I can't figure out how to do the following… <table> <tr> <td valign="top" width="100%">some data that will...
30
by: Toni Mcintyre | last post by:
i'm having 2 problems with the http://validator.w3.org 1. if i have: <meta http-equiv="Content-Script-Type" content="text/javascript"> then why do i need <script type=text/javascript>...
822
by: Turamnvia Suouriviaskimatta | last post by:
I 'm following various posting in "comp.lang.ada, comp.lang.c++ , comp.realtime, comp.software-eng" groups regarding selection of a programming language of C, C++ or Ada for safety critical...
14
by: laurence | last post by:
I am implementing a comprehensive image-map generator utility, so have been studying W3C HTML 4.01 Specification (http://www.w3.org/TR/html4/struct/objects.html#h-13.6) on image maps (among other...
14
by: Stefan Mueller | last post by:
With the following code I can add a new row to an existing table. That really works great. Many thanks to all who helped me so far. But my problem is that the added cells do somehow not have the...
150
by: tony | last post by:
If you have any PHP scripts which will not work in the current releases due to breaks in backwards compatibility then take a look at http://www.tonymarston.net/php-mysql/bc-is-everything.html and...
36
by: Roedy Green | last post by:
The only browser I have encountered that supports <colgroup><col class="behold"></colgroup> to apply a CSS style to a whole column, is Microsoft Internet Explorer. I have been told it SHOULD NOT...
6
by: puzzlecracker | last post by:
Say we have this structure: Struct Foo{ .... friend ostream& operator << (ostream& s, Foo & m); ..... }; friend ostream& operator << (ostream& s, Foo & m){
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.