notas:bases_de_datos
Diferencias
Muestra las diferencias entre dos versiones de la página.
Ambos lados, revisión anteriorRevisión previaPróxima revisión | Revisión previaPróxima revisiónAmbos lados, revisión siguiente | ||
notas:bases_de_datos [2010/04/07 16:46] – cayu | notas:bases_de_datos [2010/10/29 17:03] – cayu | ||
---|---|---|---|
Línea 134: | Línea 134: | ||
show tables like ' | show tables like ' | ||
</ | </ | ||
+ | |||
+ | ==== Replicacion facil ==== | ||
+ | |||
+ | < | ||
+ | [mysqld] | ||
+ | datadir=/ | ||
+ | socket=/ | ||
+ | |||
+ | old_passwords=1 | ||
+ | log_bin = / | ||
+ | relay-log = / | ||
+ | max_binlog_size = 100M | ||
+ | |||
+ | expire_logs_days | ||
+ | max_binlog_size | ||
+ | |||
+ | log-bin | ||
+ | binlog-do-db=proxyauth | ||
+ | skip-slave-start | ||
+ | |||
+ | server-id=1 | ||
+ | replicate-do-table=base.tabla | ||
+ | |||
+ | master-host=10.1.1.1 | ||
+ | master-user=root | ||
+ | master-password=contraseña | ||
+ | master-port=3306 | ||
+ | |||
+ | [mysql.server] | ||
+ | user=mysql | ||
+ | basedir=/ | ||
+ | </ | ||
+ | |||
+ | < | ||
+ | [mysqld] | ||
+ | datadir=/ | ||
+ | socket=/ | ||
+ | |||
+ | old_passwords=1 | ||
+ | log_bin = / | ||
+ | relay-log = / | ||
+ | max_binlog_size = 100M | ||
+ | |||
+ | expire_logs_days | ||
+ | max_binlog_size | ||
+ | |||
+ | log-bin | ||
+ | binlog-do-db=proxyauth | ||
+ | skip-slave-start | ||
+ | |||
+ | server-id=2 | ||
+ | replicate-do-table=base.tabla | ||
+ | |||
+ | master-host=10.1.1.2 | ||
+ | master-user=root | ||
+ | master-password=contraseña | ||
+ | master-port=3306 | ||
+ | |||
+ | [mysql.server] | ||
+ | user=mysql | ||
+ | basedir=/ | ||
+ | </ | ||
+ | |||
+ | **skip-slave-start** //Es para tener que hacer el start slave; manualmente (por si las dudas).// | ||
+ | |||
+ | |||
+ | |||
+ | ==== Importar/ | ||
+ | Importacion : | ||
+ | <code sql> | ||
+ | LOAD DATA LOCAL INFILE ' | ||
+ | INTO TABLE usuarios | ||
+ | FIELDS TERMINATED BY ',' | ||
+ | ENCLOSED BY '"' | ||
+ | LINES TERMINATED BY ' | ||
+ | (nombre, pass, usuario); | ||
+ | </ | ||
+ | |||
+ | Exportacion : | ||
+ | <code sql> | ||
+ | SELECT * FROM usuarios ORDER BY date DESC | ||
+ | INTO OUTFILE " | ||
+ | FIELDS TERMINATED BY ',' | ||
+ | ENCLOSED BY '"' | ||
+ | LINES TERMINATED BY ' | ||
+ | </ | ||
+ |
notas/bases_de_datos.txt · Última modificación: 2013/09/13 14:21 por cayu