1b.app
Link copied -

Make a backup

Есть запрос на разработку функционала или услугу от партнера?
Вы всегда можете создать топик и там описать задачу! Создать топик
Good afternoon
There was a problem.
Removed hidden goods that were previously sold / shipped in many orders, in connection with this, the balance obligations to customers have changed. Tell me how to make a backup of the database on the date of removal of goods?
Original question is available on version: ru

Answers:

Good afternoon.
On your server, every night at 2:40, a copy of the database is made.
The server has copies of the database for the last 10 days.
the oldest 2020-11-29
newest 2020-12-08
Tomorrow everything will move forward a day.
There is no automatic database rollback in the system.
We can roll back manually - 2 hours.
08.12.2020, 14:00
Original comment available on version: ru

We have already been billed for 2 hours, we put it on payment
Tell me, we don’t have an exact date for the removal of hidden goods, can you see on the history of actions on what date the removal was and exactly make a backup on this date (they were before 11.29)?
08.12.2020, 14:17
Original comment available on version: ru

Need an example of a product that was removed.
08.12.2020, 17:41
Original comment available on version: ru

Confidor Maxi 1 g (Article: IZH00640)
Chorus 3 g (Article: SI-1104)
08.12.2020, 17:50
Original comment available on version: ru

The bill is paid
Please tell me what date was the removal of hidden goods?
09.12.2020, 13:19
Original comment available on version: ru


Rastorguev Anton
Client wrote:
Please tell me what date was the removal of hidden goods?

Goods are:
2020-12-01 2:42 - these products are in the database
These items are out of stock in 24 hours.
2020-12-02 2:42 - these products are no longer in the database
Products have been removed 2020-12-01
09.12.2020, 15:38
Original comment available on version: ru

Making a full backup for 2020-12-01 2:42
09.12.2020, 15:54
Original comment available on version: ru

When do you plan to backup?
10.12.2020, 10:32
Original comment available on version: ru

System Restore at 2020-12-01 2:42
we'll do it within the hour.
10.12.2020, 10:45
Original comment available on version: ru

Your system is restored as of 2020-12-01 2:42
(settings also restored to 2020-12-01)
I don't know how the products were removed, so the "Automatic actions" for cleaning, which are on the daily crown,
I turned it off, just in case.
10.12.2020, 11:34
Original comment available on version: ru

We observe incomplete recovery for some goods, there is no stock history. Example:

This leads to the fact that in orders where these goods were shipped, our obligations were not fulfilled in full and subsequently the client's balance is incorrect
10.12.2020, 11:58
Original comment available on version: ru

The system was restored from the database (completely everything)
as of 2020-12-01 2:42
If something is missing, then it was no longer there at the time of creating a copy of the database.
You yourself wrote on what date to restore the system.

Rastorguev Anton
Client wrote:
Making a full backup for 2020-12-01 2:42

The oldest copy of the database is 2020-11-28 2:42.
If that doesn't work, I can revert the system to Dec 10 11:03.
10.12.2020, 16:50
Original comment available on version: ru


Tasun Sergey Vladimirovich
Employee wrote:
You yourself wrote on what date to restore the system.

It's too much!
10.12.2020, 16:57
Original comment available on version: ru

The question is closed
10.12.2020, 16:57
Original comment available on version: ru

Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter. Log in and comment