Hi I have a database driven application tested on my desktop. I would like to upload this data base to cpanel hosted web site.Instead of using php my admin ,is it possible to upload the database directly from my desktop.
Please answer to my question - what you mean by "uploading database" ? You want to upload .sql file to your FTP ?
You need to download FTP client ( SmartFTP or FileZilla ). Connect to your FTP server and upload whatever you want !
try to use navicat as a database client. with it U can transfer from one database to another, but at slow speed. also, U can export to sql and import to another database using mysql administrator client, at very high speed.
cpanel has phpmyadmin installed, you can backup/restore mysql database directly from there. Moreover, you can also use desktop applications such as mysql administrator or navicat to backuip/restore the databases.
If you want to upload your database via FTP, first download BigDump and upload it to your server along with your sql file. Further information on BigDump and how to set it up is here, http://www.ozerov.de/bigdump/
* Create a database from cPanel > MySQL Databases. * Goto cPanel > phpmyadmin > Choose the database you just created > click on "Import" and upload your database. If your database is bigger than 50MB, you can't use the method I mentioned, and you would need BigDump.
but bro phpmyadmin is the best way to import your database in cpanel. if you database file is leass than 50 mb just import it with phpmyadmin if you want i can do it for you without any fee. just to help
Not sure why you don't want to use phpmyadmin, it is the most easy way to import mysql database in cpanel.