Move piwik to its own database [#1799290]

Hi all,

My piwik tables are currently in my drupal database but I want to move piwik data to its own database. I can see piwik has about 20 tables plus two tables of data per month (piwik archive blob and piwik archive numeric). Can anyone please tell me do any of these tables belong to the drupal piwik module and so should be left in the drupal database or should I just move all piwik tables to a new database?

Thank you

Comments

Comment #1

hass CreditAttribution: hass commented 30 September 2012 at 20:26

Status:

Active

» Fixed

If you are not limited by your hoster to one database only I would use two db's and no table prefixes.

Comment #2

Juc1 CreditAttribution: Juc1 commented 30 September 2012 at 21:06

Ok thanks but since my piwik tables are currently in my drupal database (see below) I need to move them to a second database - so does the drupal piwik module have any tables in the drupal database or should I move all piwik tables leaving no piwik table in the drupal database?

Thanks

piwik tables currently in my Drupal database =

piwik_access
piwik_archive_blob_2011_03
piwik_archive_blob_2011_04
etc
piwik_archive_numeric_2011_03
piwik_archive_numeric_2011_04
etc
piwik_goal
piwik_logger_api_call
piwik_logger_error
piwik_logger_exception
piwik_logger_message
piwik_log_action
piwik_log_conversion
piwik_log_conversion_item
piwik_log_link_visit_action
piwik_log_profiling
piwik_log_visit
piwik_option
piwik_pdf
piwik_session
piwik_site
piwik_site_url
piwik_user
piwik_user_dashboard
piwik_user_language