Transfering Keitaro with all data to a new server

Guide

Full step-by-step manual. (opens new window)

How to Transfer Landings/Offers to a new Tracker?

This data is transferred manually. All uploaded archives are stored in a lander folder by default var/www/keitaro/lander. After transferring the tracker create a local landing page or a local offer from the admin panel of a new Keitaro. This will create a new folder for uploaded archives with all the necessary permissions. Next, log in to a new server via SFTP and upload your archives from an old tracker to this created folder manually.

How to Transfer Bot List to a new Tracker?

Copy files from /var/www/keitaro/var/bots to the new server.

Transfer Keitaro from a hosting to a VPS

1. Update to the latest version of Keitaro, make sure there are no available updates.
2. Go to application/config/config.ini file and save DB username, DB password, DB name, Prefix and Salt for passwords.
3. Go to phpMyAdmin - add phpmyadmin/index.php to your server's address.
4. Go to the Export tab and click OK and save the DB dump to your computer.
5. If your database is big, log in to your server with ssh, and run a command

mysqldump -u USER -p DATABASE_NAME | gzip > dump.sql.gz

where USER is your DB username, and DATABASE_NAME is the DB name. Next, insert the DB password and click Enter. Then login to a NEW server with shh and run a command

scp user@old_server:/root/dump.sql.gz /root/dump.sql.gz

Edit the /path/dump.sql.gz if necessary.

1. Next, install a tracker to a new server, and respond “yes” to the question about the database dump. Then insert the path to a saved DB from a previous tracker /root/dump.sql.gz.
2. Insert salt for passwords from the previous config.ini.php file.
3. After the installation is complete, go to Maintenance - Status and Reload Cache.

Error: can't log in after the reinstallation

Reset the password.

pdo error: [1146: Table ‘keitaro_settings’ doesn’t exist] in EXECUTE(«SELECT * FROM keitaro_settings as t»)

Go to old server config.ini.php file, copy the Prefix for tables prefix to a new server config.ini.php file.

Will my data be deleted after the reinstallation?

No, if you insert the same database identity.

How to transfer the database without phpMyAdmin??

The command to create a database dump in a server console:

mysqldump -u USER -p DATABASE_NAME | gzip > dump.sql.gz

You will be asked to enter a password. Then the dump will be downloaded into the archive dump.sql.gz.

The file can be copied from the old server to a new one with SCT utility:

scp dump.sql.gz root@IP:/tmp/dump.sql.gz

This command imports the dump into a database:

zcat /path/to/dump.sql.gz | mysql -u USER -p DATABASE_NAME