We build. You grow.
Get best community software hereStart a social network, a fan-site, an education project with oxwall - free opensource community software
How to save new users before back up restore? | Forum
Kenneth
Oct 23 '15
Is there a way to save the current users before restoring a back up? Many users wouldn't want to sign-up more then once. If something happens to go wrong or you need to restore an old save of your site is there a way to save your users and re-add/upload their data after restoring your oxwall based site?
Kenneth
Oct 23 '15
Is there a way to save the current users before restoring a back up? Many users wouldn't want to sign-up more then once. If something happens to go wrong or you need to restore an old save of your site is there a way to save your users and re-add/upload their data after restoring your oxwall based site?I noticed in SQL you can export tables etc. If you export ow_base_user and after a full restore of and earlier version of your site can you import this same section of your SQL to restore users who signed up recently who get removed from the restore?
Team
Oxwall Tips
Oct 26 '15
Kenneth, ow_base_user is just a base table that contains basic user data. Rest of the data is located in number of other tables related to profile questions, avatars, user roles and etc. Thus exporting only ow_base_user won't help.
My suggestion is exporting whole DB.
Restore your site.
Import whole exported DB into the one that got created automatically after restoration.
My suggestion is exporting whole DB.
Restore your site.
Import whole exported DB into the one that got created automatically after restoration.
Ebenezer from Bluetide Webs
Oct 28 '15
You can export the ow_base_user as CSV and re-import them later. But You should also export this other tables:
ow_friends_friendship - Friendship
ow_base_authorization_user_role - User roles.
Export each of this tables as CSV and import them when you want to.
Kenneth
Oct 30 '15
You can export the ow_base_user as CSV and re-import them later. But You should also export this other tables:
ow_friends_friendship - Friendship
ow_base_authorization_user_role - User roles.
Export each of this tables as CSV and import them when you want to.
Alright thanks, I'll remember this. Oxwall doesn't really support much documentation of backing up and restoring your network.
