Transfer Keitaro to a 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. Где 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. Correct the /path/dump.sql.gz if necessary.
  6. 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.
  7. Insert salt for passwords from the previous config.ini.php file.
  8. After the installation is complete, go to Maintenance - Status and Reload Cache.

Error: can't log in after the reinstallation

  1. Run curl > /var/www/keitaro/reset_password.php in a Terminal.
  2. Open in browser http://domain/reset_password.php.
  3. Choose login and enter a new password, press “Change password”.
  4. Run in the terminal “rm /var/www/keitaro/reset_password.php” to delete the reset script.

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.

How to Transfer Bot List to a new Tracker?

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

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