Posts Tagged ‘mysql’

Importing Excel files into MySQL with PHP

If you have Excel files that need to be imported into MySQL, you can import them easily with PHP. First, you will need to download some prerequisites:
PHPExcelReader - http://sourceforge.net/projects/phpexcelreader/
Spreadsheet_Excel_Writer - http://pear.php.net/package/Spreadsheet_Excel_Writer
Once you’ve downloaded both items, upload them to your server. Your directory listing on your server should have two directories: Excel (from PHPExcelReader) [...]

MySQLTuner 0.9.9 is now available

MySQLTuner 0.9.9 is now available for download. There’s a new wiki for the script at wiki.mysqltuner.com. The new wiki contains links to downloads, changelogs, and other details.
If you want to know when the latest releases are available, there are multiple options:

Follow RackerHacker on Twitter
Sign up for the MySQLTuner mailing list
Use the –checkversion option [...]

MySQLTuner 0.9.8 is now available

MySQLTuner 0.9.8 is now available for download and it is full of new changes! So far, MySQLTuner has been downloaded almost 24,000 times. Thanks for making it so popular.
Easy download!
You can download it simply by running wget mysqltuner.pl. You will automatically be redirected to the script.
Access servers remotely
If you have multiple servers [...]

MySQLTuner is now a Fedora 9 package!

Thanks to some work started by Ville Skyttä, MySQLTuner is now included in Fedora 9 repositories:
# cat /etc/fedora-release
Fedora release 9 (Sulphur)
# yum info mysqltuner
Loaded plugins: fastestmirror, priorities, refresh-packagekit
Loading mirror speeds from cached hostfile
* updates: mirrors.usc.edu
* fedora: mirror.unl.edu
* livna: mirrors.tummy.com
Available Packages
Name : mysqltuner
Arch [...]

MySQL: ERROR 1040: Too many connections

If you run a fairly busy and/or badly configured MySQL server, you may receive something like this when attempting to connect:
# mysql
ERROR 1040: Too many connections
MySQL is telling you that it is handling the maximum connections that you have configured it to handle. By default, MySQL will handle 100 connections simultaneously. This is [...]