Importing Difficulty >Backwards Compatibility?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Nick Kerzman via MySQLMonster.com
    #1

    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_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
    Tags: None
    • Bill Karwin
      #2
      Re: Importing Difficulty >Backward s Compatibility?

      Nick Kerzman via MySQLMonster.co m wrote:[color=blue]
      > Is it an issue with versions of MySQL and backwards compatibility?[/color]

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

      Bill K.

        Comment

        • Nick Kerzman via MySQLMonster.com
          #3
          Re: Importing Difficulty >Backward s Compatibility?

          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

            Comment

            • Bill Karwin
              #4
              Re: Importing Difficulty >Backward s Compatibility?

              Nick Kerzman via MySQLMonster.co m wrote:[color=blue]
              > Is there any easy way to covert or modify the data I exported so I can go back?[/color]

              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:
              fw_error_www
              http://dev.mysql.com/doc/mysql/en/Charset-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.

                Comment

                • Nick Kerzman via MySQLMonster.com
                  #5
                  Re: Importing Difficulty >Backward s Compatibility?

                  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

                    Comment

                    Previous template Next
                    Working...