MySQL tables can crash quite easily, especially when your server unexpectedly shuts down or crashed, or when you're forced to copy data around when it's still being accessed.
Luckily, there's a simple command to automatically check, repair and optimize all tables in all databases when you're running a MySQL server on Linux / Unix / BSD.
mysqlcheck -u root -p --auto-repair --check --optimize --all-databases
That's all there is to it!
General Information [ ^ ]
.htaccess Definition1 [ ^ ]
Apache server software provides distributed (i.e., directory-level) configuration via Hypertext Access files. These
htaccess files enable the localized fine-tuning of Apache’s universal system-configuration directives, which are defined in Apache’s main configuration file. The localized
htaccess directives must operate from within a file named
htaccess. The user must have appropriate file permissions to access and/or edit the
htaccess file. Further,
htaccess file permissions should never allow world write access — a secure permissions setting is “644”, which allows universal read access and user-only write access. Finally,
htaccess rules apply to the parent directory and all subdirectories. Thus to apply configuration rules to an entire website, place the
htaccess file in the root directory of the site.
Commenting .htaccess Code [ ^ ]
Comments are essential to maintaining control over any involved portion of code. Comments in
htaccess code are fashioned on a per-line basis, with each line of comments beginning with a pound sign
#. Thus, comments spanning multiple lines in the
htaccess file require multiple pound signs. Further, due to the extremely volatile nature of htaccess voodoo, it is wise to include only alphanumeric characters (and perhaps a few dashes and underscores) in any
Continue reading “.htaccess Guide” »