Migrate tables

Migrate tables

Using the GUI

• Launch D2P (see Installation )
• Connect to your MySQL database (left column)
• Insert input & output prefix (right column)

  Please note:
  We do not suggest to insert Joomla's table prefix. Although D2P should work, it is provided "as is", without any warranty. We suggest to keep a backup of original Phoca Download tables.

This is just an advise...I tested my software many times and I've never had troubles.

• Click "convert"

After conversion, you have to move all your document placed on your server in the "dmdocuments" folder (and subdirectories) into the "phocadownload" folder.

Using the CLI

• Launch D2P through the CLI passing cli as argument.
• Insert database authentication informations.
• Insert input and output tables prefix

  Please note:
  We do not suggest to insert Joomla's table prefix. Although D2P should work, it is provided "as is", without any warranty. We suggest to keep a backup of original Phoca Download tables.

After conversion, you have to move all your document placed on your server in the "dmdocuments" folder (and subdirectories) into the "phocadownload" folder.

Meaning of the arguments

name	description	value
username	SQL server instance username. Check your username have rights to read/write/create tables.	Blank if no authentication needed, otherwise set it to your valid username
password	SQL username's password.	Blank if username has no password, otherwise set it to your username's password
IP	Your SQL server IP address.	No blank value accepted. You can both provide an Ip address or a DNS name (e.g. mysqlserver.example.com). If you're working on the same machine which hosts your SQL server, set it to "localhost" (means 127.0.0.1)
Schema	The name of the Database you want to connect to	No blank value accepted.
input prefix	The prefix of input tables. You can get this value checking your Joomla configuration (configuration.php under site root) or viewing tables' names	No blank value accepted. Common (Joomla's default) prefixes are jos_ (Joomla 1.5); jml_(Joomla 2.5)
output prefix	Prefix of output tables.	No blank value accepted. You can set it to your Joomla's site prefix, would be better if you use first a test prefix.
Add to cat id	You can add an integer number to all categories&files id. Useful If you want to merge sites.	0 is ok if you don't want to merge sites

[VTP]

I keep getting "Database authentication failed". I've checked to make sure that I'm correctly entering the MySql username, password, our server's IP address, and the database name, to no avail.

[VTP]

Following up - I've also tried, instead of our numeric IP address, to use our nameserver. Same result, unfortunately.