Upload exisiting Mysql Databases

[Markwaugh]

Hi guys,

I have been testing mysql database apps on my home computer and would like to be able to upload to my website for testing purposes ...

1. how to confirm if PHP_ADODB is enabled on PHP server?

2. How can I best upload to server without having to recreate database using Mysql/PHPadmin features in CPanel?

3. Likewise, for future reference would I be able to run *.sql text files for above purpose? I know this is possible on home computer [Windows XP alas] by placing *.sql text file in mysql>bin folder and then running mysql> SOURCE 'filename' dos command ... do not know linux equivalent on remote server.

Any advice/help would be greatly appreciated.

cPanel.net Support Ticket Number:

 

[mickeymouse]

Dear Markwaugh,

1.As far as I know the only way is to go and directly see if it is installed in the server(if it is not visible through phpinfo() ).

2. You can take a sql dump and upload it to the server. Connect to the mysql server and use mysqlimport utility to create the database.

3. You can use mysqlimport for this purpose.For a better understanding please go through http://www.mysql.com/doc/en/mysqlimport.html

Regards,

cPanel.net Support Ticket Number: