Date: Mon, 30 Jul 2007 09:15:05 +0200 From: "=?ISO-8859-1?Q?Andreas_Wider=F8e_Andersen?=" <wodfer@gmail.com> To: freebsd-questions <freebsd-questions@freebsd.org> Subject: Best way to upgrade mysql-server? Message-ID: <23ed14b80707300015q614a62bfv5771d1ffc3e35a08@mail.gmail.com>
next in thread | raw e-mail | index | archive | help
Hi, I recently upgraded from 3.23 to 4.027. My steps were: 1. Stopped the mysql server 2. make deinstall in mysql-server 3.23 3. make deinstall in mysql-client 3.23 4. make install clean in mysql-server 4.0.27 5. Ran the mysql_fix_privilege_tables 6. Started the mysql server again (and ofcourse backups before step 1) Things seem to be working fine. In regards to the existing database files, are there more "correct" ways of doing an upgrade on a production server? Also, does anyone have some good advice on optimizing tables, correcting and speeding up things after an upgrade? Thanks and best regards, Andreas
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?23ed14b80707300015q614a62bfv5771d1ffc3e35a08>