Diferencias

Muestra las diferencias entre dos versiones de la página.

--- notas:bases_de_datos [2011/07/04 13:36] – cayu
+++ notas:bases_de_datos [2013/09/13 14:21] (actual) – [Replicacion facil] cayu
@@ Línea 6: / Línea 6: @@
 ==== Perl DBI ====
+^**MySQL**^**PostgreSQL**^
-^^**MySQL**^**PostgreSQL**^^
 |$db=DBI->connect("dbi:mysql:database= ... )|$db=DBI->connect("dbi:Pg:database= ... )|
@@ Línea 13: / Línea 12: @@
 ==== Sintaxis y lenguaje ====
+^**MySQL**^**PostgreSQL**^
-^^**MySQL**^**PostgreSQL**^^
 | SHOW FULL PROCESSLIST / SHOW PROCESSLIST | SELECT * FROM pg_stat_activity |
 | # | -- |
@@ Línea 27: / Línea 25: @@
 ==== Tipos de datos ====
-^^MySQL^PostgreSQL^comments^^
+^MySQL^PostgreSQL^comments^
 |<code>
 TINYINT
@@ Línea 155: / Línea 153: @@
 server-id=1
+replicate-do-db=base
 replicate-do-table=base.tabla
@@ Línea 185: / Línea 184: @@
 server-id=2
+replicate-do-db=base
 replicate-do-table=base.tabla
@@ Línea 221: / Línea 221: @@
 </code>
+<code bash>
+mysql -u root -p  cdr -B -e  "select * from \`calldetails\` limit 2;" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g'
+</code>
 ===== Oracle =====
@@ Línea 235: / Línea 237: @@
   * start the DB - I use restart just to be sure: $ sudo /etc/init.d/oracle-xe restart
-Q: After installing and sourcing /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh I was getting /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.sh: 114: %%[[%%: not found each time starting a shellA:Change the nls_lang.sh to use your shell %%(/%%bin/bash) instead of /bin/sh on top of the script.Q:after installing oracle xe I cannot login to apex (oracle web admin) under sys or system. It won't accept my login/password. Keeps saying access denied although I'm sure the password is correct (the one used during /etc/init.d/oracle-xe configure)A:Use a longer password! It won't complain but seems like it doesn't like short passwords. Use at least 8 chars.Q:After some time your oracle connected application runs into
+Q: After installing and sourcing /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh I was getting /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.sh: 114: %%[[%%: not found each time starting a shell
+A: Change the nls_lang.sh to use your shell %%(/%%bin/bash) instead of /bin/sh on top of the script.
+Q: after installing oracle xe I cannot login to apex (oracle web admin) under sys or system. It won't accept my login/password. Keeps saying access denied although I'm sure the password is correct (the one used during /etc/init.d/oracle-xe configure)
+A: Use a longer password! It won't complain but seems like it doesn't like short passwords. Use at least 8 chars.Q:After some time your oracle connected application runs into
@@ Línea 272: / Línea 283: @@
 $ sudo /etc/init.d/oracle-xe restart or $ sudo /etc/init.d/oracle-xe force-reload
+Fuente: http://ubuntu-answers.blogspot.com/2010/10/oracle-xe-issues.html