YaCy '#[clientname]#': Content Integration: Retrieval from phpBB3 Databases

#%env/templates/metas.template%#
#%env/templates/header.template%# #%env/templates/submenuIndexImport.template%#

## Content Integration: Retrieval from phpBB3 Databases

It is possible to extract texts directly from mySQL and postgreSQL databases. Each extraction is specific to the data that is hosted in the database. This interface gives you access to the phpBB3 forums software content.

If you read from an imported database, here are some hints to get around problems when importing dumps in phpMyAdmin:

- before importing large database dumps, set the following Line in phpmyadmin/config.inc.php and place your dump file in /tmp (Otherwise it is not possible to upload files larger than 2MB):

      $cfg['UploadDir'] = '/tmp';

- deselect the partial import flag

When an export is started, surrogate files are generated into DATA/SURROGATE/in which are automatically fetched by an indexer thread. All indexed surrogate files are then moved to DATA/SURROGATE/out and can be re-cycled when an index is deleted.

The URL stub,
like http://forum.yacy-websuche.de
this must be the path right in front of '/viewtopic.php?'
Type of database
(use either 'mysql' or 'pgsql')
Host of the database
Port of database service
(usually 3306 for mySQL)
Name of the database on the host
Table prefix string for table names
User that can access the database
Password for the account of that user given above
Posts per file
in exported surrogates

Import a database dump,

#(check)#::

Posts in database
  #[posts]#
first entry
  #[first]#
last entry
  #[last]#

::

Info failed: #[error]#

#(/check)# #(export)#::

Export successful! Wrote #[files]# files in DATA/SURROGATES/in

::

Export failed: #[error]#

#(/export)# #(import)#::

Import successful!::

Import failed: #[error]#

#(/import)# #%env/templates/footer.template%#