User Tools

Site Tools


linux:analisislogs

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
linux:analisislogs [2009/04/11 20:21] rlunarolinux:analisislogs [2009/04/11 20:47] rlunaro
Line 30: Line 30:
         agent varchar(500));         agent varchar(500));
  
-mysqlload 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> </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"
 +
 +
  
  
linux/analisislogs.txt · Last modified: 2022/12/02 22:02 by 127.0.0.1