Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

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:
    166
    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:
     
    #1 Markwaugh, Sep 23, 2003
  2. mickeymouse

    mickeymouse Well-Known Member

    Joined:
    Sep 16, 2003
    Messages:
    389
    Likes Received:
    0
    Trophy Points:
    166
    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:
     
    #2 mickeymouse, Oct 14, 2003
(You must log in or sign up to post here.)
Loading...
Similar Threads - Upload exisiting Mysql
  1. alexis75

    FTP upload problem

    alexis75, Sep 18, 2017 at 2:59 PM, in forum: General Discussion
    Replies:
    7
    Views:
    92
    alexis75
    Sep 20, 2017 at 9:35 AM
  2. rhe6a

    Upload always stuck on 99%

    rhe6a, Sep 13, 2017, in forum: General Discussion
    Replies:
    4
    Views:
    101
    cPanelMichael
    Sep 18, 2017 at 11:10 AM
  3. kiti

    upload files limits issue & php.ini values

    kiti, Sep 12, 2017, in forum: General Discussion
    Replies:
    1
    Views:
    52
    cPanelMichael
    Sep 12, 2017
  4. linux4me2

    Files and Folders Uploaded By sFTP Have Incorrect Permissions

    linux4me2, Sep 8, 2017, in forum: EasyApache
    Replies:
    9
    Views:
    121
    linux4me2
    Sep 12, 2017
  5. Wade John Beckett

    Missing emails after mail folder upload

    Wade John Beckett, Aug 23, 2017, in forum: E-mail Discussions
    Replies:
    3
    Views:
    97
    cPanelMichael
    Aug 25, 2017

Share This Page