Rails 2 to Rails 3 mysql migration?

I have an old rails project that is currently in Rails 2.3

I'm about to undertake updating the project to Rails 3.2.

The old project's production server is on mysql 5.0 and has a medium
size database (not huge, but certainly big enough that I need to keep
the data after I upgrade the app).

If I do a modern deployment of Rails 3.2 (apache and latest stable mysql
on latest suse linux) I'm wondering if I will be able to just copy the
db over from the old server, or if there will be a need for some sort of
a migration?

Any info on what I'm up against there will be much appreciated.

Thanks!

I have an old rails project that is currently in Rails 2.3

I'm about to undertake updating the project to Rails 3.2.

The old project's production server is on mysql 5.0 and has a medium
size database (not huge, but certainly big enough that I need to keep
the data after I upgrade the app).

If I do a modern deployment of Rails 3.2 (apache and latest stable mysql
on latest suse linux) I'm wondering if I will be able to just copy the
db over from the old server, or if there will be a need for some sort of
a migration?

Any info on what I'm up against there will be much appreciated.

In that situation I would use mysqldump to get a dump of the db and
create the new one from that. There may well be better ways however.

Colin

Colin Law wrote in post #1075905:

db over from the old server, or if there will be a need for some sort of
a migration?

Any info on what I'm up against there will be much appreciated.

In that situation I would use mysqldump to get a dump of the db and
create the new one from that. There may well be better ways however.

Colin

Thanks Colin!

This is sort of:
binary data --> long list of SQL statements
long list of SQL statements --> binary data using new version of mySQL

yes?

Is this primarily to solve any compatibility issues between versions of
mySqL rather than from rails 2.x to rails 3.x?

thanks!

Colin Law wrote in post #1075905:

db over from the old server, or if there will be a need for some sort of
a migration?

Any info on what I'm up against there will be much appreciated.

In that situation I would use mysqldump to get a dump of the db and
create the new one from that. There may well be better ways however.

Colin

Thanks Colin!

This is sort of:
binary data --> long list of SQL statements
long list of SQL statements --> binary data using new version of mySQL

yes?

yes

Is this primarily to solve any compatibility issues between versions of
mySqL rather than from rails 2.x to rails 3.x?

Yes, rails should not care which version of mysql you are using. As a
side note I use this as a way of backing up the database (by backing
up the sql statements) as an emergency fallback in case the binary
backup fails for some reason. I am not sure there is a good logical
argument for this but it just seems like a good idea to have something
one can actually read as a backup.

Colin

Colin Law wrote in post #1075952:

Not that I can think of, but you will no doubt find out as you do the
upgrade :slight_smile: If you google for how to upgrade from 2 to 3 you will find
numerous guides on how to do that. Look through those to see if there
is any reference to database differences.

Colin