How to delete registered devices all at once? (Push Notifications)

Get Started | Login

Discussion Forums > Self Hosted Control Panels

Replies: 3 Views: 87

Adam Aspiring developer Posts: 247 Reg: Oct 23, 2010 Southern Califo... 4,470	confirm \| cancel 06/30/14 05:55 PM (10 years ago) How to delete registered devices all at once? (Push Notifications) Hey guys, Does anybody know to delete all the registered devices at once on your self hosting server? I have an app with 146,000 devices registered. If I can only delete 100 a page I would have to do that 1,460 times which can take hours. I did this for one of my apps that had 10,000 registered devices and it took a while. Any input would be helpful. Thanks, Adam Title Comments Hey guys, Does anybody know to delete all the registered devices at once on your self hosting server? I have an app with 146,000 devices registered. If I can only delete 100 a page I would have to do that 1,460 times which can take hours. I did this for one of my apps that had 10,000 registered devices and it took a while. Any input would be helpful. Thanks, Adam

SmugWimp Smugger than thou... Posts: 6316 Reg: Nov 07, 2012 Tamuning, GU 81,410	06/30/14 06:07 PM (10 years ago) Using a Web Admin tool for your MySQL Database, such as 'phpMyAdmin': 1) Make a backup of your self hosted database. 2) Delete all records from BT_apn_devices That's pretty drastic, but it's how I'd wipe all of them out in one stroke. However, I haven't worked with push, and could possibly be mistaken, which makes step 1 very important. Cheers! -- Smug Comments Using a Web Admin tool for your MySQL Database, such as 'phpMyAdmin': 1) Make a backup of your self hosted database. 2) Delete all records from BT_apn_devices That's pretty drastic, but it's how I'd wipe all of them out in one stroke. However, I haven't worked with push, and could possibly be mistaken, which makes step 1 very important. Cheers! -- Smug

Adam Aspiring developer Posts: 247 Reg: Oct 23, 2010 Southern Califo... 4,470	07/01/14 12:23 AM (10 years ago) Don't want my server to fail or something. Smug you're probably right I will need to delete all the records. Thanks, Adam Comments Don't want my server to fail or something. Smug you're probably right I will need to delete all the records. Thanks, Adam

Adam Aspiring developer Posts: 247 Reg: Oct 23, 2010 Southern Califo... 4,470	07/01/14 12:46 AM (10 years ago) I logged on to my phpmyadmin and it looks like if this works I can only delete 500 at a time. Adam Comments I logged on to my phpmyadmin and it looks like if this works I can only delete 500 at a time. Adam

Login + Screen Name Required to Post Login to participate so you can start earning points. Once you're logged in (and have a screen name entered in your profile), you can subscribe to topics, follow users, and start learning how to make apps like the pros.