I use shared hosting. But when I click phpmyadmin on cpanel it seem error with message: Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly. this hosting is suck.. no response from admin. If I can't use phpmyadmin on cpanel is there anyway to use other scripts to manage, create, and import mysql database? Please your advice. Thanks.
My advice is to switch to hostmonster.com or bluehost.com are any other popular hosting company for small to mid-scale websites
Hay, there are several other database management tools available for free. Like SQLYog and MySQLFront and some of the best and recommended DB management tools. phpmyadmin is a web interface hence have some limitations, where as sqlyog and mysqlfront are the tools which you can easily install on your local machine and connect a remote database. You have to just provide your mysql database server IP address along with user and password to connect. It will directly connect your database remotely and you can perform any action with the database. The tools are very small in size and can be downloaded easily on internet. Hope this helps you. Let me know if you still have any queries or doubts to connect / access your mysql database Regards. R
Such errors shouldn't be due to web limitations, despite PHPmyadmin can have some problems exporting large databases. Here the problem seems to be something like a bad configuration of something. You should see the logs of the server but this is not the point of this discussion. You can use an external tool like Toad ( http://www.quest.com/toad-for-mysql/ ) to connect via IP to your shared hosting account. Toad ( or other tools like this ) will connect directly to the MySQL server bypassing any PHP misconfiguration. You probably need to set your own IP address ( your home/office IP address ) among those allowed to connect directly, this can be done from cPanel.