Remote and local syncing fine but database does not update

  • Hi,

    I made my site locally and cloned it to a remote server. Revisr is set up and everything appears to be working properly, but even though the databases say they are being created and pulled, no content changes on the remote server. It still looks like a fresh install except for having the plugins and theme folder from the repo.

    I read another post in here where you tell the guy had a similar problem and you telll him that he needs to make the database prefixes the same. Mine were different, but I recreated the remote instance to make them the same but it is still not working.

    Do the database names have to be the same? Because one thing that could be related is that the shared hosting I have makes databases that start with my user name, something like myusername_wp.

    In PHPMyAdmin, they show a “folder” (that + thing that opens and shows the databases inside) with “myusername” and inside that is every database and they all start with “_”, like “_wp”. So, I tried to recreate that on my local machine, by naming the database “myusername_wp”. This is not in a “folder” because I only have one. If the database name matters, is what they have and I have the same the way I have made it?

    Both of them have the same prefix, which I set to, “bits_”

    So, this may or may not be database name related or prefix related.

    Any ideas?

    Thanks.

    I

    https://www.ads-software.com/plugins/revisr/

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Expanded Fronts

    (@expandedfronts)

    Hi,

    The database prefixes normally just need to be the same – the database name itself shouldn’t matter.

    Are you getting any errors? Just to make sure I understand your issue correctly – you have the “Import DB when pulling changes” option checked, and when you do a pull, the DB does not import?

    Thread Starter b_d_m_p

    (@b_d_m_p)

    Hi,

    Sorry for the late reply. Thanks for your help.

    So, now the database name and prefixes are the same, just to be safe.

    I am not getting any errors. I do have “Import DB when pulling changes” option checked. And when I do a pull, the DB does not import. Strange, isn’t it.

    What should I do next?

    Plugin Author Expanded Fronts

    (@expandedfronts)

    Hi,

    Can you please paste over the debug info from the Help tab in the Revisr settings?

    Are normal files being pulled correctly?

    When you do a pull, do you see the “Successfully imported the database.” message?

    Sorry for all the questions, but they should help to narrow down the issue. Thanks!

    Thread Starter b_d_m_p

    (@b_d_m_p)

    Hi,

    No, not a problem at all. Thank you for the help.

    Operating System Darwin
    Exec() Enabled true
    Git Install Path /usr/bin/git
    Git Version git version 2.3.2 (Apple Git-55)
    MySQL Install Path Not Found
    File Permissions true
    Repository Path /Users/b_d_m_p/Projects/stuff
    Repository Status Click here to view.

    I overwrote my remote instance database with my local one so I could get it up and running, but yes, I think it did say “Successfully imported the database.”

    Thread Starter b_d_m_p

    (@b_d_m_p)

    I just played around a little more and tried to clone my remote instance to a new local instance. Same as before, but I did get it to say “Error importing database” on the local instance when I was trying to sync with mysql.

    With the database backup as WordPress, I got the local to say that it synced the database, but nothing changed. Then after that when I tried to pull the changes, it would just say processing and that loading gif would spin. Eventually, I reloaded the page and it said pulled commit, but it didn’t say it imported the database.

    Anyway, still in the same situation.

    Thread Starter b_d_m_p

    (@b_d_m_p)

    Can you tell me what exactly I should have in my .gitignore to get the best results?

    Plugin Author Expanded Fronts

    (@expandedfronts)

    Hi,

    If you were getting “Error importing database” – the issue is likely with the MySQL Install Path not being found – the fix would be to either add the path to MySQL (recommended) or use the WordPress driver (as I see you’ve already tried).

    The WordPress database driver works great for smaller sites, but if you have a larger database it may have some issues due to everything being processed via PHP.

    I would give a shot at adding the path to the MySQL binary and seeing if that fixes the issue.

    As far as .gitignore – this depends on what you want to track in the repo. At the very least, I’d recommend ignoring the wp-config.php and .htaccess files. You can ignore more than that, but if you want database backups and imports to work, you need the wp-content/uploads/revisr-backups folder included in the repository.

    It’s worth mentioning as well that the next version of Revisr will include a few basic .gitignore/repository profiles for quicker/easier setup.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Remote and local syncing fine but database does not update’ is closed to new replies.