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
log-slow-queries=/usr/mysql6/log/slow-querys6.log
log-error=/usr/mysql6/log/errores_mysql6.log
log=/usr/mysql6/log/querys6.log

# 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!
#
#skip-networking

# Replication Master Server (default)
# binary logging is required for replication
log-bin=/usr/mysql6/log/mysql6-bin