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

== Quote from nobody (nobody@nobody.com)'s article
> How do I migrate my databases from currently 3.23 to a new server running 5?

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

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" <hamzee@sbcglobal.net> wrote in message
news:U2z9i.16285$C96.14600@newssvr23.news.prodigy. net...
> == Quote from nobody (nobody@nobody.com)'s article
>> How do I migrate my databases from currently 3.23 to a new server running
>> 5?
>
> 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

== Quote from nobody (nobody@nobody.com)'s article
> 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" <hamzee@sbcglobal.net> wrote in message
> news:U2z9i.16285$C96.14600@newssvr23.news.prodigy. net...
> > == Quote from nobody (nobody@nobody.com)'s article
> >> How do I migrate my databases from currently 3.23 to a new server running
> >> 5?
> >
> > 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



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

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

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

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/...from-3-23.html

And upgrade to 4.0 first.

when I try to import it

mysql < databasegump.sql

how do I port a dumpfile? Its huge.
"lark" <hamzee@sbcglobal.net> wrote in message
news:9HC9i.11232$4Y.5981@newssvr19.news.prodigy.ne t...
> == Quote from nobody (nobody@nobody.com)'s article
>> 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" <hamzee@sbcglobal.net> wrote in message
>> news:U2z9i.16285$C96.14600@newssvr23.news.prodigy. net...
>> > == Quote from nobody (nobody@nobody.com)'s article
>> >> How do I migrate my databases from currently 3.23 to a new server
>> >> running
>> >> 5?
>> >
>> > 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
>
>
>
> 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

On Jun 5, 9:48 pm, "nobody" <nob...@nobody.com> wrote:
> How do I migrate my databases from currently 3.23 to a new server running 5?


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

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


"Jiri Matejka" <matejka@stemmark.cz> wrote in message
news:1181201939.736485.303250@g4g2000hsf.googlegro ups.com...
> On Jun 5, 9:48 pm, "nobody" <nob...@nobody.com> wrote:
>> How do I migrate my databases from currently 3.23 to a new server running
>> 5?
>
>
> 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
>

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" <matejka@stemmark.cz> wrote in message
news:1181201939.736485.303250@g4g2000hsf.googlegro ups.com...
> On Jun 5, 9:48 pm, "nobody" <nob...@nobody.com> wrote:
>> How do I migrate my databases from currently 3.23 to a new server running
>> 5?
>
>
> 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
>

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" <matejka@stemmark.cz> wrote in message
news:1181201939.736485.303250@g4g2000hsf.googlegro ups.com...
> On Jun 5, 9:48 pm, "nobody" <nob...@nobody.com> wrote:
>> How do I migrate my databases from currently 3.23 to a new server running
>> 5?
>
>
> 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
>