MySQL - MyLiteratureTechLife.COM

Easy way to optimize apache,php & MySQL

February 2nd, 2010 shk 0 Comments

There are 2 important scripts to optimize apache,php and mysql very easily. They are MySQLTuner (Perl) and MySQL Performance Tuning Primer (shell) They can help diagnose MySQL database performance issues, and provide recommendations on how to solve them. # Download MySQLTuner and MySQL...

cpanel, MySQL, PHP, System Administration, Web hosting [ Read More ]

How to move MySQL to second drive

January 6th, 2010 shk 0 Comments

If you ran out of space in your primary drive and wish to move MySQL to another drive then here is a simple procedure. Moving MySQL to another drive is very easy then it look. 1) Find out mount point of secondary drive. If drive is not mounted yet then you can get help from article "How to...

MySQL, Web hosting [ Read More ]

PHP script to test MySQL database Connection

January 1st, 2010 shk 0 Comments

Here is php script to test database Connection, it will need little edition as per your database name and password Here you go Just copy and paste below code :- < ?php ###################################### C O P Y R I G H T S ############################################ # THIS SIMPLE...

PHP [ Read More ]