Voytek Eymont wrote:
I'm looking at migrating MySQL 3.x server to new machine running MySQL 4.x;
at this time I aim to dump one by one user databases and insert data into
MySQL 4.x,
if there are any MySQL experts here, any comments please ?
If you read the MySQL 4 documentation it has a section on upgrading from
version 3. Things to look out for are use of reserved words in
table/column/database names, as there are a lot more reserved words in
version 4; you may also run into problems with autoincrement columns due
to the differing starting values (which can be fixed during import by
setting the SQL mode in the session variables).
What I did last time is run mysqlbackup on the source and pipe that into
mysql via ssh on the destination. Any things that needed fixed up to
work on MySQL that were simple search/replace jobs I piped it into sed
or perl before the destination server.
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
