MySQL Database is not importing/exporting data correctly

  • niblettes

    (@niblettes)


    4 years, 3 months ago

    I’m doing local development, and then push to a remote on Dreamhost. I am using the Shopkeeper theme, and running a child theme. I have used Customize on the child theme.

    The problem is the child them on remote fails to get all of the customizations.

    When I compare the DB content on remote and local they are not identical.

    How can I ensure that all of the data is being moved correctly??

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator threadi

    (@threadi)

    4 years, 3 months ago

    I would first want to know which way you are currently transferring the data to the external database?

    Thread Starter niblettes

    (@niblettes)

    4 years, 3 months ago

    I have used phpMyAdmin for both local:export and remote:import

    I have tried doing it at the command line, but MySQL on MAMP isn’t reachable that way.

    I have tried Sequel Pro and it can produce a local export, but crashes when it tried to connect to remote.

    So, phpMyAdmin.

    Moderator threadi

    (@threadi)

    4 years, 3 months ago

    Since you are using an external tool for migration with phpmyadmin, the WordPress community can’t really help you with this. If you have questions about the possibilities of phpmyadmin, contact a community that supports this software.

    For WordPress there are several plugins that allow the migration of WordPress data. An example would be this plugin: https://ww.wp.xz.cn/plugins/duplicator/

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘MySQL Database is not importing/exporting data correctly’ is closed to new replies.