MySQL basics 2

 

# Backup , To be in Dos perform            mysqldump        Instructions   Actually in mysql The installation directory \bin below

  If the system variable is set , It can be done anywhere dos Under the window ( sign out mysql In the state of )

 

Backup database cesi cesi2 ( Back up these two libraries to e Discoid bas.sql file )

mysqldump -u root -p -B  cesi cesi2      >e:\\bas.sql 

 

                                  Back up the two databases to e disc

 

 

          Delete library cesi,  cesi2    (drop database cesi2)

                             

Delete a demo  

 

                          If you delete it by mistake , You can use the backed up database to restore .

recovery 1： 

#   Method 1       dos Restore under command     Previously backed up databases
 SOURCE e:\\bas.sql 

 

  Connect mysql    Resume

 

 

recovery 2    Choose a graphical interface software （sqlyong,navicat Fine ）

 

  # Method 2       hold bas.sql Assign paste   Create a new query and execute it OK 了