-
Archives
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- March 2010
- February 2010
- December 2009
- November 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- February 2009
- January 2009
- November 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- January 2005
- October 2004
-
Meta
Tag Archives: mysql
HOWTO: Configure an Amazon RDS instance to use UTF-8
RDS has been working out pretty well for AdGrok — it’s a one-click MySQL 5.1 instance that seems pretty promising: Automatic replication and failover to another deployment zone (colo) Easy to set up firewall configuration Easy to scale up (but … Continue reading
Simple MySQL backup to gmail on Ubuntu/Debian
Backing up your MySQL database (if it’s a reasonable size, like < 100s of MB) can be done with a cronjob that runs mysqldump, gzip, and mpack.
HOWTO enable the query log on MySQL on Mac OS X
Tailing the MySQL query log in real time can be a lifesaver for any developer, and it’s pretty easy to do: Make a file for the mysqld process to write to: sudo touch /var/log/mysql-query.log sudo chown _mysql /var/log/mysql-query.log If you’ve … Continue reading
Apache2, PHP, and MySQL on Mac OS X using MacPorts
1. Install MacPorts Follow the instructions here: http://www.macports.org/install.php. 2. Install apache2 sudo port install apache2 Note that the macports instructions suggest installing the launchctl script now, but we’ll do that after mysql and php are installed. 3. Install and configure … Continue reading
Solution for mysql_upgrade errno: 13
Are you upgrading MySQL, and seeing this? [plain highlight="6,7"] $ mysql_upgrade Looking for ‘mysql’ as: mysql Looking for ‘mysqlcheck’ as: mysqlcheck Running ‘mysqlcheck’… …. Could not create the upgrade info file ‘/usr/local/mysql/data/mysql_upgrade_info’ in the MySQL Servers datadir, errno: 13 [/plain] … Continue reading