MySQL 101
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…
Thank you!! I’ve been getting the “Couldn’t find MySql manager or server” error and it’s been driving me nuts. Your solution worked like a charm! Thanks for posting it :-)