Week 8: Migrate the Database and the Website to My Webhosting

Boris told us today that on Friday, all our installation - hence, including the website - should be functional even if not all the design is finished yet. Therefore, we decided as a team that the QR codes should be ready by Friday. For the QR codes to be ready, the website needs to go live. This was my job today.

I had never worked with a database on web hosting before, so I called my boyfriend and ask him for some guidance. However, it turned out that with my web hosting provider (Wint Global) the task was super easy! The first thing to do was to go to phpmyadmin on my local server and export the three tables, which resulted in three SQL files that basically rewrite the tables once you re-import them.

On my domain www.werecat-design.com, I first created the sub-domain myenschede.werecat-design.com. This took about 20 minutes to go live. While I was waiting for my sub-domain to be created, I exported the tables form my localhost, created a new database in my web hosting and re-imported the SQL files into the database. It was really easy, because the web hosting offers phpmyadmin as well.

When the sub-domain was ready to use, I also imported the website to the server using the FileZilla web client. Then, I did a few tests in order to see whether everything had worked. I did not encounter any problems. Next, I can proceed to creating the QR codes.