jueves, 11 de marzo de 2010

Ejemplo de METAQUERY

select concat('select * into outfile \'',table_name,'.csv\' from ',table_name,';')
from tables where table_schema='jardineria';
| concat('select * into outfile \'',table_name,'.csv\' from ',table_name,';') |
| select * into outfile 'Clientes.csv' from Clientes; |
| select * into outfile 'Clientes2.csv' from Clientes2; |
| select * into outfile 'DetallePedidos.csv' from DetallePedidos; |
| select * into outfile 'Empleados.csv' from Empleados; |
| select * into outfile 'GamasProductos.csv' from GamasProductos; |
| select * into outfile 'Oficinas.csv' from Oficinas; |
| select * into outfile 'Pagos.csv' from Pagos; |
| select * into outfile 'Pedidos.csv' from Pedidos; |
| select * into outfile 'Productos.csv' from Productos; |
9 rows in set (0,00 sec)

Actividad 11-03-2010

miércoles, 10 de marzo de 2010

martes, 9 de marzo de 2010

recorte de configuración my.cnf

myisam_sort_buffer_size = 8M

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!

# Replication Master Server (default)
# binary logging is required for replication

miércoles, 3 de marzo de 2010

Copias de Seguridad

Físicas en Frio Completa
cp =>tar =>gz 
Físicas en Caliente Completa
Físicas en Frio Incrementales
cp=> mysql-bin
Físicas en Caliente Incrementales
cp=> mysql-bin
Lógicas en Frió Completa
Lógicas en Caliente Completa
Lógicas en Frió Incrementales
Lógicas en Caliente Incrementales