{"id":58117,"date":"2023-01-21T03:01:02","date_gmt":"2023-01-20T17:01:02","guid":{"rendered":"http:\/\/www.rjmprogramming.com.au\/ITblog\/?p=58117"},"modified":"2023-01-21T13:57:06","modified_gmt":"2023-01-21T03:57:06","slug":"apachephpmysql-web-hosting-website-migration-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/apachephpmysql-web-hosting-website-migration-tutorial\/","title":{"rendered":"Apache\/PHP\/MySql Web Hosting Website Migration Tutorial"},"content":{"rendered":"
\"Apache\/PHP\/MySql<\/a>

Apache\/PHP\/MySql Web Hosting Website Migration Tutorial<\/p><\/div>\n

Regarding Apache\/PHP\/MySql web hosting, when you see a chance for data migration, take it. The reason being, it is rare for any business run “close to the bone” to have enough resources to organize their own data migration initiative, though we’d all like to do so. Why?<\/p>\n

Well, MySql degrades in performance over time with the web server disk becoming discontiguous, we’re pretty sure?! No, we have no proof. But, put it this way, before the wonderful domain migration our hosters, Crazy Domains<\/a>, initiated on the 17\/1\/2023, we could not …<\/p>\n


\nREPAIR TABLE wps_comments
\n<\/code><\/p>\n

… it would just time out on our RJM Programming WordPress MySql database comments table, but afterwards, this same SQL command was not an issue. We rest our Archimedes style empirical evidence based cases<\/sub><\/a>.<\/p>\n

So, if your hoster offers a (domain\/website\/data) migration offer, do not stand in the way. They’ll be the ones who have access to the best resources needed to carry out such an operation, that in all likelihood, will improve the performance of your Apache\/PHP\/MySql domain websites. We can already see the performance improvement on many of the PHP\/MySql “products” existing on the RJM Programming domain, after the 17\/1\/2023. Thanks, Crazy Domains<\/a>!<\/p>\n

Did you know?<\/i><\/b><\/p>\n

Researching some PHP (web application) whose MySql failed before the data migration, it would say words to the effect …<\/p>\n

\nMySql table wps_posts is marked as crashed. Please repair.\n<\/p><\/blockquote>\n

… but unlike other “repair jobs” this table was not shown as “in use” in the phpMyAdmin<\/a> database table listing webpage, causing us confusion as to whether to take the error message above, seriously. But after the data migration we felt braver about trying the repair, and it worked, and it made the relevant PHP web application involved, to start working again, happily!<\/p>\n

If this was interesting you may be interested in this<\/a> too.<\/p>\n