1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

How to upload database to cpanel

Discussion in 'Site & Server Administration' started by mahi_mukka, Mar 27, 2009.

0
  1. #1
    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.
     
    mahi_mukka, Mar 27, 2009 IP
  2. ActiveFrost

    ActiveFrost Notable Member

    Messages:
    2,072
    Likes Received:
    63
    Best Answers:
    3
    Trophy Points:
    245
    #2
    What you mean by "uploading" database ? Anyway, SSH would the easiest way !
     
    ActiveFrost, Mar 27, 2009 IP
  3. mahi_mukka

    mahi_mukka Peon

    Messages:
    81
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Is there any way like browse and upload.. hw can i do from SSH
     
    mahi_mukka, Mar 27, 2009 IP
  4. ActiveFrost

    ActiveFrost Notable Member

    Messages:
    2,072
    Likes Received:
    63
    Best Answers:
    3
    Trophy Points:
    245
    #4
    Please answer to my question - what you mean by "uploading database" ?
    You want to upload .sql file to your FTP ?
     
    ActiveFrost, Mar 27, 2009 IP
  5. mahi_mukka

    mahi_mukka Peon

    Messages:
    81
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    yes, i would like to upload my .sql file
     
    mahi_mukka, Mar 27, 2009 IP
  6. ActiveFrost

    ActiveFrost Notable Member

    Messages:
    2,072
    Likes Received:
    63
    Best Answers:
    3
    Trophy Points:
    245
    #6
    You need to download FTP client ( SmartFTP or FileZilla ). Connect to your FTP server and upload whatever you want !
     
    ActiveFrost, Mar 27, 2009 IP
  7. xsimio

    xsimio Greenhorn

    Messages:
    52
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    18
    #7
    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.
     
    xsimio, Mar 30, 2009 IP
  8. MayurGondaliya

    MayurGondaliya Well-Known Member

    Messages:
    1,233
    Likes Received:
    38
    Best Answers:
    0
    Trophy Points:
    170
    #8
    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.
     
    MayurGondaliya, Mar 31, 2009 IP
  9. Mystique

    Mystique Well-Known Member

    Messages:
    2,579
    Likes Received:
    94
    Best Answers:
    2
    Trophy Points:
    195
    #9
    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/
     
    Mystique, Jun 21, 2015 IP
  10. HostPuma

    HostPuma Active Member

    Messages:
    42
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    60
    #10
    * 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.
     
    HostPuma, Jun 21, 2015 IP
  11. Deepak Mehla

    Deepak Mehla Greenhorn

    Messages:
    4
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    23
    #11
    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
     
    Deepak Mehla, Jun 28, 2015 IP
  12. Andy-Jones

    Andy-Jones Member

    Messages:
    134
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    28
    #12
    Not sure why you don't want to use phpmyadmin, it is the most easy way to import mysql database in cpanel.
     
    Andy-Jones, Jun 29, 2015 IP