Support

UNiTE, Remote CLI, eXtract Wizard

#3502 automaically backup while edit an article by another author

Posted in ‘UNiTE and Remote CLI’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

PHP version
n/a
Tool
UNiTE
Tool version
n/a

Latest post by user6076 on Thursday, 28 May 2009 07:59 CDT

user6076
Hallo,
are there problems, if I start an backup by JP-Native-Tools, while another author is editing and saving an article or is uploading pictures?
Myrtus

dlb
It depends on what sort of problems you are looking for. The person editing the article has the editor files, etc. loaded into memory, so there are no "file lock" issues. The article itself is stored in the database. The version of the article that is in the backup will be what was saved in the database at the time of the dump, not the "in process" edited version.

Similarly, an image being uploaded would be included if it was in the folder at the time the file list engine listed the files in the folder. That is a little oversimplified, but close enough.

JoomlaPack does not attempt to lock the database tables when it dumps them. If you are insanely unlucky and the article save hits at the same exact time as the dump command, then MySQL would have to play traffic cop. I'm not sure what low level locking would occur, but it could potentially affect one or both operations. It is usually assumed that a table or record lock is a temporary condition and the operation should be tried again at the database interface level.

Practically anything can happen in the real world, so yes, there could be problems. But from a statistical standpoint, you shouldn't lie awake at night worrying about them. :lol:

Dale


Dale L. Brackin
Support Specialist


us.gifEnglish: native


Please keep in mind my timezone and cultural differences when reading my replies. Thank you!


????
My time zone is EST (UTC -5) (click here to see my current time in Philadelphia, PA)

user6076
Thank you very much for the answer.

Myrtus

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!