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

No Access To The Sql Databases During A Data Sync?

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › No Access To The Sql Databases During A Data Sync?

Viewing 2 reply threads
  • Author
    Posts
    • July 12, 2011 at 7:30 am #32411
      peterlaursen
      Participant

      If you can connect with the SQLyog GUI you can also connect with a Data Sync job – using either direct connection, HTTP-tunnel or SSH-tunnel. But you will need valid credentials of coruse for all server you connect to.

      Could you please details what problem you have? If you have an erro please provide details of the error (error no. and error message). Also tell if you are using direct connection, HTTP-tunnel or SSH-tunnel.

    • July 12, 2011 at 6:21 pm #32412
      thomas80
      Member

      thanks for the fast respronse.

      Sorry for the bad or undetailed discreption.

      I'm testing actually the trail version of the webyog software. I created and job file and it is running correctly.

      every 10 minutes the schedule made the syncronisation for two tables (the maximum of the trail version 🙁 )

      I seee it in the logfile 🙂

      My questions is :

      Can I get problems during the synchronisation. I mean can I have trouble to have access to the databases from my website?

      I need everytime access from my website to the MYSQL database(for website) also during the syncronisation between my local database and the database

      of the website

      I saw an error message at my website. “No acces to database”. I think it was during a syncronisation 🙁

      I hope you can answer my email as soon as possible.

      Thanks for all.

      Best Regards

      Thomas

      'peterlaursen' wrote:

      If you can connect with the SQLyog GUI you can also connect with a Data Sync job – using either direct connection, HTTP-tunnel or SSH-tunnel. But you will need valid credentials of coruse for all server you connect to.

      Could you please details what problem you have? If you have an erro please provide details of the error (error no. and error message). Also tell if you are using direct connection, HTTP-tunnel or SSH-tunnel.

    • July 13, 2011 at 7:37 am #32413
      peterlaursen
      Participant

      Data Sync does not LOCK explicitly anywhere and does not prevent other clients (also not a web site script) to access the data.

      Please see if you will get the error again. Ther could be lots of reason for this that are not SQLyog related.

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.