Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2002
    Location
    Las Vegas
    Posts
    797

    mysql restore via ssh ?

    is there any how toos on this ? step by step

  2. #2
    Join Date
    Jan 2002
    Location
    Boston
    Posts
    5,010
    Create a new database
    Upload the .sql backup
    Go to the folder where you placed the .sql backup
    do mysql -u<username> -p newdatabasename < olddatabasebackup.sql

    It will prompt you for your password and hit enter and once back to the prompt if no errors are returned you are done.

  3. #3
    Join Date
    Jun 2004
    Location
    Boise, Idaho
    Posts
    42

  4. #4
    Please, read articles about master-slave mysql servers.
    It is the most correct way to backup databases.
    Credit card processing, online check/ACH and EuroDebit payment solutions for the Internet merchants
    www.psbill.com

Posting Permissions

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