Archive for January 2007

I’ve given up on the MySQL manual search

1/25/2007, 8:06 pm

It’s simply too inaccurate to be useful. I’ve switched to using google with firefox bookmark keywords instead. Here is how to set it up. In firefox click on Organize Bookmarks under the Bookmarks menu. Click the New Bookmark button and fill in the following values.

  • Name: MySQL Manual
  • Location: http://www.google.com/search?hl=en&q=site:dev.mysql.com%20%s
  • Keyword: mysql
  • Description: Keyword bookmark for using Google to search the MySQL manual.

Click ok and close the bookmark menu. Now instead of typing mysql.com/foo or using the search box on mysql.com you can simply type mysql foo into the address bar. Firefox will use your keyword to load the location in the bookmark replacing %s with foo resulting in results from the mysql manual. This can be done with any search engine. Simply do a test search and replace the search term with %s for the bookmark url.

Category: Geek, MySQL  |  2 Comments

Remapping the Firefox command key for different platforms.

1/21/2007, 5:30 pm

Firefox uses a different command key on different platforms. I often switch between Linux and Mac OS. Having Mac OS use the command key and linux use control was quite confusing. Firefox offers a solution. Point your browser to about:config. This allows you to change settings that aren’t part of the regular options dialogs. In the filter text box type

ui.key.accelKey

Then change the value to one of the following by double clicking on the ui.key.accelKey label.

17 Control
18 Alt
224 Meta (Mac OS command).

You may have to restart firefox for the settings to take effect.

Category: Firefox, Geek  |  Comment

BACKUP/RESTORE TABLE lose auto increment

1/5/2007, 10:10 pm

One small fact about backup table and restore table that isn’t listed in the manual is that these commands lose the auto increment value if rows at the head of the table are deleted. For example if you have auto increment values of 1,2,3,4 in a table the auto increment value is 5. If you delete row 4 the next auto increment will still be 5. If you backup/restore the table the auto increment will be reset to 4. The auto increment value in myisam is stored in the MYI file. Since this file isn’t backed up myisam restores the auto increment value from the highest existing value in the table. This value may or may not be the actual value of auto increment. As the manual says these commands should not be used. Instead use mysqlhotcopy.

Category: Geek, MySQL  |  2 Comments