Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • December 13, 2004 at 3:14 am in reply to: Data sync not working #16646
    wwwild
    Member

    Trying it again, this time with correctly in code tags…

    Code:






    user
    password
    machine name of source machine
    22
    3311

    localhost
    mysql user mysql password 3306 mysql database name



    user
    password
    machine name of target machine
    22
    3315

    localhost
    mysql user mysql password 3306 mysql database name


    December 13, 2004 at 3:12 am in reply to: Data sync not working #16645
    wwwild
    Member

    Here is the schema:

    user

    password

    machine name of source machine

    22

    3311

    localhost

    mysql user

    mysql password 3306

    mysql database name

    user

    password

    machine name of target machine

    22

    3315

    localhost

    mysql user

    mysql password 3306

    mysql database name

    December 10, 2004 at 12:13 am in reply to: Data sync not working #16643
    wwwild
    Member

    Yes – both source and target servers are on remote machines.

    Without SSH tunnelling it appears to work fine. So I guess that there is something going wrong with the SSH tunnel.

    December 10, 2004 at 12:11 am in reply to: Data sync deleting rows in target db #16664
    wwwild
    Member

    I had the same issue when doing a sync between a MySQL 3.23.x server and MySQL 4 server.

    December 7, 2004 at 11:50 pm in reply to: Data sync not working #16641
    wwwild
    Member

    Each connection is on a different port. Naturally, if they are on the same port, an error occurs.

    December 6, 2004 at 9:56 am in reply to: Data sync not working #16639
    wwwild
    Member

    Two more points I'll add to this post –

    1. I am using a SSH tunnel for connections to both the source and target databases.

    2. It appears to be a problem with tables with 100 or more rows of data. I notice this message in the error log when it happens on a table:

    Error No. 2013

    Lost connection to MySQL server during query

  • Author
    Posts
Viewing 6 posts - 1 through 6 (of 6 total)