xianx

## backup
sudo rsync -vrazh --progress root@69.64.65.11:/backup/ /ebs/containers/percona-tdba-d/backup

## Basic MySQL Backup.md

      
        
          
            
              
              5 files
            
          
          
            
              
              1 fork
            
          
            
              
                
                0 comments
              
            
          
            
              
              0 stars
            
          
        
        
          
              
          
          
            
                xianx
                / Basic MySQL Backup.md
            
            
              Last active
              March 3, 2021 21:21
            
              
                MySQL Command
              
          
        
      
        
  
      
    ** Backup a single database with verbose output**
mysqldump -u USERNAME -pPASSWORD -v DATABASENAME >  DATABASENAME.sql

** Restore single database with verbose output**
mysql -u USERNAME -pPASSWORD -v DATABASENAME &lt; DATABASENAME.sql