Changes

Jump to navigation Jump to search

MySQL (edit)

Revision as of 06:32, 6 August 2015

61 bytes added ,  06:32, 6 August 2015
→‎add .sql to MySQL database
Line 2: Line 2:  
backup:   
 
backup:   
 
  mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql
 
  mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql
 +
backup .sql.gz
 +
mysql -uroot -ppassword mydb > myfile.sql.gz
    
restore:  
 
restore:  
Retrieved from "https://wiki.herrerosolis.com/index.php/Special:MobileDiff/585"

Navigation menu