When I delete row entries in my sandbox, the corresponding entry in the live database is not deleted.
Firstly, is there a way to delete a set of rows in the sandbox? Rather than one at a time in the editor?
And how do I make this consistent with the live database. I don’t want to have to delete 2 sets of entries just to eliminate one item.
Hi Deborah,
The sandbox and live databases are not synchonized automatically. You can manually sync the databases in whichever direction you want by clicking on Sync.
I hope this helps.
Yisrael
Hey Deborah,
Think of the Sandbox as your “play area”. The information you type in there is used to “play” and test your code on the pages you are working on.
The Live database is real information that is live on your site.
The two don’t “talk” to each other.
If you happen to use real information in your “play area” simply click on the Sync button as Yisrael has shown you above … so that your Live database reflects the actual real data you want to use.
Hi … Yisrael and Deborah, I understand everything you say BUT… the issue is: after you hit sync wix only allows you to SEND data to live not DELETE it …there is no “OVERWRITE LIVE with this collection” option (that would solve the problem) so if you delete a record in sandbox and sync It will be deleted from sandbox but after syncing that record wil still be shown in live… (captures included) … what is the problem with that?? If the dataset, array or list (or whatever) result from the query still contains that record, that product will be shown in the repater then our clients will ask for it!.. I understand a solution would be to implement a “not available” tag but sending negative messages to our clients just doesnt do it for us… is there a way to solve this??? best regards///
Correct. You can override the Sandbox to reflect whatever you have on your Live … but not the other way around.
You should edit your live database directly … then override Sandbox IF it is that you want both to have identical data.
They dont NEED to be identical for anything to work.
Your Live database is edited the same way … simply from a different location. Do you know how to access your Live database? (It is not stored in your Editor … it simply allows you a “peek” to see what is there)
With all due respect, I agree with the OP and disagree completely with Yisrael and Nayeli.
This is a bug.
When I perform a “full sync”, the live and sandbox databases SHOULD be exactly the same. It makes no sense to only partially sync data when the option is a full sync. The english is not correct here. At least give us the OPTION of doing a true “full sync”. The sandbox mode is what we primarily interact with in the editor.
Thank you
It isn’t a bug, it is a missing feature. A bug is something that is broken and doesn’t work correctly. It works perfectly as it was intended to be.
If it were a continuous exact sync data in the sandbox and live database then there would be no logical reason to have both exist. You would only need one.
The reason there is two is so that if you break something, you have the ability to fix it without compromising real data.
Hi! It’s not a bug, it was decision about this behavior. Idea is - by overwrting you can eliminate live collection with one click. We don’t want it)
Think of it this way: you have 1000 rows in live database and 5 rows (just for testing-developing your site) in sandbox. In this case, by only 1 button you destroy your live collection and your site stops working until you full in all data again
So, as Code Queen Nayeli already mentioned (thanks), you should edit live database from dashboard - and this simplifies things
Also, if you want to delete multiple rows or make a backup - export your data to csv, edit it with any spread sheet application and import back again
In other words:
A way to control Live Data regardless of the data shown in the Sandbox is accessed through the button right to ‘Sync’: “Edit Live Data”-
Which leads to the dashboard section where you control your live data.
I absolutely love WIX but some things drive me crazy and this is one. I’m sorry but your explanations on synching sandbox to live are pretty lame. You should be able to do all your changes - adding records and deleting records in the sandbox area, and when ready sync to the live and have all changes updated. That is reason enough for the two databases. As for deleting multiple rows - export to csv, delete the rows and reimport. Seriously??? Jeez! Don’t get me wrong I still and always will love WIX but . . . . .
so how can I delete in batch all of the live rows ( on purpose )?
please please add a feature to delete all live rows ( add a “are you sure” if you are uncomfortable with this…
