Project

General

Profile

« Previous | Next » 

Revision 8948

web/links/index.htm: updated to Firefox bookmarks. added Mac upgrade and recovery-related bookmarks.

View differences:

web/links/index.htm
23 23
    <DL><p>
24 24
        <DT><A HREF="https://pods.iplantcollaborative.org/wiki/display/iptol/BIEN+Database+3.0" ADD_DATE="1362528622" ICON_URI="https://pods.iplantcollaborative.org/wiki/s/2035/11/_/images/logo/confluence_16.png"><img width="16" height="16" src="https://pods.iplantcollaborative.org/wiki/s/2035/11/_/images/logo/confluence_16.png" style="margin-right: 0.5em;"/>Wiki</A>
25 25
        <DT><A HREF="http://vegpath.org/twiki/" ADD_DATE="1366412217" ICON_URI="http://vegpath.org/twiki/pub/Main/WebPreferences/favicon.ico"><img width="16" height="16" src="http://vegpath.org/twiki/pub/Main/WebPreferences/favicon.ico" style="margin-right: 0.5em;"/>TWiki</A>
26
        <DT><A HREF="http://twiki.org/cgi-bin/view/TWiki/TextFormattingRules" ADD_DATE="1366410442" ICON_URI="http://twiki.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://twiki.org/favicon.ico" style="margin-right: 0.5em;"/>syntax</A>
26
        <DT><A HREF="http://vegpath.org/twiki/do/view/TWiki/TextFormattingRules" ADD_DATE="1368120736" ICON_URI="http://vegpath.org/twiki/pub/TWiki/WebPreferences/favicon.ico"><img width="16" height="16" src="http://vegpath.org/twiki/pub/TWiki/WebPreferences/favicon.ico" style="margin-right: 0.5em;"/>syntax</A>
27 27
        <DT><A HREF="http://www.redmine.org/projects/redmine/wiki/RedmineTextFormatting" ADD_DATE="1318963452" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>syntax</A>
28 28
        <DT><A HREF="https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Database_development" ADD_DATE="1318376026" ICON_URI="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1347421715"><img width="16" height="16" src="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1347421715" style="margin-right: 0.5em;"/>Wiki</A>
29 29
        <DT><A HREF="https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/To_Do" ADD_DATE="1342214119" ICON_URI="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1347421715"><img width="16" height="16" src="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1347421715" style="margin-right: 0.5em;"/>To do</A>
......
201 201
<DD>page's description: The bash man page has long had the following bug listed: &quot;It&#39;s too big and too slow&quot; (at the very bottom of the man page). If you agree with that, then you probably won&#39;t want to read about the &quot;new&quot; associative arrays that were added in version 4.0 of bash.
202 202
                    <DT><A HREF="http://www.thegeekstuff.com/2010/05/tmout-exit-bash-shell-when-no-activity/" ADD_DATE="1367746583" ICON_URI="http://static.thegeekstuff.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://static.thegeekstuff.com/favicon.ico" style="margin-right: 0.5em;"/>TMOUT – Automatically Exit Unix Shell When there is No Activity</A>
203 203
<DD>page's description: Question: I would like to terminate my Unix command line shell, when I don&#39;t execute any command for N number of seconds. i.e How to automatically log out if
204
                    <DT><A HREF="http://www.gnu.org/software/bash/manual/bash.html#Aliases" ADD_DATE="1368084838" ICON_URI="http://www.gnu.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.gnu.org/favicon.ico" style="margin-right: 0.5em;"/>Bash Reference Manual &gt; Aliases</A>
205
<DD>page's description: Bash Reference Manual
206

  
207
&quot;Aliases are expanded when a command is read, not when it is executed&quot;
208

  
209
&quot;Aliases are expanded when a function definition is read, not when the function is executed, because a function definition is itself a compound command&quot;
210
note that if statements are also &quot;compound commands&quot;, which have aliases expanded when their definition is read (i.e. at the beginning of the if statement, for the entire if statement), not when they are executed, and any aliases for function names in them need to be unaliased *before* the if statement containing the function definition. this is necessary even if the if statement is *not* executed, because the expansion of such aliases will cause syntax errors in the parsing of the if statement itself.
211

  
212
&quot;If the last character of the alias value is a space or tab character, then the next command word following the alias is also checked for alias expansion.&quot;
204 213
                </DL><p>
205 214
                <DT><a name="gnome-keyring" href="#gnome-keyring"><H3 ADD_DATE="1349231436">gnome-keyring</H3></a>
