A common and painful mistake.
WHAT HAPPENED
A push-to-live operation, or a manual copy, replaced the live site with the staging version, including the database.
Everything added to the live site since the staging copy was made is gone: orders, registrations, comments, content.
IMMEDIATE ACTION
Stop. Do not make further changes.
Take a copy of the current state anyway, since it contains the staging content you may need.
RESTORING
Restore the live database from the most recent backup before the overwrite.
If the overwrite happened minutes ago and your backup is from last night, you lose the hours between. That is still better than losing everything.
CHECK JETBACKUP
Restore points may be closer to the moment than your own backups. Check what is available.
RECONCILING
Anything between the last backup and the overwrite must be re-entered. For a shop, check the payment gateway dashboard for orders that exist there and not in the restored database.
PREVENTING RECURRENCE
Always back up immediately before a push-to-live Read the warnings these tools display Never push a staging database to a live site that has data
