MySQL
Install and configure MySQL 5 with MacPorts
posted September 25th, 2007 at 9:29 pm by chad7/18/09 - Having trouble starting MySQL on system startup? Rob Wilkerson shows how he gets around the issue.
4/2/08 - UPDATED - Replaced symlink to MySQL socket with proper MySQL configuration file settings. Thanks Doug!
10/20/07 - UPDATED - Added full path to aliases, thanks Joel!
10/7/07 - UPDATED - Clarified +server option and executable names, thanks Thom!
I decided to move my MySQL server installation from the server I installed from MySQL.com to macports. Why? I believe MacPorts will simplify future upgrades. I'd also like to keep my LAMP installs in the same location. If you haven't already, install and configure MacPorts. Here are the steps I'll go over:
- Intall MySQL 5
- Create the initial MySQL databases
- Options for starting MySQL
- Confirm that MySQL is running
- Set Basic MySQL Security
Another MySQL Backup Script
posted December 24th, 2006 at 7:50 am by chadI've been meaning to backup my sites' databases for quite some time now. Today I was finally overcome with guilt and the fear of something going horrible wrong, so I finally decided to put a backup script into place. My hosting provider provides backups, and fortunately I've never needed to request a restore. You may ask "Then why are you worried about backups?". The answer is simple—there are some things you should count on in this world–things will go wrong from time to time. Yes, my hosting provider is a reliable and stable company providing a reliable and stable hosting environment, but things can change, and one should always be prepared.




Recent comments
3 days 22 hours ago
1 week 20 hours ago
5 weeks 6 days ago
5 weeks 6 days ago
7 weeks 3 days ago
7 weeks 4 days ago
7 weeks 4 days ago
7 weeks 5 days ago
8 weeks 3 days ago
10 weeks 2 days ago