PHP and MySQL
From ReduxWiki
What version of PHP do you run?
PHP 4.4.7 is run as an Apache module, while PHP 5.2.4 runs as a CGI.
- As of 01/15/2008 - PHP 5.2.0+ only will be run on all hosted/reseller (shared) servers within our Network.
Changing from PHP 4 to PHP 5
PHP 5 and the integrated Zend Engine 2 have greatly improved PHP's performance and capabilities, but great care has been taken to break as little existing code as possible. So migrating your code from PHP 4 to 5 should be very easy. Most existing PHP 4 code should be ready to run without changes, but you should still know about the few differences and take care to test your code before switching versions in production environments.
How can I debug my PHP Code?
The following How To Document has been found useful in regard to Debugging PHP Code.
Running PHP5 if PHP4 is default
IMPORTANT NOTE!
- As of 01/15/2008 - PHP 5.2.0+ only will be run on all hosted/reseller (shared) servers within our Network.
PHP4 and PHP5 currently run simultaneously on a handful of hosted/reseller servers within our shared environment.
In the event you have requested for PHP4 and PHP5 to be configured on a VPS or Dedicated Solution you may also refer to the related article on making use of PHP5.
How do I know which PHP modules are installed?
Using the following code within a file with a .php extension.
<? phpinfo(); ?>
- Be sure to give this file an inconspicuous name or delete it soon after using it, as hackers can use it to infiltrate your site.
Will you install specific PHP extensions for my needs?
Yes, so long as it is well documented at php.net, including associated functions provided by this extension.
What version of MySQL do you currently support?
Currently MySQL4, moving forward as of 01/15/2008 MySQL5.
What resource limits do you put in place on the MySQL services?
We limit each user to 25 simultaneous connections, if you exceed this limit you will begin to receive connection errors.
I am receiving "too many connection" errors with MySQL, how do I fix this?
The most common occurrence is that you have many sleeping MySQL queries with your application. If it gives you the option to disable, or limit persistent connections, this will help alleviate this problem in our shared environments.
How do you define a "slow query?"
This is defined by any query which takes over 10 seconds to complete. We understand that queries can exceed 10 seconds when server loads are high, so we take into account multiple server variables including system load and rows analyzed when parsing through slow query logs.
How do I backup my Databases?
This may merely be done by using the Backup function within cPanel located under Download a MySQL Database Backup.
I am getting an error: "Client cannot support authentication protocol"?
MySQL made a significant change to the password hashing algorithm from 4.0 to 4.1 and PHP 4.x has not caught up with an updated MySQL client library. Alterations to the servers have been made to limit the amount this error occurs, however, if you come across this please issue a support ticket and we will resolve it immediately.
I have a Large Database and Need to Restore it
The quickest way for those familiar with a linux command line is to use mysqldump to first dump the database (this will dump structure and data). Then when you wish to restore, use the mysql client, such as: mysql -uUser -p databasename < file.sql
Do you Support phpsuexec?
We do not, however we do use open_basedir protection on our PHP installation which protects you from other users reading the contents of your directories.
Alternative to Navicat
MySQL GUI Tools Bundle for 5.0 is available under the MySQL AB "dual licensing" model. Under this model, users may choose to use MySQL products under the free software/opensource GNU General Public License (commonly known as the "GPL") or under a commercial license.
Categories: Backup | PHP | MySQL | Databases | Network Redux Services | Website Management | POSIX
