Results 1 to 3 of 3
  1. #1

    server to server db backup

    how would you do a mysql backup to another server over ssh?

    This is what I tried and I lost the mysql connection:
    mysqldump -A -h11.111.111.111 -P22 -uroot -p > testingadump.sql;
    It did not work.

    Any clues?


  2. #2
    Join Date
    Nov 2001
    Ann Arbor, MI
    Is that supposed to work?

    I would do it this way:

    mysqldump -uroot -ppassword database | ssh [email protected] 'cat > testingdump.sql'
    -Mark Adams - Secure Michigan web hosting for your business.
    Only host still offering a full money back uptime guarantee and prorated refunds.
    Offering advanced server management and security incident response!

  3. #3
    I dunno if it's supposed to work or not. I was just trying to logically figure it out. Yours 'appears' to be working <crossing fingers>



Posting Permissions

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