In this tutorial we are going to show you how to transfer your PixelPost to your hosting account with TMDHosting. The first thing you will need to do is transfer your existing PixelPost files via FTP to your hosting account with TMDHosting. If you have accessed your PixelPost site using https://yourdomain.com/ you must upload your files in the /public_html/ directory of your account. If you have accessed the site using https://yourdomain.com/blog/ you must upload the files in /public_html/blog/. You can find our FTP video tutorials at:
https://tmdhosting.com/tutorials/video/ftp.html
The second thing you will need to do is export your PixelPost database. You can easily export the database using a database management tool like phpMyAdmin. To export a MySQL database via phpMyAdmin follow the steps in our video tutorial at:
https://www.tmdhosting.com/tutorials/video/phpmyadmin/phpma-export.html
Now you will need to create a new MySQL database in your TMDHosting account. You can easily do this via your cPanel > MySQL Database Wizard. Simply follow the steps on the screen and wizard will guide you through the whole process.
Next you will need to import the exported copy of your site’s database in your newly created one. To import a MySQL database you can use phpMyAdmin. To complete the import follow the steps in our video tutorial at:
https://www.tmdhosting.com/tutorials/video/phpmyadmin/phpma-import.html
The final step is to edit your PixelPost configuration file. The file is located in:
/path-to-pixelpost/includes/pixelpost.php
Find the following lines:
$pixelpost_db_host = “localhost”; // database host, often “localhost”
$pixelpost_db_user = “dabatase_user”; // database user
$pixelpost_db_pass = “password”; // database user password
$pixelpost_db_pixelpost = ” dabatase_name”; // database
Replace the dabatase_user, dabatase_name and password with the database credentials that you created earlier. Save the file and upload the updated version of the file in your account.
Congratulations, you have successfully transferred your PixelPost website.