PHP Classes
elePHPant
Icontem

extract updated data: I want a class that can sync localdatabase with online hosting

Recommend this page to a friend!
  All requests RSS feed  >  extract updated data  >  Request new recommendation  >  A request is featured when there is no good recommended package on the site when it is posted. Featured requests  >  No recommendations No recommendations  

extract updated data

Edit

by kintu micheal - 2 days ago (2017-10-31)

I want a class that can sync localdatabase with online hosting

This request is clear and relevant.
This request is not clear or is not relevant.

+1

being able to sync local content database with online hosting database

  • 1 Clarification request

  • 1. by Maik Greubel - 2 days ago (2017-11-01) Reply

    Syncing only data from one database host to another could be a problem in case of foreign key constraints are in play.

    You need a script, that checks first whether a given primary key already exist in destination database. In case of pk already exist, you need to generate a new one and update references of all foreign keys, where the pk is used.

    But I like this request and want to know, whether I'm able to fullfil that.

    Ask clarification

    1 Recommendation

    PHP MySQL Replication: Client to get MySQL replication events in pure PHP

    This recommendation solves the problem.
    This recommendation does not solve the problem.

    0

    by zinsou A.A.E.Moïse Reputation 4060 - Yesterday (2017-11-02) Comment

    This package may help : This package implements a client to get MySQL replication events in pure PHP.

    It establishes a socket connection to a MySQL binary log server to so it can listen to MySQL database changes events like insert, update, delete queries with their data as well raw SQL queries.

    The events can be dumped for debugging purposes or used to replicate the database on a new server.

    Recommend package
    : 
    :