Hi, I recently had a lot of problems uploading my site files to 123 Reg my Web Host.
Basically, in the end it is now fixed but they told me this:
"Initially when we have tried to perform the local.sql file import to the database we’ve received the below message:
“ERROR 1273 (HY000) at line 98: Unknown collation: ‘utf8mb4_0900_ai_ci’”
Although this is not something that falls within our scope of support we’ve looked into this error and the solution was to replace the collation: ‘utf8mb4_0900_ai_ci’ from the local.sql file with ‘utf8mb4_unicode_ci’
Afterward, we have managed to complete the import. We’ve then accessed the website and then this redirected to http://unica-creative-design.local which was due to the site and home URL which have then been modified to http://unicadesign.co.uk/
Since you did not have the default WordPress .htaccess file, we’ve created this from our end in your web hosting’s public_html folder.
The website is now loading as you may confirm from the attached screenshot, however, certain elements are still set to the URL on which the site was built.
The URLs within the site’s code can be sorted by using using a plugin such as Velvet Blues Update URLs https://wordpress.org/plugins/velvet-blues-update-urls/ or Search & Replace https://wordpress.org/plugins/search-and-replace/
We’ve also set the file permission to 644 and file permission to 755 since the wp-admin page was not loading due to a permission error."
How can I avoid these issues in future? Thanks!