miércoles, 16 de junio de 2010
martes, 23 de marzo de 2010
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)
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
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
Suscribirse a:
Entradas (Atom)