Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    New to the CF scene
    Join Date
    Jun 2013
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How can I import a database using SSH command?

    I know, I can easily import/export my database using PHPMyAdmin menu in cPanel. But it allows to process only the databases that do not exceed 50Mb. My database is bigger, so I did some research and i find that i need to use SSH commands using tools like putty but I do not know how.
    Last edited by vinyl-junkie; 06-14-2013 at 05:07 AM. Reason: signatures only allowed through the control panel

  • #2
    Super Moderator
    Join Date
    May 2005
    Location
    Southern tip of Silicon Valley
    Posts
    2,877
    Thanks
    2
    Thanked 164 Times in 159 Posts

  • #3
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    26,720
    Thanks
    80
    Thanked 4,514 Times in 4,478 Posts
    Or just use the MySQL command line client.

    I have imported gigabytes using it.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • #4
    New to the CF scene
    Join Date
    Jun 2013
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanx :@FishMonger I am trying to download Mysql workbench for testing, @Old Pedant I don't know where I can find the tool "MySQL command line client"to use the command on my hosting "hostgator"

  • #5
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    26,720
    Thanks
    80
    Thanked 4,514 Times in 4,478 Posts
    Oh, sorry. Command line client only works if you have local access or remote desktop access to the machine. If you can't use command line (DOS window, or terminal window on Linux) you clearly can't use a command line client.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • #6
    Super Moderator
    Join Date
    May 2005
    Location
    Southern tip of Silicon Valley
    Posts
    2,877
    Thanks
    2
    Thanked 164 Times in 159 Posts
    You could install mysql on your local computer and that would give you access to the mysql cli tools. Assuming the mysql server on your host provider is reachable from your computer and not blocked by firewall rules.
    Last edited by FishMonger; 06-14-2013 at 08:52 PM.


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •