Luca Longo masterix21

## dumping-and-importing-from-to-mysql-in-an-utf-8-safe-way.md

      
        
          
            
              
              1 file
            
          
          
            
              
              0 forks
            
          
          
            
              
              0 comments
            
          
          
            
              
              0 stars
            
          
        
        
          
              
          
          
            
                masterix21
                / dumping-and-importing-from-to-mysql-in-an-utf-8-safe-way.md
            
            
              Created
              September 12, 2023 08:36
                — forked from ntamvl/dumping-and-importing-from-to-mysql-in-an-utf-8-safe-way.md
            
              
                Dumping and importing from/to MySQL in an UTF-8 safe way
              
          
        
      
        
  
      
    Dumping and importing from/to MySQL in an UTF-8 safe way

In a nutshell: to avoid your shell character set from messing with imports, use -r to export and SOURCE when importing.
Dumping safely
# Do not do this, since it might screw up encoding
mysqldump -uroot -p database > utf8.dump # this is bad