# Transfering Keitaro with all data to a new server
- How to Transfer Landings/Offers to a new Tracker?
- How to Transfer Bot List to a new Tracker?
- Transfer Keitaro from a hosting to a VPS
- Error: can't log in after the reinstallation
- pdo error: [1146: Table ‘keitaro_settings’ doesn’t exist] in EXECUTE(«SELECT * FROM keitaro_settings as t»)
- Will my data be deleted after the reinstallation?
- How to transfer the database without phpMyAdmin??
# 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
- Update to the latest version of Keitaro, make sure there are no available updates.
- Go to
application/config/config.inifile and save DB username, DB password, DB name, Prefix and Salt for passwords. - Go to phpMyAdmin - add
phpmyadmin/index.phpto your server's address. - Go to the Export tab and click OK and save the DB dump to your computer.
- 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.
- 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.
- Insert salt for passwords from the previous config.ini.php file.
- After the installation is complete, go to Maintenance - Status and Reload Cache.
# Error: can't log in after the reinstallation
# 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