{"id":437,"date":"2024-12-29T11:56:05","date_gmt":"2024-12-29T03:56:05","guid":{"rendered":"https:\/\/www.tunerli.com\/?p=437"},"modified":"2024-12-29T11:56:05","modified_gmt":"2024-12-29T03:56:05","slug":"preparation-for-migrating-blog-host-to-on-premise-part-2","status":"publish","type":"post","link":"https:\/\/www.tunerli.com\/index.php\/2024\/12\/29\/preparation-for-migrating-blog-host-to-on-premise-part-2\/","title":{"rendered":"Preparation for migrating blog host to on-premise \u2013 Part 2"},"content":{"rendered":"\n
So I finally decided to start the backing up and migration work from the cloud server.<\/p>\n\n\n\n
It’s been quite some time since the website was set up, more than 4 years. There were also many changes to the settings compared with the very initial ones and because I was lazy to keep the notes up to date, I was lost on the current configurations, including the database the website is using, the connection account and password, and also some other manual configurations, etc. Literally, I am facing a website I have not much knowledge of how it’s set up. Ok, then, let’s refresh the memories by checking the settings one by one, and also updating the notes or even create a more formal documentation for future reference. Fortunately, I still have the admin credentials of the cloud server, both the local host and MySQL, which makes things a little bit easier.<\/p>\n\n\n\n
First, let’s see the website configuration from wp-config.php<\/code> file under the website root directory by sudo cat \/var\/www\/site\/wp-config.php<\/code> <\/p>\n\n\n\n<\/figure>\n\n\n\n
Ok, now there are four main tasks <\/p>\n\n\n\n
\n
Back up the database used by the site and also the site files;<\/li>\n\n\n\n
Copy the database and site file backups to the on-premise server;<\/li>\n\n\n\n
Install necessary software and Create a new database on the on-premise server and import the data to the new database;<\/li>\n\n\n\n
Configure the site to use the new database;<\/li>\n<\/ul>\n\n\n\n
Task 1<\/strong><\/p>\n\n\n\n
\n
Archive the site files using tar tar -czvf wordpress_backup.tar.gz \/var\/www\/tunerli.com<\/code> <\/li>\n\n\n\n
Back up the database mysqldump -u root -p database > wpdata_backup_20241228.sql<\/code><\/li>\n<\/ul>\n\n\n\n
Task 2<\/strong> <\/p>\n\n\n\n
\n
I have limited the SSH access to the cloud server only from my home workstation, so I will need to copy the backups from the cloud server to my home workstation and then copy them to the on-premise server.<\/li>\n\n\n\n
Copy the backups from the cloud server to my workstation\n
Now it’s time to confirm! As I haven’t figured out the DDNS solution\/vendor, I can only test with the IP information for now and I have done that in the conf file for the site. So now access it from IP <\/p>\n\n\n\n<\/figure>\n\n\n\n
Bingo! Works. Ok, now I am going to update the documentation for this part before I start working on the next step of DDNS setup.<\/p>\n","protected":false},"excerpt":{"rendered":"
![\"\"](\"https:\/\/www.tunerli.com\/wp-content\/uploads\/2024\/12\/image.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.tunerli.com\/wp-content\/uploads\/2024\/12\/2024-12-29-11_43_42-MrSuns-Website-\u2013-A-Site-to-Record-and-Share-and-11-more-pages-Personal-Micr.png\")
<\/figure>\n\n\n\n