1,277
edits
Changes
m
→Updating MySQL on Mac OS X: formatting and typo fixes
===References===
*http://bugzilla.wikimedia.org/show_bug.cgi?id=11428
==Updating MySQL on Mac OS X==
I just went through a prolonged ordeal to upgrade MySQL from 5.1.30 to 5.1.47, so I'm going to write down some steps so that I don't hit so many dead-ends in the future. Note that this presumes that you have already done a DB dump of your wiki database (i.e. SequelPro's Export… command).
The installer does not detect the presence of an older installation, and as a result, leaves the old data directory untouched. In retrospect, you could probably just move it and all would be well. Alternatively, you can recreate your databases as well. Here's what I did.
* First, to run the <tt>mysql_upgrade</tt> script, enable the root user in Directory Utility (which is now in CoreServices, or accessible from the Accounts prefpane).
* <tt>su -</tt>
* <tt>su _mysql -c "/usr/local/mysql/mysql_upgrade"</tt>
* <tt>logout</tt>
* Restart MySQL
Now, [http://dev.mysql.com/doc/refman/5.1/en/default-privileges.html secure the root/guest accounts], [http://dev.mysql.com/doc/refman/5.1/en/create-user.html create the wiki user], and [http://www.mediawiki.org/wiki/Manual:Installing_MediaWiki#MySQL create the wiki db and grant privileges]. Go into LocalSettings.php and change the connection settings so that it doesn't try to connect to the DB until you are done with the rest. Then
* <tt>sudo mkdir /usr/local/mysql/etc</tt>
* <tt>sudo chown -R mysql /usr/local/mysql/etc</tt>
* <tt>su -</tt>
* <tt>su -m _mysql -c "touch /usr/local/mysql/etc/my.cnf"</tt> (you can safely ignore the <tt>getcwd</tt> error)
* <tt>logout</tt>
* Turn off root user
* Add this to the <tt>my.cnf</tt> file:
:<code>[mysqld]<br/>max_allowed_packet=10737418</code>
* Restart MySQL again
* Fire up SequelPro and import the SQL dump made earlier. Errors related to disallowed <tt>DROP</tt> operations are fine.
* Change back the connection parameters in LocalSettings.php and refresh the wiki!
{{cs projects}}
[[Category:MediaWiki User's Guide]]