The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Upload exisiting Mysql Databases

Discussion in 'General Discussion' started by Markwaugh, Sep 23, 2003.

  1. Markwaugh

    Markwaugh Well-Known Member

    Joined:
    Aug 12, 2003
    Messages:
    151
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Sydney, Australia
    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:
     
  2. mickeymouse

    mickeymouse Well-Known Member

    Joined:
    Sep 16, 2003
    Messages:
    389
    Likes Received:
    0
    Trophy Points:
    16
    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:
     
Loading...

Share This Page