pummos

Hi Cory i fixed it 🙂

The problem was that my hosting did not support utf8mb4, but my local WordPress installation uses utf8mb4 as a collation. After reading this post i managed to fixed it.

<?php
$con = mysql_connect('localhost','user','password');
if(!$con) { echo "Cannot connect to the database ";die();}
  mysql_select_db('dbname');
  $result=mysql_query('show tables');
  while($tables = mysql_fetch_array($result)) {
    foreach ($tables as $key => $value) {
      mysql_query("ALTER TABLE $value CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci");
    }}
  echo "The collation of your database has been successfully changed!";
  ?>

How to fix this:

• Place the above php script inside the root WordPress folder on your localhost
• Locate the script trough the browser eg: localhost/mapname/scriptname.php and press enter
• If the script ran succesfully, Build a new package with Duplicator
• Place the installer.php en archive.zip inside the httpdocs map on your FTP
• Run Duplicator domain/installer.php
• Grab a beer and celebrate