206 215
                <DL><p>
......
260 269
            </DL><p>
261 270
            <DT><a name="Mac" href="#Mac"><H3 ADD_DATE="1361008732">Mac</H3></a>
262 271
            <DL><p>
272
                <DT><a name="10.8 Mountain Lion" href="#10.8 Mountain Lion"><H3 ADD_DATE="1368126870">10.8 Mountain Lion</H3></a>
273
                <DL><p>
274
                    <DT><A HREF="https://discussions.apple.com/docs/DOC-3761" ADD_DATE="1368126846" ICON_URI="https://ssl.apple.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://ssl.apple.com/favicon.ico" style="margin-right: 0.5em;"/>Mountain Lion 10.8 Updating requirements: Apple Support Communities</A>
275
<DD>&quot;the installer takes 3 minutes before rebooting itself, and 33 minutes after rebooting to complete the installation on an iMac 11,2&quot;
276
                    <DT><A HREF="http://lifehacker.com/5928763/should-i-upgrade-to-mountain-lion" ADD_DATE="1368132025" ICON_URI="http://lifehacker.com/assets/images/logos/favicons/lifehacker.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://lifehacker.com/assets/images/logos/favicons/lifehacker.ico" style="margin-right: 0.5em;"/>Should I Upgrade to Mountain Lion?</A>
277
<DD>page's description: Dear Lifehacker,
278
Mountain Lion is out, and I&#39;m seeing it has some pretty cool new features! Should I upgrade?
279
                    <DT><A HREF="http://www.apple.com/osx/whats-new/features.html" ADD_DATE="1368132184" ICON_URI="http://www.apple.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.apple.com/favicon.ico" style="margin-right: 0.5em;"/>Apple - OS X Mountain Lion - See everything the new OS X can do.</A>
280
<DD>page's description: Play iOS gamers in Game Center. Share right from your apps. Send iMessages. And more. Over 200 more features, in fact. All part of OS X Mountain Lion.
281
                </DL><p>
263 282
                <DT><a name="MacFusion" href="#MacFusion"><H3 ADD_DATE="1367739060">MacFusion</H3></a>
264 283
                <DL><p>
265 284
                    <DT><A HREF="http://code.google.com/p/macfuse/wiki/OPTIONS" ADD_DATE="1367738659" ICON_URI="http://www.gstatic.com/codesite/ph/images/phosting.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.gstatic.com/codesite/ph/images/phosting.ico" style="margin-right: 0.5em;"/>OPTIONS - macfuse - Commonly useful mount-time options available in MacFUSE - The Easiest and Fastest Way to Create File Systems for Mac OS X - Google Project Hosting</A>
......
268 287
                    <DT><A HREF="http://code.google.com/p/macfusion/issues/detail?id=257" ADD_DATE="1367739032" ICON_URI="http://www.gstatic.com/codesite/ph/images/phosting.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.gstatic.com/codesite/ph/images/phosting.ico" style="margin-right: 0.5em;"/>Issue 257 - macfusion - SSHFS | Finder | copy | Administrator password requested | fails | Finder Error code -43 - General GUI for Fuse Filesystems to be used with MacFUSE - Google Project Hosting</A>
269 288
<DD>&quot;-o defer_permissions&quot;
270 289
                </DL><p>
290
                <DT><a name="recovery partition" href="#recovery partition"><H3 ADD_DATE="1368131131">recovery partition</H3></a>
291
                <DL><p>
292
                    <DT><A HREF="http://apple.stackexchange.com/questions/19145/how-can-i-create-or-recreate-a-lion-recovery-partition" ADD_DATE="1368131142" ICON_URI="http://cdn.sstatic.net/apple/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/apple/img/favicon.ico" style="margin-right: 0.5em;"/>How can I create or recreate a Lion recovery partition? - Ask Different</A>
293
                    <DT><A HREF="http://support.apple.com/kb/DL1464" ADD_DATE="1368131153" ICON_URI="http://support.apple.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://support.apple.com/favicon.ico" style="margin-right: 0.5em;"/>Lion Recovery Update v1.0</A>
294
                </DL><p>
271 295
                <DT><a name="sleep" href="#sleep"><H3 ADD_DATE="1366920274">sleep</H3></a>
272 296
                <DL><p>
273 297
                    <DT><a name="wake for network access" href="#wake for network access"><H3 ADD_DATE="1366920286">wake for network access</H3></a>
