Results 1 to 6 of 6
  1. #1

    Restore DB from SSH?

    Hello, I uploaded a .gz file that contains an sql file and was curious to know how I can restore it into a database via SSH please. Thanks.

  2. #2
    Join Date
    Feb 2008
    Location
    Miami FL
    Posts
    375
    first, you need to un-archive the file
    #gunzip yourfilename.gz

    then you can restore this data with command:
    #mysql -uyourusername -pyourpassword databasename < youfilename.sql

    Done

  3. #3
    Thanks for the fast reply I will try that now.

  4. #4
    Join Date
    Nov 2002
    Location
    WebHostingTalk
    Posts
    8,878
    * Moved to Technical and Security Issues....

    Sirius
    I support the Human Rights Campaign!
    Moving to the Tampa, Florida area? Check out life in the suburbs in Trinity, Florida.

  5. #5
    Thanks a lot cheaptraffic it worked

  6. #6
    Join Date
    Feb 2008
    Location
    Miami FL
    Posts
    375
    you are welcome

Posting Permissions

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