PHP / MySQL
RESOLVED: mysqld won't start
Posted Sun, 06/21/2009 - 7:24pm
In case your mysqld won't work with
# service mysqld restart
or
# service mysqld start
or
# service mysqld stopdo this:
# killall mysqldfollowed by:
HOW-TO: Install Eaccelerator (Turck MMCache replacement)
Posted Mon, 05/14/2007 - 8:09pm
Install/Update eaccelerator:
cd /ea
rm -rf ./eaccelerator*
rm -rf /usr/local/lib/php/extensions/no-debug-non-zts-*
MySQL Cheat Sheet
Posted Thu, 05/18/2006 - 9:00pm
SSH repair and optimize all MySQL databases:
# /usr/bin/mysqlcheck --repair --all-databases --password=xxxxxx
# /usr/bin/mysqlcheck --optimize --all-databases --password=xxxxxx
HOW TO INSTALL/UPGRADE MySQL
Posted Sun, 05/08/2005 - 8:27pm
rm /var/cpanel/mysqlup
That will stop upcp from touching MySQL.
To upgrade manually
If you upgrade manually you need to remember to create the file:
#touch /etc/mysqlupdisable
(Otherwise upcp will simply downgrade it again.)
PHP OOP tips
Posted Mon, 06/28/2004 - 6:24pm
SitePoint
MysqlConnectClass (good explanation of thinking the OOP way):
http://www.sitepoint.com/forums/showpost.php?p=683454&postcount=4
Advanced PHP Resources:
http://www.sitepoint.com/forums/showthread.php?t=78687
A HOWTO on Optimizing PHP
Posted Wed, 02/25/2004 - 9:05pm
| source: phplense.com Last revised 4 Jan 2004. PHP is a very fast programming language, but there is more to optimizing PHP than just speed of code execution. |
Common MySQL queries...
Posted Mon, 02/02/2004 - 9:42am
Connect# mysql -hdb3.pair.com -uusername -pXXXXXXXX username_dbname
Database Backup# mysqldump -hdb3.pair.com -uusername -pXXXXXXXX username_dbname > file.txt
