how to migrate databases from 3.23 to 5

#11 (**permalink**) 02-28-2008, 10:59 AM

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

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

no

#12 (**permalink**) 02-28-2008, 10:59 AM

On Jun 7, 7:43 pm, "nobody" <nob...@nobody.com> wrote:
> 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" <mate...@stemmark.cz> wrote in message
>
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

#13 (**permalink**) 02-28-2008, 10:59 AM

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

>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?

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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode