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.

Hosting Problem

Discussion in 'Web Hosting' started by wptheme, Mar 20, 2009.

  1. #1
    Hi, I just bought a site and a database for a site of mine. I have a reseller and just created a cpanel account. Added my domain to the cpanel.
    Now the proble is that the database is to big and the seller asked me to ask my host to enable SSH. What is SSH and why cant I just install using cpanel? The database size is 1GB.
    Need help to solve this problem asap. Thanks
    SEMrush
     
    wptheme, Mar 20, 2009 IP
    SEMrush
  2. n00bmaster

    n00bmaster Peon

    Messages:
    371
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    Can install it for you without SSH as well. PMing you details.
     
    n00bmaster, Mar 20, 2009 IP
    wptheme likes this.
  3. wptheme

    wptheme Well-Known Member

    Messages:
    4,052
    Likes Received:
    346
    Best Answers:
    0
    Trophy Points:
    180
    As Seller:
    100% - 0
    As Buyer:
    100% - 2
    #3
    Thanks for the superb response via PM. Will keep this in mind. Still waiting of other alternative first though. Rep+
    If there are anyone else who can install the database without using SSH PM me your rates too and your payment option. I accept PP and MB but prefer MB more. Let me know
     
    wptheme, Mar 20, 2009 IP
  4. ishan

    ishan Prominent Member

    Messages:
    2,215
    Likes Received:
    88
    Best Answers:
    0
    Trophy Points:
    325
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #4
    Here is my advice for free :)

    phpMyAdmin allows uploads upto 51200 KB via the browser. So, make parts of your 1 GB database dump, which are smaller than or equal to the above size. Then import them in the correct order.

    Try it & let me know how it goes.

    Ishan
     
    ishan, Mar 21, 2009 IP
    wptheme likes this.
  5. adviceforall

    adviceforall Banned

    Messages:
    1,608
    Likes Received:
    24
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #5
    I suggest you use

    Remote Sql As you can import any DB Size
     
    adviceforall, Mar 21, 2009 IP
    wptheme likes this.
  6. newgenservices

    newgenservices Well-Known Member

    Messages:
    862
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    105
    Digital Goods:
    1
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #6
    I would say better upload the 1 GB file in a .sql format to your /home/<user>/

    where <user> is your account (from your ftp this is the root when you login using cPanel username and password)

    Then contact your host asking them to restore the database for you or ask them to provide you SSH access.

    The SSH command would be

    mysql -u db_username -p db_name < /home/<user>/backupname.sql
    Code (markup):
    This is the safest method if you (your host) can do it this way.
     
    newgenservices, Mar 21, 2009 IP
    wptheme likes this.
  7. iDesigni

    iDesigni Banned

    Messages:
    62
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #7
    hi
    i dont think with normal hosting you be able to do SSH
    you need vps/dedicate server to use ssh,
    why not telling him use a back up option and then use ftp ur self?
     
    iDesigni, Mar 21, 2009 IP
    wptheme likes this.
  8. svrhost

    svrhost Peon

    Messages:
    127
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #8
    I can help out in this without using any SSH..:) Let me know if youve not done it yet.
     
    svrhost, Mar 21, 2009 IP
    wptheme likes this.
  9. wptheme

    wptheme Well-Known Member

    Messages:
    4,052
    Likes Received:
    346
    Best Answers:
    0
    Trophy Points:
    180
    As Seller:
    100% - 0
    As Buyer:
    100% - 2
    #9
    Thanks everyone. Really appreciate all of your opinions. Rep+
     
    wptheme, Mar 21, 2009 IP
  10. wptheme

    wptheme Well-Known Member

    Messages:
    4,052
    Likes Received:
    346
    Best Answers:
    0
    Trophy Points:
    180
    As Seller:
    100% - 0
    As Buyer:
    100% - 2
    #10
    Emm.. how can we split it?
     
    wptheme, Mar 21, 2009 IP
  11. samcroft11

    samcroft11 Peon

    Messages:
    446
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #11
    samcroft11, Mar 21, 2009 IP
  12. ishan

    ishan Prominent Member

    Messages:
    2,215
    Likes Received:
    88
    Best Answers:
    0
    Trophy Points:
    325
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #12
    You can open it in a text editor & make parts.

    You could think of it as making a new file for each paragraph in some text file.


    Or you could try the attached script. It comes with instructions on how to use it to upload large dumps.


    Or this - http://www.rusiczki.net/blog/blogstuff/SQLDumpSplitter.zip

    Let me know if you need any further help.

    Ishan
     

    Attached Files:

    ishan, Mar 21, 2009 IP
  13. n00bmaster

    n00bmaster Peon

    Messages:
    371
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #13
    Did you manage to get this done yet ?
     
    n00bmaster, Mar 22, 2009 IP
  14. hostlonestar

    hostlonestar Peon

    Messages:
    1,514
    Likes Received:
    50
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #14
    SSH is a command line interface for Linux that allows you to do things directly on the server. You can monitor all the running programs, really, anything you need. Most hosts will nto allow you SSH access on a shared environment (reseller is a shared env.). This is due to security risks. You MAY be able to get jailed SSH, which, essentially, limits you to certain things.

    And it would not be a good thing for you to mess with if you don't have any knowledge of it. You can really muck up a server if you do something wrong.
     
    hostlonestar, Mar 22, 2009 IP