TinyButStrong - the PHP Template Engine
Categories > TinyButStrong general >

using TbsSQL with Mysql Db on Google Drive

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs

By: TomH
Date: 2015-01-03
Time: 23:50

using TbsSQL with Mysql Db on Google Drive

Apologies if this is too far off topic...

Trying to use my LAN computers to access  database that stay synced --- I have set up MySQL to run by pointing to the databases on my Google Drive folder.

MySQL works fine from either of my computers when running individually - however after editing a table from computer"A"  Google Drive does not recognize that the db table file has changed (so that it can sync the files to the other computer). I discovered that if I stop the MySQL process (running on Windows 7) Google Drive recognizes that the file has changes and syncs the other computer as expected.

So to me that means MySQL is keeping the table file open in anticipation of further queries.

Using TbsSQL ... is there a way to make MySQL close the currently open/changed table file so (simulating what happens when your stop the MySQL process?

I do not think this is a TBS or TbsSQL problem -- I think it's a dumb user' problem

Thanks for any help or hints anyone has for this issue --

TomH
By: TomH
Date: 2015-01-04
Time: 02:35

Re: using TbsSQL with Mysql Db on Google Drive


Well,

Just learned that after 30 minutes MySQL "releases" the table file and GoogleDrive sees it as changed and syncs the other computer to the new table values.

Is there a default setting that I can alter to reduce the delay?

Thanks
By: Skrol29
Date: 2015-01-04
Time: 23:16

Re: using TbsSQL with Mysql Db on Google Drive

Did you try UNLOCK TABLES ?

http://dev.mysql.com/doc/refman/5.0/en/lock-tables.html

By: Sheepy
Date: 2015-01-13
Time: 06:57

Re: using TbsSQL with Mysql Db on Google Drive

I'd try FLUSH LOGS followed by FLUSH TABLES.  FLUSH TABLES alone may be sufficient, though.  This will force MySQL to release all table file locks.