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
  how to award in postbit bushido 0 1,050 Mar 12, 2016, 10:28 AM
Last Post: bushido
  MyAwards SQL error when clicking "Activate" in Plugins Gh0st 1 1,230 Feb 11, 2016, 03:26 PM
Last Post: Gh0st
  forum/myawards.php not showing? pompano 4 2,706 Feb 24, 2015, 10:02 AM
Last Post: Genesis
  MyBB MyAwards Error Red™ 3 2,804 Oct 31, 2014, 06:23 PM
Last Post: Nasyr
  mybb - myawards help thor 2 1,659 Jul 13, 2014, 03:20 PM
Last Post: Hardi

Forum Jump:


Users browsing this thread: 1 Guest(s)