REGISTER or LOGIN to have the annoying ads removed.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Award accidentally deleted on MyAwards.
#11
If you want all the data restored then you can just restore the whole database, but thats going to mean that all your posts from then onwards are gone Sad

Otherwise i think your pritty much stuck.
Reply
#12
Install your backup on a separate DB. Then run queries to grab the uids of the users with the award. Then manually just a give them the award again manually.
Reply
#13
Or you can just go to PHPmyadmin to check the exact tables that was stored for uids who have awards granted to them. Export that only table out. Then go to your current DB and import it in.

But i think you'll be best importing the entire awards DB.

Okay, I've checked my DB for you. You can go to phpMYadmin, Export mybb_myawards_user_users and mybb_myawards . Then go to your current DB which you're about to restore. Import it in. Replace the current tables. You should see the members back with that award. Doing this will not remove the posts from your last backup till current. Post will be retained and awards will be restored.
Reply
#14
So I upload the backup I have to a new database, and do what you explained ? That seems simple enough. Hopefully I can try that soon and let you know about it.

Have you personally done this before, iAlert ?
Reply
#15
(Jan 18, 2011, 02:01 AM)iAlert Wrote: Or you can just go to PHPmyadmin to check the exact tables that was stored for uids who have awards granted to them. Export that only table out. Then go to your current DB and import it in.

But i think you'll be best importing the entire awards DB.

Okay, I've checked my DB for you. You can go to phpMYadmin, Export mybb_myawards_user_users and mybb_myawards . Then go to your current DB which you're about to restore. Import it in. Replace the current tables. You should see the members back with that award. Doing this will not remove the posts from your last backup till current. Post will be retained and awards will be restored.


That will NOT work properly. There is also a users column for awards too.
Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
  MyAwards on vBulletin Tate 4 1,725 Dec 02, 2017, 08:53 PM
Last Post: Desy83
  how to award in postbit bushido 0 1,108 Mar 12, 2016, 10:28 AM
Last Post: bushido
  MyAwards SQL error when clicking "Activate" in Plugins Gh0st 1 1,325 Feb 11, 2016, 03:26 PM
Last Post: Gh0st
  forum/myawards.php not showing? pompano 4 2,868 Feb 24, 2015, 10:02 AM
Last Post: Genesis
  MyBB MyAwards Error Red™ 3 2,944 Oct 31, 2014, 06:23 PM
Last Post: Nasyr

Forum Jump:


Users browsing this thread: 1 Guest(s)