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. luigidelgado

    After installing FCGI, unable to upload files with owner:owner and 777

    luigidelgado, May 5, 2017, in forum: EasyApache
    Replies:
    5
    Views:
    183
    cPanelMichael
    May 8, 2017
  2. Jafar Muhammed

    SOLVED Does cPanel save failed uploads?

    Jafar Muhammed, May 4, 2017, in forum: Data Protection
    Replies:
    2
    Views:
    120
    Jafar Muhammed
    May 5, 2017
  3. maestroc

    SOLVED php max upload size settings not being followed

    maestroc, May 2, 2017, in forum: EasyApache
    Replies:
    5
    Views:
    265
    cPanelMichael
    May 3, 2017
  4. WorkinOnIt

    Incorrect upload File permissions 664

    WorkinOnIt, May 1, 2017, in forum: General Discussion
    Replies:
    16
    Views:
    330
    WorkinOnIt
    May 12, 2017
  5. Luana Premoli

    [Upload limit] Restore a Full Backup/cpmove File

    Luana Premoli, Apr 5, 2017, in forum: General Discussion
    Replies:
    1
    Views:
    238
    cPanelMichael
    Apr 5, 2017

Share This Page