I am pretty new to MySQL. I want to build some MySQL databases but at an older date than the current one on my server. I need this because the database will be used to post articles to my site at certain times and since I already have articles posted on it (without using any database), I want to be able to add these articles to the database but at the actual time they were posted at.
I tried to change the server date through root access before building the MySQL database, but it is not letting me do so. I am using a cpanel hosting but the server is not dedicated to me.
It is because I am using a php script that I load the articles to it once a month and then it schedules them every tuesday, thursday and sunday starting from the last upload date. So, If I add them now, they will start from the current date of the server... even if i change the upload date, in myphpadmin, the next batch will go from the scheduled date not from the one I modified.
I am thinking of renting a virtual server (VPS). I heard you can change the date on some of them. I can build the database there and then import it to my current server.