cPanel KnowledgeBase and Troubleshooting, cPanel Server Fixes and Tutorials

We can use various methods to change database engine. In order to convert Database ENGINE from InnoDB to MyISAM use the following methods and shell scripts. First you should take all the databases backup. root@serv [~]#mysqldump DBname > DBBacupname.sql Method : 1 Once you secure the Database you may create a file called DBlist.txt and […]

You can use the following php script which is used to test mysql database connection on your cpanel server. <?php $link = mysql_connect(‘db_host’, ‘db_username’, ‘db_password’); if (!$link) { die(‘Could not connect the database: ‘ . mysql_error()); } echo ‘Database Connected successfully’; mysql_close($link); ?> db_host : Mostly used ‘localhost’ when you connect on the same server. […]