forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › No Access To The Sql Databases During A Data Sync?
- This topic has 3 replies, 2 voices, and was last updated 14 years ago by
peterlaursen.
-
AuthorPosts
-
-
July 12, 2011 at 7:30 am #32411
peterlaursen
ParticipantIf 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
Memberthanks 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
ParticipantData 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.
-
-
AuthorPosts
- You must be logged in to reply to this topic.