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
Next revisionBoth sides next revision
linux:analisislogs [2009/04/11 01:28] rlunarolinux:analisislogs [2009/04/11 20:21] rlunaro
Line 17: Line 17:
 <code> <code>
 mysql> create table logs mysql> create table logs
-    -> (ip varchar(15), +       (ip varchar(15), 
-    ->  user varchar(10), +        user varchar(10), 
-    ->  pass varchar(10), +        pass varchar(10), 
-    ->  date varchar(50), +        date_raw varchar(50), 
-    ->  peticion varchar(250), +        date varchar(30), 
-    ->  code tinyint, +        time varchar(30), 
-    ->  code2 smallint, +        timezone varchar(10), 
-    ->  ein varchar(50), +        request varchar(250), 
-    ->  agent varchar(500)); +        code1 tinyint, 
-Query OK, 0 rows affected (0.16 sec)+        code2 smallint, 
 +        referer varchar(500), 
 +        agent varchar(500));
  
 mysql> load data low_priority infile "/home/rluna/access.log" into table logs fields terminated by ';' optionally enclosed by '"'; mysql> load data low_priority infile "/home/rluna/access.log" into table logs fields terminated by ';' optionally enclosed by '"';
linux/analisislogs.txt · Last modified: 2022/12/02 22:02 by 127.0.0.1