Mysql collation problem

  • Resolved mdelabb

    (@mdelabb)


    8 months, 1 week ago

    Migrating from one host to another almost never works because of MySQL collation issues. The only time it works is when I correct the collation beforehand to the one that the target host will accept. But what if I already have a backup that I need to use? Such a solution is useless in that case.

    My question, therefore, is: Is there a way to unpack the .daf file, correct the collation, and then repackage it?

    I tried downloading the SQL file after Duplicator had already unpacked it, made the necessary changes, and then uploaded it again to the exact location. The problem is that when I go through all the steps, the .daf file is unpacked again, which overwrites my changes.

    Or is there any other solution? Any help with this would be greatly appreciated.

    • This topic was modified 8 months, 1 week ago by mdelabb.
    • This topic was modified 8 months, 1 week ago by mdelabb.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support mohammedeisa

    (@mohammedeisa)

    Hi @mdelabb,

    It’s possible to unpack the .daf file as instructed in this post: https://duplicator.com/knowledge-base/how-to-work-with-daf-files-and-the-duparchive-extraction-tool/
    However, it’s not possible to recreate the .daf archive again.

    We understand that you’re facing an issue that requires further investigation, and it may involve sharing log files containing sensitive information about your website. Unfortunately, such sharing is not allowed in www.ads-software.com forums for security reasons.

    To ensure your privacy and get the necessary support, kindly contact us through the form on our Contact Us page, and we’ll be more than happy to assist you promptly:

    https://duplicator.com/contact/?form=1

    Looking forward to hearing back from you.

    Thanks!

    Thread Starter mdelabb

    (@mdelabb)

    Thanks @mohammedeis, I ended up finding a solution that you wrote a while back and it turned out to be very simple. There is actually no need to unpack and pack when following your suggestion. I simply went into advanced mode and then set the desired collation in step 2.

    I had a different problem afterwards, whereby the hoster did not allow Duplicator to change the wp-config.php. I gave up on this one and switched hoster where it then worked seamlessly.

    Thanks for your help.

    Plugin Support mohammedeisa

    (@mohammedeisa)

    Hi @mdelabb,

    This is an excellent news. I’m glad that you are able to sort this out.

    Please don’t hesitate to contact us if you have any questions. We are happy to help.

    Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Mysql collation problem’ is closed to new replies.