I wanted to report on basic activity on my web server so I found and installed AWstats, which I really like.
Importing Apache logs into SQL
Later I wanted to see more details so I started looking for a way to convert Log file entries to database tables. I found the following on goolge and listed them in the order I think will work best on linux.
My computer runs XP. Short explanation- uninstall your primary IDE cable and reboot. Long explanation.First go to device manager which can be reached by right clicking on the My Computer icon and clicking properties OR Start>Settings>Control Panel>System. Once open click on the Hardware tab, then Device Manager Button. The next window shows a tree. Look for “IDE ATA/ATAPI controllers” and click on the ”
The easiest way is to install the DB Maintenance module. Information on how to install a Drupal module is available in our Drupal tutorial.
After the module is installed and activated, you can access it from your Drupal admin area > Administer > Site configuration > DB maintenance. Select the tables which you wish to optimize and click Optimize now.