How to move log-files to a new PPHLogger installation?

Get help with installation and running PPhlogger 2.2.x here.
Please do not post bug reports or feature requests here.

Moderators: Moderator Team, Development Team

How to move log-files to a new PPHLogger installation?

Postby mercurio on Wed Jan 11, 2006 2:59 am

Hello everybody.

I just installed PPHlogger on another server and tried to move log-files from an existing account onto a new account on the new server.

What I did is exporting

- pphl_xxxxx_logs.sql
- pphl_xxxxx_mpdl.sql

from my old servers' sql database and importing them into the new one. After that I just deleted the log-files for the new account on the new server and renamed the imported ones so that the file names match.

Now, when logging into the new account all I get is sql error messages. Somehow the tables I imported do not work with the account.

Does somebody know what I do have to change to make it work?

Is there an easier way of importing my old logs into the new account?

Thanks for your help!
mercurio
 
Posts: 1
Joined: Wed Jan 11, 2006 2:49 am

Postby sdjl on Wed Jan 11, 2006 7:42 pm

I find the best way of moving MySQL data is by using the command line (SSH, telnet, etc).

Login to SSH if you have it and do the following:

mysql -u USERNAME -p -D DATABASE > pphlogger-backup.sql

You can then tar the file up if you want before downloading or transferring to your other server.
Once at the new location, run the following to import the data:

mysql -u USERNAME -p -D DATABASE < pphlogger-backup.sql

David
User avatar
sdjl
Moderator
 
Posts: 1282
Joined: Mon Nov 17, 2003 1:13 am
Location: London, UK

Problems with dspCalendar.php

Postby ebac on Tue Mar 27, 2007 12:05 am

Hi!

I moved my stats to a new server.

The dspLogs.php shows me all the hits in the correct way but dspCalendar.php shows the 'unique hits' only from the day I installed phlogger in the new server.

Moreover, if I click 'show all pageimpressions' in dspCalendar.php, it shows me the correct statistics (the entire statistic of the user)!

Why 'unique hits' only shows data from the day of new installation on?

Thank you

Enrico
ebac
 
Posts: 2
Joined: Mon Mar 26, 2007 11:51 pm


Return to PPhlogger Support

Who is online

Users browsing this forum: Baidu [Spider] and 19 guests

cron