Differences

This shows you the differences between two versions of the page.

--- linux:analisislogs [2009/04/11 18:21] – rlunaro
+++ linux:analisislogs [2022/12/02 21:02] (current) – external edit 127.0.0.1
@@ Line 30: / Line 30: @@
         agent varchar(500));
-mysql> load data low_priority infile "/home/rluna/access.log" into table logs fields terminated by ';' optionally enclosed by '"';
+</code>
+Y luego lo importamos con el comando mysqlimport:
+<code bash>
+mysqlimport --fields-terminated-by=";" --fields-enclosed-by="\""  --local=true --low-priority --user=rluna --password --verbose test logs
 </code>
+**Nota:** es importante que el fichero y la tabla de destino se llamen igual. En este caso hemos tenido que renombrar el fichero a "logs".