......
284 308
                    <DT><A HREF="http://www.tuaw.com/2011/08/22/why-hibernate-or-safe-sleep-mode-is-no-longer-necessary-in-os/" ADD_DATE="1366917543" ICON_URI="http://www.blogsmithmedia.com/www.tuaw.com/media/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.blogsmithmedia.com/www.tuaw.com/media/favicon.ico" style="margin-right: 0.5em;"/>Why hibernate or &#39;safe sleep&#39; mode is no longer necessary in OS X Lion (Updated) | TUAW - The Unofficial Apple Weblog</A>
285 309
<DD>page's description: Update: Several commenters expressed concern that disabling safe sleep could expose you to the possibility of drive corruption if you lose power or
286 310
                </DL><p>
311
                <DT><a name="Time Machine" href="#Time Machine"><H3 ADD_DATE="1368130723">Time Machine</H3></a>
312
                <DL><p>
313
                    <DT><A HREF="https://discussions.apple.com/thread/3824441?start=0&tstart=0" ADD_DATE="1368130607" ICON_URI="https://ssl.apple.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://ssl.apple.com/favicon.ico" style="margin-right: 0.5em;"/>Can I boot from an time machine backup...: Apple Support Communities</A>
314
                    <DT><A HREF="http://www.macworld.com/article/1165784/how_to_restore_data_from_time_machine.html" ADD_DATE="1368130704" ICON_URI="http://www.macworld.com/www.mw/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.macworld.com/www.mw/favicon.ico" style="margin-right: 0.5em;"/>How to restore data from Time Machine in Mountain Lion | Macworld</A>
315
<DD>page's description: If you use Time Machine regularly, you&#39;re ready for whatever technological mishaps life throws at you. Restoring data from Time Machine is just as easy as backing things up in the first place.
316

  
317
&quot;start up your Mac from the Mountain Lion recovery partition by pressing (and holding down) Command-R at startup. This launches Recovery Mode, a portion of your drive that Mountain Lion treats as a separate volume&quot;
318
                    <DT><A HREF="http://support.apple.com/kb/HT5096" ADD_DATE="1347325122" ICON_URI="http://support.apple.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://support.apple.com/favicon.ico" style="margin-right: 0.5em;"/>Time Machine: How to transfer backups from the current backup drive to a new backup drive</A>
319
<DD>page's description: &lt;p&gt;If you want to switch to a different TIme Machine backup drive, use this article to learn how to transfer your existing Time Machine backups to the new backup drive, and then use it for regular Time Machine backups.&lt;/p&gt;
320
                </DL><p>
287 321
                <DT><A HREF="http://www.danbishop.org/2011/09/10/how-to-mount-sftp-ssh-shares-in-os-x-lion/" ADD_DATE="1363045253" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Dan Bishop » How to mount SFTP/SSH shares in OS X NOW UPDATED to include OS X 10.8</A>
322
                <DT><A HREF="http://www.macworld.com/article/1138403/dockbounce.html" ADD_DATE="1367786323" ICON_URI="http://www.macworld.com/www.mw/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.macworld.com/www.mw/favicon.ico" style="margin-right: 0.5em;"/>Disable the Dock’s ‘bounce to alert’ behavior | Macworld</A>
323
<DD>page's description: Learn how to prevent icons from bouncing in the Dock to get your attention
288 324
                <DT><A HREF="https://discussions.apple.com/thread/3324489?start=0&tstart=0" ADD_DATE="1363328233" ICON_URI="https://ssl.apple.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://ssl.apple.com/favicon.ico" style="margin-right: 0.5em;"/>firewall blocks ssh since Sept 12 update: Apple Support Communities</A>
289 325
                <DT><A HREF="http://forums.macrumors.com/showthread.php?t=1281546" ADD_DATE="1367490962" ICON_URI="http://forums.macrumors.com/favicon.ico" LAST_CHARSET="windows-1252"><img width="16" height="16" src="http://forums.macrumors.com/favicon.ico" style="margin-right: 0.5em;"/>Force every folder to be arranged by kind and sorted by name? - MacRumors Forums</A>
290 326
<DD>page's description:  Force every folder to be arranged by kind and sorted by name? Mac OS X 10.7 Lion
327
                <DT><A HREF="http://www.ehow.com/how_8529147_stop-icons-bouncing.html" ADD_DATE="1367786460" ICON_URI="http://test7-v5-static.ehowcdn.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://test7-v5-static.ehowcdn.com/favicon.ico" style="margin-right: 0.5em;"/>How to Stop Icons From Bouncing | eHow.com</A>
