Professional Web Applications Themes

how to migrate databases from 3.23 to 5 - MySQL

How do I migrate my databases from currently 3.23 to a new server running 5?...

  1. #1

    Default how to migrate databases from 3.23 to 5

    How do I migrate my databases from currently 3.23 to a new server running 5?



    nobody Guest

  2. #2

    Default Re: how to migrate databases from 3.23 to 5

    == Quote from nobody (com)'s article 

    use mysqldump to get a dump of all your databases and then use the mysql command
    prompt to import them to version 5.
    --
    POST BY: lark with PHP News Reader
    lark Guest

  3. #3

    Default Re: how to migrate databases from 3.23 to 5

    I tried that but gave me an error

    ERROR 1064 (42000) at line 67: 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 'trigger int(5) default NULL,
    UNIQUE KEY usename (username)
    ) TYPE=MyISAM' at line 93



    Are there some issues here?

    "lark" <net> wrote in message
    news:U2z9i.16285$news.prodigy.net... 
    >
    > use mysqldump to get a dump of all your databases and then use the mysql
    > command
    > prompt to import them to version 5.
    > --
    > POST BY: lark with PHP News Reader[/ref]


    nobody Guest

  4. #4

    Default Re: how to migrate databases from 3.23 to 5

    == Quote from nobody (com)'s article 
    > >
    > > use mysqldump to get a dump of all your databases and then use the mysql
    > > command
    > > prompt to import them to version 5.
    > > --
    > > POST BY: lark with PHP News Reader[/ref][/ref]



    At what stage did you get this error: dumping or importing. Also, would you post
    the dump file?
    --
    POST BY: lark with PHP News Reader
    lark Guest

  5. #5

    Default Re: how to migrate databases from 3.23 to 5

    "nobody" <com> wrote in
    news:f44em4$h4a$Stanford.EDU:
     

    http://dev.mysql.com/doc/refman/5.0/en/upgrade.html

    Of particular note to you:

    **

    As a general rule, we recommend that when upgrading from one release series
    to another, you should go to the next series rather than skipping a series.
    For example, if you currently are running MySQL 3.23 and wish to upgrade to
    a newer series, upgrade to MySQL 4.0 rather than to 4.1 or 5.0.

    **

    so.... you should visit
    http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-3-23.html

    And upgrade to 4.0 first.


    Good Guest

  6. #6

    Default Re: how to migrate databases from 3.23 to 5

    when I try to import it

    mysql < databasegump.sql

    how do I port a dumpfile? Its huge.
    "lark" <net> wrote in message
    news:9HC9i.11232$news.prodigy.net... [/ref]
    >
    >
    >
    > At what stage did you get this error: dumping or importing. Also, would
    > you post
    > the dump file?
    > --
    > POST BY: lark with PHP News Reader[/ref]


    nobody Guest

  7. #7

    Default Re: how to migrate databases from 3.23 to 5

    On Jun 5, 9:48 pm, "nobody" <com> wrote: 


    You can use mysqldump to transfer the data directly from 3.23 to 5.0,
    eg:

    /usr/bin/mysqldump --verbose --skip-opt --add-drop-table --
    compatible=mysql323 --disable-keys --quick --host=SOURCE_HOST -u
    USERNAME --password=PASSWORD SOURCE_DATABASE_NAME | mysql --
    host=TARGET_HOST -u USERNAME --password=PASSWORD TARGET_DATABASE_NAME

    Use --compatible=mysql323 switch to force mysqldump to use this
    version format. You have to run mysqldump from the 5.x version.

    Jiri Matejka

    Jiri Guest

  8. #8

    Default Re: how to migrate databases from 3.23 to 5

    would I be able to just copy the databse files from the 323 server to the
    5.0 server?


    "Jiri Matejka" <cz> wrote in message
    news:googlegroups.com... 
    >
    >
    > You can use mysqldump to transfer the data directly from 3.23 to 5.0,
    > eg:
    >
    > /usr/bin/mysqldump --verbose --skip-opt --add-drop-table --
    > compatible=mysql323 --disable-keys --quick --host=SOURCE_HOST -u
    > USERNAME --password=PASSWORD SOURCE_DATABASE_NAME | mysql --
    > host=TARGET_HOST -u USERNAME --password=PASSWORD TARGET_DATABASE_NAME
    >
    > Use --compatible=mysql323 switch to force mysqldump to use this
    > version format. You have to run mysqldump from the 5.x version.
    >
    > Jiri Matejka
    >[/ref]


    nobody Guest

  9. #9

    Default Re: how to migrate databases from 3.23 to 5

    Is there a way to have this command create the destination database as well?
    I dont have any databases on the target server just the defaults.
    "Jiri Matejka" <cz> wrote in message
    news:googlegroups.com... 
    >
    >
    > You can use mysqldump to transfer the data directly from 3.23 to 5.0,
    > eg:
    >
    > /usr/bin/mysqldump --verbose --skip-opt --add-drop-table --
    > compatible=mysql323 --disable-keys --quick --host=SOURCE_HOST -u
    > USERNAME --password=PASSWORD SOURCE_DATABASE_NAME | mysql --
    > host=TARGET_HOST -u USERNAME --password=PASSWORD TARGET_DATABASE_NAME
    >
    > Use --compatible=mysql323 switch to force mysqldump to use this
    > version format. You have to run mysqldump from the 5.x version.
    >
    > Jiri Matejka
    >[/ref]


    nobody Guest

  10. #10

    Default Re: how to migrate databases from 3.23 to 5

    I canot connect to the remote mysql server

    mysqldump: Got error: 2013: Lost connection to MySQL server during query
    when trying to connect

    "Jiri Matejka" <cz> wrote in message
    news:googlegroups.com... 
    >
    >
    > You can use mysqldump to transfer the data directly from 3.23 to 5.0,
    > eg:
    >
    > /usr/bin/mysqldump --verbose --skip-opt --add-drop-table --
    > compatible=mysql323 --disable-keys --quick --host=SOURCE_HOST -u
    > USERNAME --password=PASSWORD SOURCE_DATABASE_NAME | mysql --
    > host=TARGET_HOST -u USERNAME --password=PASSWORD TARGET_DATABASE_NAME
    >
    > Use --compatible=mysql323 switch to force mysqldump to use this
    > version format. You have to run mysqldump from the 5.x version.
    >
    > Jiri Matejka
    >[/ref]


    nobody Guest

  11. #11

    Default Re: how to migrate databases from 3.23 to 5

    "nobody" <com> wrote in
    news:f49e04$jar$Stanford.EDU:
     

    no
    Good Guest

  12. #12

    Default Re: how to migrate databases from 3.23 to 5

    On Jun 7, 7:43 pm, "nobody" <com> wrote: 
    I don't think so, you have to create the database before you start the
    dump. But it's not problem, is it? You can run mysql command prompt,
    eg. mysql --host=targethost --user=username --password=password and
    then run create database your_database_name;

    Jiri Matejka

    Jiri Guest

  13. #13

    Default Re: how to migrate databases from 3.23 to 5

    On Wed, 6 Jun 2007 10:26:56 -0700, "nobody" <com>
    wrote:
     

    trigger is a reserved word now.
    Choose another column name, or quote with backticks, as in
    `trigger` int(5) default NULL
    --
    ( Kees
    )
    c[_] Q: Why did the chicken cross the moebius strip?
    A: To get to the same side. (Czar Castic) (#65)
    Kees Guest

Similar Threads

  1. Migrate to FMS with AS 3.0
    By virtualgettysburg in forum Macromedia Flash Flashcom
    Replies: 2
    Last Post: December 27th, 04:15 AM
  2. How to migrate from one server to another
    By Art Shotwell in forum Macromedia Contribute General Discussion
    Replies: 2
    Last Post: February 17th, 12:57 AM
  3. Migrate Applilcations from MX to MX7
    By CRC in forum Coldfusion Server Administration
    Replies: 0
    Last Post: April 13th, 09:02 PM
  4. trouble to migrate from IIS 5 to 6
    By Albert Lai in forum ASP Components
    Replies: 9
    Last Post: August 12th, 04:41 AM
  5. Federated Databases, joins across databases etc
    By Benjamin Stewart in forum IBM DB2
    Replies: 2
    Last Post: August 1st, 03:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139