Configure Commands

CFLAGS=”-arch x86_64″
CXXFLAGS=”-arch x86_64″
./configure -prefix=/usr/local/mysql
-with-server-suffix=-standard
-enable-thread-safe-client
-enable-local-infile
-enable-shared
-with-zlib-dir=bundled
-with-big-tables
-with-readline
-with-plugins=all
-with-unix-socket-path=/tmp/mysql.sock
-without-docs

This prompted a more robust set of steps to test out MySQL updates:

  1. Read Patch Notes, make sure it does not break anything, see if the update fixes unrelated bugs, or things that would actually affect the database. If its not critical, then it can wait days…
  2. Download new source and keep files in /home/lasota/source
  3. backup old databases with
    /usr/local/mysql/bin/mysqldump –all-databases –skip-lock-tables -u root -p > allBases.sql
  4. config, make, make install as noted above
  5. do a /usr/local/mysql/bin/mysql_upgrade -u root -p
  6. test wordpress instance with admin pages, user pages