328
<DD>page's description: How to Stop Icons From Bouncing. The dock is a distinctive feature of the Mac operating system. It keeps icons of commonly used and currently open programs visible at the bottom of your screen for quick access. When programs first open, or need to alert the user of some new update, the icons in the dock bounce. Many people find this helpful when...
291 329
                <DT><A HREF="http://inner.geek.nz/archives/2011/08/10/howto-fix-file-sorting-in-finders-column-view-on-mac-os-x-lion/" ADD_DATE="1367490710" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>HOWTO: Fix file sorting in Finder’s column view on Mac OS X Lion « inner.geek</A>
292 330
                <DT><A HREF="http://hints.macworld.com/article.php?story=20040203002020660" ADD_DATE="1367385714" ICON_URI="http://hints.macworld.com/favicon.ico" LAST_CHARSET="windows-1252"><img width="16" height="16" src="http://hints.macworld.com/favicon.ico" style="margin-right: 0.5em;"/>Lock the keychain when the screensaver activates - Mac OS X Hints</A>
293 331
                <DT><A HREF="http://support.apple.com/kb/HT5343" ADD_DATE="1363155945" ICON_URI="http://support.apple.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://support.apple.com/favicon.ico" style="margin-right: 0.5em;"/>OS X: How to reset the DNS cache</A>
294 332
<DD>page's description: &lt;p&gt;Learn how to reset (flush) the DNS cache. &lt;/p&gt;
295 333
                <DT><A HREF="http://superuser.com/questions/279891/list-all-members-of-a-group-mac-os-x" ADD_DATE="1361008714" ICON_URI="http://cdn.sstatic.net/superuser/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/superuser/img/favicon.ico" style="margin-right: 0.5em;"/>osx - List all members of a group (Mac OS X) - Super User</A>
296 334
                <DT><A HREF="http://hints.macworld.com/article.php?story=2005070300463515" ADD_DATE="1362840189" ICON_URI="http://hints.macworld.com/favicon.ico" LAST_CHARSET="windows-1252"><img width="16" height="16" src="http://hints.macworld.com/favicon.ico" style="margin-right: 0.5em;"/>Prevent .DS_Store file creation on network volumes - Mac OS X Hints</A>
297
                <DT><A HREF="http://support.apple.com/kb/HT5096" ADD_DATE="1347325122" ICON_URI="http://support.apple.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://support.apple.com/favicon.ico" style="margin-right: 0.5em;"/>Time Machine: How to transfer backups from the current backup drive to a new backup drive</A>
298
<DD>page's description: &lt;p&gt;If you want to switch to a different TIme Machine backup drive, use this article to learn how to transfer your existing Time Machine backups to the new backup drive, and then use it for regular Time Machine backups.&lt;/p&gt;
299
                <DT><A HREF="http://www.macworld.com/article/1138403/dockbounce.html" ADD_DATE="1367786323" ICON_URI="http://www.macworld.com/www.mw/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.macworld.com/www.mw/favicon.ico" style="margin-right: 0.5em;"/>Disable the Dock’s ‘bounce to alert’ behavior | Macworld</A>
300
<DD>page's description: Learn how to prevent icons from bouncing in the Dock to get your attention
301
                <DT><A HREF="http://www.ehow.com/how_8529147_stop-icons-bouncing.html" ADD_DATE="1367786460" ICON_URI="http://test7-v5-static.ehowcdn.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://test7-v5-static.ehowcdn.com/favicon.ico" style="margin-right: 0.5em;"/>How to Stop Icons From Bouncing | eHow.com</A>
302
<DD>page's description: How to Stop Icons From Bouncing. The dock is a distinctive feature of the Mac operating system. It keeps icons of commonly used and currently open programs visible at the bottom of your screen for quick access. When programs first open, or need to alert the user of some new update, the icons in the dock bounce. Many people find this helpful when...
303 335
            </DL><p>
304 336
            <DT><a name="svn" href="#svn"><H3 ADD_DATE="1367370827">svn</H3></a>
305 337
            <DL><p>
......
552 584
                            <DT><A HREF="http://forums.mysql.com/read.php?125,127701,127719#msg-127719" ADD_DATE="1366898787" ICON_URI="http://forums.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://forums.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: Re: Dynamic SQl in Triggers/Procdures</A>
