MANTENIMIENTO BASE DE DATOS

Description

Mind Map on MANTENIMIENTO BASE DE DATOS, created by rodrigo.higareda on 10/13/2015.
rodrigo.higareda
Mind Map by rodrigo.higareda, updated more than 1 year ago
rodrigo.higareda
Created by rodrigo.higareda over 10 years ago
8
0

Resource summary

MANTENIMIENTO BASE DE DATOS
  1. rename user
    1. set password
      1. asignar password a cuenta
      2. create user
        1. grant
          1. Asignar permisos a usuarios
            1. revoke
          2. drop user
            1. restore table
              1. repair table
                1. show index
                  1. cheksum table
                    1. Routine
                      1. optimize table
                        1. flush
                        2. check table
                          1. show
                            1. show database
                              1. show privileges
                                1. show logs
                                  1. show status
                                    1. show tables
                                      1. show triggers
                                        1. show variables
                                          1. show index
                                            1. show warnings
                                            2. kill
                                              1. LOAD INDEX INTO CACHE
                                                1. reset master
                                                  1. reset
                                                  2. cache index
                                                    1. PURGE MASTER LOGS
                                                      1. http://manuales.guebs.com/mysql-5.0/sql-syntax.html#other-administrative-sql
                                                        Show full summary Hide full summary

                                                        Similar