This topic is locked
[SOLVED]

 Moving database to another Server and another Domain

9/13/2019 7:22:02 AM
PHPRunner General questions
P
Pamibo author

If I want to move a database to a new, different database on a different server and a different domain: where (in which files) do I have to make changes, regarding access data, domain, database name, password etc.

How the best course?
Thanks for a little help and sorry for my english.
Paul M

L
ludovicmbe 9/13/2019



If I want to move a database to a new, different database on a different server and a different domain: where (in which files) do I have to make changes, regarding access data, domain, database name, password etc.

How the best course?
Thanks for a little help and sorry for my english.
Paul M


make change into file : /connections/ConnectionManager.php

from line 294 to 298
$data["connInfo"][0] = "YOUR DATABASE SERVEUR NAME";

$data["connInfo"][1] = "DATABASE USER NAME";

$data["connInfo"][2] = "DATABASE PASSWORD";

$data["connInfo"][3] = "";

$data["connInfo"][4] = "DATABASE NAME";

woodey2002 9/13/2019

You can also do easily, direct from the runner software also.
https://xlinesoft.com/phprunner/docs/output_directory_settings.htm
On your new domain, create a new database and user who has relevant privileges.
Take note of the details of these.
Back to runner, build you project and click "upload via FTP"
You can also which is very handy indeed create a SQL dump script from the runner build window also, Just import that into your new database to carry across the table structure etc.
The build screen has the option to create multiple database connections,so using the same parameters Mich has described, go ahead and do that, don't forget to save your project also after you add the new connection.
Point the FTP location the the relevant directory on your website, hit upload, sit back and let runner do the hard work for you.
If you do not want to upload via phprunners ftp option on the output tab of runner you can also create multiple database connections. Do this build your project, open output folder making sure your new database connection was selected at the build time. Now you can FTP the entire contents to your new directory with the updated database connection included. Don't forget to switch it back if still developing and build locally.
Cheers,

James