553 585
<DD>&quot;Stored procedures called from triggers operate under the same restrictions as triggers, i.e., no dynamic SQL is allowed.&quot;
554 586
                        </DL><p>
587
                        <DT><a name="enum" href="#enum"><H3 ADD_DATE="1367823275">enum</H3></a>
588
                        <DL><p>
589
                            <DT><A HREF="http://komlenic.com/244/8-reasons-why-mysqls-enum-data-type-is-evil/" ADD_DATE="1367823304" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>8 Reasons Why MySQL&#39;s ENUM Data Type Is Evil - Chris Komlenic</A>
590
<DD>page's description: The pros and (mostly) cons of MySQL&#39;s ENUM data-type (as compared to reference tables), as well as when it is okay to use and how to use it if you must.
591

  
592
&quot;With an ENUM we&#39;re actually storing pieces of data in a place that was only intended to hold crucial information about the model&quot;
593

  
594
&quot;in large systems the effect of normalization can already tax the limits of human comprehension and complicate queries&quot;
595

  
596
&quot;Programmers waste enormous amounts of time thinking about, or worrying about, the speed of noncritical parts of their programs, and these attempts at efficiency actually have a strong negative impact when debugging and maintenance are considered.&quot; [Donald Knuth]
597
                            <DT><A HREF="http://www.kawoolutions.com/SQL_Database_Design/8._User-Defined_Types/8.3_Enumerated_Types" ADD_DATE="1367824491" ICON_URI="http://www.kawoolutions.com/images/favicon.gif" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.kawoolutions.com/images/favicon.gif" style="margin-right: 0.5em;"/>Kawoolutions - SQL Database Design - 8. User-Defined Types - 8.3 Enumerated Types</A>
598
<DD>page's description: Kawoolutions,,SQL Database Design,8. User-Defined Types,8.3 Enumerated Types
599

  
600
&quot;some people claim, that MySQL ENUMs are much faster than separate tables, especially on large databases. Furthermore, enums can give you some savings in database size, depending on the implementation. For example, a MySQL ENUM occupies only one byte for up to 255 values and two bytes for up to 65535 values.&quot;
601
                        </DL><p>
555 602
                        <DT><a name="MySQL Workbench" href="#MySQL Workbench"><H3 ADD_DATE="1366740023">MySQL Workbench</H3></a>
556 603
                        <DL><p>
557 604
                            <DT><a name="exporting indexes separately" href="#exporting indexes separately"><H3 ADD_DATE="1367759236">exporting indexes separately</H3></a>
......
586 633
                        <DT><A HREF="http://stackoverflow.com/questions/989643/how-to-use-the-cast-function-correctly-in-a-mysql-select-statement" ADD_DATE="1366752124" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>casting - How to use the CAST function correctly in a MySql SELECT statement? - Stack Overflow</A>
587 634
<DD>&quot;VARCHAR isn&#39;t a valid type for the CAST function, but CHAR is.&quot;
588 635
                        <DT><A HREF="http://skyontech.com/blog/create-MySQL-view-in-phpMyAdmin" ADD_DATE="1364874584" ICON_URI="http://skyontech.com/blog/misc/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://skyontech.com/blog/misc/favicon.ico" style="margin-right: 0.5em;"/>Creating a MySQL View directly in phpMyAdmin | Sky on Tech</A>
636
                        <DT><A HREF="http://www.devcha.com/2008/01/extend-phpmyadmin-session-timeout-value.html" ADD_DATE="1331080013" ICON_URI="http://www.devcha.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.devcha.com/favicon.ico" style="margin-right: 0.5em;"/>Extend phpMyAdmin Session Timeout Value (Expired Session)</A>
589 637
                        <DT><A HREF="http://www.bluebox.net/about/blog/2009/07/mysql_encoding/" ADD_DATE="1366749540" ICON_URI="http://www.bluebox.net/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.bluebox.net/favicon.ico" style="margin-right: 0.5em;"/>Getting out of MySQL Character Set Hell &lt; Blue Box Blog</A>
590 638
                        <DT><A HREF="http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html" ADD_DATE="1366764865" ICON_URI="http://s0.cyberciti.org/static/legacy/i/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://s0.cyberciti.org/static/legacy/i/favicon.ico" style="margin-right: 0.5em;"/>How Do I Enable Remote Access To MySQL Database Server?</A>
591 639
<DD>page's description: MySQL Remote Access - A step-by-step guide to enable remote access to a MySQL database server under Linux, UNIX and BSD operating systems. 
......
609 657
                        <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/innodb-create-index-overview.html" ADD_DATE="1366895888" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 14.4.2.1 Overview of Fast Index Creation</A>
