Some quickies that have been sitting in my blog poster for a while…
- Quick Polls are an interesting bit of the MySQL site. Look at all the interesting polls, and see where the community come from!
- I was doing a search on “migrate from Postgresql to MySQL” on Google, and all I seemed to have found in general were sites that showed how to do it the other way around!
- mytop is great. RPM distributions have
/var/run/mysqld/mysqld.sock, but it is located at/tmp/mysqld.sockif it comes out of the tarball. Run it asmytop -S /tmp/mysqld.sockif you’ve installed it from the tarball. - Seeing:
Starting MySQL * Couldn't find MySQL manager or serveras an error? Suggest you look at/etc/my.cnf, under[mysql.server], comment out (#) thebasedir=/var/liband like magic, things should work again. - Looking for Powered by MySQL logos? Look no further than the Official Logos.
- Dispelling the Myths is a great article addressing common misconceptions with MySQL – transactions, supports large installations, excellent support team, is open source and much more. Give it a read.
- Talked to Gafton about Conary’s new PostgreSQL package and skirted around the idea of using versioned data directories for MySQL; he said it was generally unnecessary as between upgrades MySQL doesn’t break tables. But it does seem like good practice…