610 658
                        <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/mysql-command-options.html" ADD_DATE="1366893751" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 4.5.1.1 mysql Options</A>
611 659
                        <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/mysql-commands.html" ADD_DATE="1364873441" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 4.5.1.2 mysql Commands</A>
660
                        <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/server-sql-mode.html#sqlmode_postgresql" ADD_DATE="1368048993" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 5.1.7 Server SQL Modes &gt; POSTGRESQL</A>
661
<DD>&quot;Equivalent to PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, NO_KEY_OPTIONS, NO_TABLE_OPTIONS, NO_FIELD_OPTIONS.&quot;
612 662
                        <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/index-btree-hash.html" ADD_DATE="1366865295" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 8.3.8 Comparison of B-Tree and Hash Indexes</A>
613 663
                        <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/identifiers.html" ADD_DATE="1366748434" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 9.2 Schema Object Names</A>
614 664
                        <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_clustered_index" ADD_DATE="1366896044" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: MySQL Glossary :: clustered index</A>
......
625 675
                        <DT><A HREF="http://mysql-python.sourceforge.net/MySQLdb.html" ADD_DATE="1323978074" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>MySQLdb</A>
626 676
                        <DT><A HREF="http://stackoverflow.com/questions/553369/need-mysql-4-to-ignore-alter-table-errors" ADD_DATE="1366897937" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>Need MySQL 4 to ignore ALTER TABLE errors - Stack Overflow</A>
627 677
                        <DT><A HREF="http://drupal.org/node/306156" ADD_DATE="1364875790" ICON_URI="http://drupal.org/misc/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://drupal.org/misc/favicon.ico" style="margin-right: 0.5em;"/>What&#39;s the opposite of mysqldump to load data back into a database? | drupal.org</A>
628
                        <DT><A HREF="http://www.devcha.com/2008/01/extend-phpmyadmin-session-timeout-value.html" ADD_DATE="1331080013" ICON_URI="http://www.devcha.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.devcha.com/favicon.ico" style="margin-right: 0.5em;"/>Extend phpMyAdmin Session Timeout Value (Expired Session)</A>
629
                        <DT><a name="enum" href="#enum"><H3 ADD_DATE="1367823275">enum</H3></a>
630
                        <DL><p>
631
                            <DT><A HREF="http://komlenic.com/244/8-reasons-why-mysqls-enum-data-type-is-evil/" ADD_DATE="1367823304" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>8 Reasons Why MySQL&#39;s ENUM Data Type Is Evil - Chris Komlenic</A>
632
<DD>page's description: The pros and (mostly) cons of MySQL&#39;s ENUM data-type (as compared to reference tables), as well as when it is okay to use and how to use it if you must.
633

  
634
&quot;With an ENUM we&#39;re actually storing pieces of data in a place that was only intended to hold crucial information about the model&quot;
635

  
636
&quot;in large systems the effect of normalization can already tax the limits of human comprehension and complicate queries&quot;
637

  
638
&quot;Programmers waste enormous amounts of time thinking about, or worrying about, the speed of noncritical parts of their programs, and these attempts at efficiency actually have a strong negative impact when debugging and maintenance are considered.&quot; [Donald Knuth]
639
                            <DT><A HREF="http://www.kawoolutions.com/SQL_Database_Design/8._User-Defined_Types/8.3_Enumerated_Types" ADD_DATE="1367824491" ICON_URI="http://www.kawoolutions.com/images/favicon.gif" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.kawoolutions.com/images/favicon.gif" style="margin-right: 0.5em;"/>Kawoolutions - SQL Database Design - 8. User-Defined Types - 8.3 Enumerated Types</A>
640
<DD>page's description: Kawoolutions,,SQL Database Design,8. User-Defined Types,8.3 Enumerated Types
641

  
642
&quot;some people claim, that MySQL ENUMs are much faster than separate tables, especially on large databases. Furthermore, enums can give you some savings in database size, depending on the implementation. For example, a MySQL ENUM occupies only one byte for up to 255 values and two bytes for up to 65535 values.&quot;
643
                        </DL><p>
644 678
                    </DL><p>
645 679
                    <DT><a name="PostgreSQL" href="#PostgreSQL"><H3 ADD_DATE="1333386475">PostgreSQL</H3></a>
646 680
                    <DL><p>

Also available in: Unified diff