Database Info

Odd SMS Issue..

Have an odd SMS issue that admittedly I think I created, that honestly I don't think anyone will be able to help with, but I figured I'd give it a shot.
My Photon has been rock solid for months. I'm a VERY heavy texter and don't delete old texts. I think I have between 40k-45k on the phone. It's never had an issue with the amount of texts. I use Handcent rather than the stock messaging app.
About a month ago I reduced the LCD density (to 220) by editing the build.prop file and everything was good. A couple of days ago I decided to try a lower density after reading someone's post about the setting they were running on their Photon, so I changed it 180 and rebooted.
After rebooting, the phone could not start the launcher. Since I couldn't start any app on the phone to reset the build.prop LCD density setting, I used ADB to pull the file to my computer, edited it back to the previous 220 setting, then pushed it back to the phone and rebooted. Phone came up fine. However, ever since then it has been VERY sluggish within both Handcent and the stock messaging app. It takes noticeably longer to open up threads, send a message, scroll, etc. This is the ONLY thing effected on the phone. Thinking that I may have accidentally messed something up in the build.prop file when I pulled/edited/pushed it using my computer, I used RomToolBox to restore a build.prop backup I had from late January. This made no change in the performance of the messaging.
Any thoughts?
Yes, I know 40k+ messages is excessive, and there's a good chance I could fix the issue by deleting them all/clearing the data for SMS/MMS, and I may very well end up doing that, but immediately prior to the changing the LCD density to 180 which the phone obviously didn't like, I had no performance or speed issues with the messaging.
Thanks in advance for any thoughts or ideas.

I've never stored my messages that much. Maybe you could try wipe cache and dalvik via cwm first.
Sent from my XT897 using Tapatalk 2

Yeah, I'm a bit of a message hoarder.. :laugh:
Didn't think about trying to wipe the cache and dalvik. Booting into TWRP now to do that.
Thanks for the idea. :good:

Unfortunately, no change..

What about wiping the cache in that app?
Also, when you muck with build.prop are you fixing the permissions on it? I think it's 0644.

Just a side note for future reference, but if you don't already have/use it, I'd recommend SMS Backup & Restore. Anything you don't want to lose textwise, you can backup and archive to get them off your phone. You can move the archived text bacli[ files to your PC, and then be able to access/read them via this Java applet on Sourceforge:
http://sourceforge.net/projects/smsbackupreader/

arrrghhh said:
What about wiping the cache in that app?
Click to expand...
Click to collapse
Given that I have the sluggish behavior in both the stock messaging app and Handcent I'd be shocked if that fixed it.
Tried it and it didn't make any change.
arrrghhh said:
Also, when you muck with build.prop are you fixing the permissions on it? I think it's 0644.
Click to expand...
Click to collapse
Historically I just used RomToolBox to edit it and never had an issue. It's possible that the permissions got jacked up when I had to pull/edit/push it using my computer. Although since I've already after that restored a known good build.prop from a backup wouldn't that have reset the permissions if they had been wrong? This morning I backed up my messages ( all 48,330 of them ) then wiped them. Sent a few texts back and forth to my Google Voice account and confirmed that the "snappyness" I was use to was back and there were no delays in sending. Wiped them again and now currently going through a restore. I don't think this will make any difference, but I'm just stabbing in the dark at this point. After this restore is done if the issue is still there (and I suspect it will be) I'll check the permissions of the build.prop
PythonFanTN said:
Just a side note for future reference, but if you don't already have/use it, I'd recommend SMS Backup & Restore. Anything you don't want to lose textwise, you can backup and archive to get them off your phone. You can move the archived text bacli[ files to your PC, and then be able to access/read them via this Java applet on Sourceforge:
http://sourceforge.net/projects/smsbackupreader/
Click to expand...
Click to collapse
Yeah, I use that, MyBackup Pro, and Titanium....in addition to manually copying the mmssms.db from /data/data/com.android.providers.telephony/databases/ to my SD Card. :silly:
Thanks again guys for taking the time to read, throw some ideas out there and comment. :good:

For what it's worth, I found this thread to be very interesting...
http://forum.xda-developers.com/showthread.php?t=1453840
Unfortunately it seems as though the originator discovered that there were simply too many little differences Android version to version to make a "one for all" script.
It certainly appears though that at least according to Honusnap that there are some tweaks that can be made to make the SQL DB that Android uses to store the SMS/MMS's more efficient.

[Q] Fixing a broken system App that crashes when there IS internet access

Hi guys.
I need some help or instructions.
I have in my Asus an app that is good, but always crashes. This is a system app called Asus MyLibrary, or Asus Reader.
This doesn't happen only to me, but its known to always crash for everybody
http://www.transformerforums.com/fo...ashes-every-time-i-try-start-asus-reader.html
http://www.transformerforums.com/forum/applications/26417-my-library-replacement.html
http://forum.xda-developers.com/showthread.php?t=1155510
The fix to the problem is turn wifi and data off (or turn on Airplane mode), then it will work fine.
Many people think it is because the app tries to connect to Asus servers (which are down) and this crashes the app.
I would like some help on how to disable this seeking of an internet connection within the app, then recompile it, sign it.
But then it is a system app. Can it be installed as a normal app? (My device is not rooted).
I have tried another app that reads the apk, removes permission to access the net, and packages it into a new apk. This apk wouldn't install in my device. Perhaps because the package name is the same still. I tried modifying the package name (com.asus.reader) to something else (I called it MyReader, com.android.myreader), recompiled, signed, zip aligned, and it still won't install. (App not installed). Perhaps it is conflicting with the original system app still in the phone?
I have two attachments, one is the original apk from the system folder, and reader-sz.apk is the one i've tried to modify the name and package, then signed, and zipaligned. Did I do something wrong that it won't install in the device?
In summary, there are two questions really.
1) Why doesn't reader-sz.apk install in my device? I've changed the app name and package name in the manifest.xml
2) How do I remove (or disable, or nullify) the app from accessing the internet, from within the app itself? (I think simply removing permissions will still crash it, may need to go into the functions itself, is that even possible?)
Please if anyone can guide me, I think you may help many-many users.

Have screwed up Play Store and keyboard on rooted tablet, stuck trying to repair it

Hi, I have a MID-756, also known as an F900, Quadcore A33, with Android 4.4.2. A bog-standard cheap tablet, but having installed a 10,000mah battery, quite a useful device that lasts for several days.
The performance isn't super-sparkly and it does appear to run out of some types of memory sometimes, with browsers prone to shutting down without warning when reading newspaper websites. So I purchased Link2SD Pro and moved as many things as possible to the internal SD card. This also allows you to set some system programs as user programs, which then enables you to move them to the SD card as well, which is very useful.
I also did this with google play store and google play services, and that is when it went wrong, as google play store no longer worked. Based on things other people suggested, I tried various things like clearing caches, but that didn't work. I tried to use the browser to go to the play store and update them, but it said things like, "App will be installed later" - but which never happened. I tried to download google play services and play store APK's from a repository and after deleting the originals I installed them from the APKs. It nearly worked - it got to checking permissions, but instead of starting the download progress bar it said, "Unfortunately google play store has stopped", or words to that effect. Based on one suggestion I tried clearing the data for services and google services framework, and then it wouldn't even connect to the store at all.
So I saved important things and then did a factory reset, under the naive impression that it would restore it to how it had arrived. I discovered that it only clears user data and programs, and does not restore system apps that you've stupidly deleted. Having reinstalled the play services and play store from the downloaded APK's it still wouldn't actually download anything as it failed at the progress bar stage with the same message as before - "Unfortunately google play has stopped".
The other thing is that after doing a complete reset the keyboard became chinese, and having to use the old 'Nokia' way of entering English using a numeric keypad is a nuisance. So I'm keen to be able to restore the Play store function so I can at least download a better keyboard.
I've tried to download the gapps file, saving it on an external SD card and installing it on its own as suggested by one person, even going to the Pico version and each time I get "E: Error in /tmp/sideload / package.zip (status error 255)", which apparently means not enough memory according to one person.
I have looked for a custom ROM to install from scratch, but there don't appear to be any for this model. I considered reinstalling the original ROM I downloaded (exdroid4.4.2_r2-a33-v2.0) but I haven't found a mid-756 driver file so my understanding is that it is highly likely to fail.
I can't now reinstall the Link2SD app in order to set the play-related apps back to system apps again either, even though I tried uninstalling and then reinstalling on my rooted phone in order to get the .APK files and then transfer them across to the tablet. It appeared that the .APK files were automatically deleted from both the app and the Pro licence app.
I'm feeling I've right royally screwed my tablet. I know it wasn't that expensive, but it is pretty useful with the massive battery so I'd really appreciate any pointers to help fix it. I've read the suggested threads but as I can't find a driver file for this device, reinstalling the whole ROM from scratch doesn't seem like a good idea. Is it safe to clear the Dalvik cache and reinstall a whole gapps package though? I'm cautious because so far clearing other caches does not seem to have improved anything and in one case made it worse.
Very grateful for any help received!
Mike

Ok, didn't get any help but finally fixed it and people might like to know how I did it:
To recap, the situation was: Rooted MID-756 / F900 tablet, having deleted play store after it stopped working when I made it a non-system app, and after doing a full reset, found that the only keyboard option was a japanese one with Nokia-style input for Western typeface. Complete nuisance to use and with hardly any even standard apps remaining after I'd previously moved them to SD card, which was then wiped when I did full reset. So, close to useless.
Solution: Use another Android 4.2 phone, and for each of the following apps, [ Google play services, play store, Link2SD, Link2SD (new)] do the following steps:
a) in Link2SD, select an app.
b) in the details screen, from the options menu, select 'share apk'. You may need to scroll the menu up if your screen doesn't show it.
c) When the share apk options come up, select 'google drive'
d) go to your PC, and in google drive, change the name to xxxxx.apk . I don't know why the .apk seems to get missed off, but you need to add it back in again.
e) Once you've done all four apps, copy all of them to a micro SD card.
f) Put the micro SD card in your tablet.
g) in a file manager, go to the external SD card, and click on the google play services.apk. This will take you through the install procedure. When it has finished installing, reboot.
h) Do the same with Link2SD and Link2SD(new). Even if it says that the licence won't verify (it will show a red triangle next to the name when the app is open), don't worry. Select google play services, and in the detail screen, from the options menu select 'convert to system app'. Then reboot again.
i) Do the same with Play Store - install apk, reboot, convert to system app using link2SD and reboot again.
f) Open Play Store. You will probably have to go through some account setting up of google play store which should be familiar to you. This time when you get to play store and try downloading or updating something it should work. If it still doesn't, do one more reboot.
You can now restore all your previous apps, including the google keyboard if you've screwed that up by doing a hard reset. You will now be able to use a proper keyboard again.
If Link2SD was not verifying the licence for the paid version, when play store is working again you should find it will now check the licence properly.
The moral of the story: Play store does not work as a user app, it needs to be a system app, so don't try to convert it to a user app in the first place.

coolinventor said:
Ok, didn't get any help but finally fixed it
Click to expand...
Click to collapse
Ok so I think you are new to xda and so I want to tell you that you will only get a reply when you post summarized threads.
Posting long posts will not get much attention
You can post small posts and then just elaborate your problem when you get a reply
Remember my advice next time whenever you post
Regards milkyway3

You're correct - Point taken, thanks

coolinventor said:
You're correct - Point taken, thanks
Click to expand...
Click to collapse
And ya also remember
Always thank the post using the thanks button whenever you get any help because it is meant for it and these thanks are recorded by the xda community
Regards milkyway3

Doh! I'll get the hang of it eventually

[Root] [HD 10 Suez] Remove parental control applications/restrictions [May 2019]

I've tried to complete this mission a few times, each ending in disaster...until now.
Summary:
The parental control applications too are restrictive. Amazon made some slight changes to the Android code which gave these applications full, and in my opinion unnecessary control of the tablets and the security options. Disabling or uninstalling them can and will eventually cause you to reflash stock firmware. That's because they are labeled as "device/profile owner applications". Located in /data/system is 'device_owner.xml'. That file configures the apps as device/profile owners and doing anything to stop them results in a disaster, often unfixable without reflashing stock. The idea was to trick FireOS by switching device owner applications right from under it's nose. It's not easy but it is possible.
This will be along guide. one or two of these steps may not even be necessary but I am going to present them as I did them and was successful. Beyond that you are free to remove steps and try the process at your will. However any deviation from the guide can result in damage to your device. Even this guide may result in damage to your device, because not everyone's results will be the same. From here on out you are on your own and I am not responsible for any damage done to your devices. This will take some time, if you do not have it it is recommended you do not continue until you do. It will not be possible to pause for extended periods through this guide. This WILL REQUIRE a factory reset. You must be rooted or have an unlocked tablet to complete the guide. You must also have the Google play store and related services installed as system applications in priv-app folder. For this it's recommended to flash a pico Gapps package in TWRP.
THIS OPERATION WAS PERFORMED ON A DEVICE THAT WAS DEODEXED ON 5.6.1.0 WITH A 5.3.6.0 (LATEST FIREOS) BOOT IMAGE. This will not likely work on a stock ROM that has not been deodexed.
Instructions:
1. You need to download an application that uninstalls system applications. Any one of them will do so long as it works. You will absolutely need to download an application that does this. Also download a root file explorer.
2. Uninstall the application called 'Managed provisioning.' then open a shell using a terminal emulator or ADB. Then type the commands below.
Code:
adb shell
su
settings put global device_provisioned 0
3. Go to settings > security > device administrator and make sure Google pay is a device administrator. This is very important and you must not miss this step.
4. Using a root explorer, go to /data/system and copy device_owner.xml to your internal storage. If using your PC please use Notepad++, though it's recommended you complete the following tasks on your device.
4b. Go to system/etc/permissions/ and open handheld_core_hardware.xml in a text editor. Find the line that says: <!-- feature name="android.software.managed_users" --> and replace that line with the one below, save the file and reboot:
Code:
<feature name="android.software.managed_users" />
5. Then go to your internal storage and open the file device_owner.xml in a text editor. Replace the lines of text with the text below, making sure the format is NOT changed from the original and save the file:
Code:
<profile-owner package="com.google.android.gms" name="Google Play services" userId="0" component="com.google.android.gms/com.google.android.gms.mdm.receivers.MdmDeviceAdminReceiver" />
6. NOTE: this step CANNOT be done in TWRP. Again Using a root explorer, copy and paste device_owner.xml to /data/system, overwriting the current one (remember to back up the original). Set permissions to rw (0600) and reboot. If there are no errors or popups and your home and recents button still work after rebooting, continue to the next step.
7. Reboot to recovery and clear/wipe cache and dalvik and reboot system. When booted, if no pop errors from anything, open the uninstaller app you downloaded and uninstall Parental Controls and Parental monitoring. Again reboot to recovery and wipe cache and dalvik and reboot system.
8. Again if no errors, reboot to recovery again and this time do a factory reset. This step is very important and cannot be missed. It is absolutely required that the data be wiped on the device or the device and system will recognize it is no longer owner of said device and it will start shutting you out of security and other options on the device.
9. When rebooted, Open the shell in terminal emulator again or ADB and type the following command below. A reboot should not be necessary when done:
Code:
su
settings put global device_provisioned 1
10. Download an activity launcher (I use activity manager and yes you need to pay a slight fee to use the root part of the launcher, but it's worth it.) Scroll settings and search for 'generic lockscreen set' and long press it to open it with root access. All of your lock screen options should be open and available to you even after removing the parental applications. If they are congratulations you have now remove parental applications and the restrictions that came with them from your device. Go back to /data/system and you will also notice that the device_owner.xml is gone. Killing 2 birds with one stone. If any lockscreen options are blocked then you have failed to properly remove the parental applications and the policies that go along with them.
NOTE: You may need to deactivate 'smart lock' and trusted gms as that may interfere with some lock screen options.
I'll let you guys decide, but I think the device is vastly improved in terms of performance and in Internet connectability after removing these applications.

Edit: forgot a step. Can't believe I did that.
Sent from my Amazon KFSUWI using XDA Labs

I must have goofed. I did a factory reset and now my tablet is back to stock. lol
Edit: I take that back. I tap on parental controls and nothing happens lol
Edit2: Yep It's running good. You were right too. It seems like it runs a lot smoother without amazon's parental controls.

Shadow Death said:
I must have goofed. I did a factory reset and now my tablet is back to stock. lol
Edit: I take that back. I tap on parental controls and nothing happens lol
Edit2: Yep It's running good. You were right too. It seems like it runs a lot smoother without amazon's parental controls.
Click to expand...
Click to collapse
Cuz I'm pretty sure without the support of manage profiles, the parental applications actually cut down on a Wi-Fi speed. I don't think it's cutting short the connection, rather the metrics and scripts associated with other apps and configs, cause it to constantly disconnect and reconnect. also fireOS doesn't like when you have more than one network saved at a time, in the same area. You can also delete etc/wifiloglevels.sh if you are on the deodexed rom. Can also set the value of the line in build prop for wifi rssi levels to ""

Shadow Death said:
I must have goofed. I did a factory reset and now my tablet is back to stock. lol
Edit: I take that back. I tap on parental controls and nothing happens lol
Edit2: Yep It's running good. You were right too. It seems like it runs a lot smoother without amazon's parental controls.
Click to expand...
Click to collapse
Add: you Dan probably reinstall the managed provisioning app. It might let you create a work profile I am not sure. I am going to experiment with that more tomorrow.

I'd like to add that I am on the same battery cycle as the other day when I started this process at 65%. I haven't been as aggressive in my use as much as normal this weekend but I haven't had to put it on the charger all well and usually I have to do that a few times a week if I really use it.

I forgot to mention that step 4 and possibly 5 seem jumbled.

Shadow Death said:
I forgot to mention that step 4 and possibly 5 seem jumbled.
Click to expand...
Click to collapse
Are you using the app?

DragonFire1024 said:
Are you using the app?
Click to expand...
Click to collapse
I'm not sure what app you mean. What I meant was this part:
Using a root explorer, go to /data/system and copy device_owner.xml to your internal storage and open it in a text editor. If using your PC please use Notepad++, though it's recommended you complete the following tasks on your device. Open system/etc/permissions/handheld_core_hardware.xml in a text editor.
Click to expand...
Click to collapse

Shadow Death said:
I'm not sure what app you mean. What I meant was this part:
Click to expand...
Click to collapse
I'll fix it tomorrow. Thanks.

DragonFire1024 said:
I'll fix it tomorrow. Thanks.
Click to expand...
Click to collapse
I figured out what you meant but I thought I would point it out just in case others can't.

Shadow Death said:
I figured out what you meant but I thought I would point it out just in case others can't.
Click to expand...
Click to collapse
Worded it a bit better and broke it apart somewhat. I definitely saw where one would get lost right there. Good eyes!

Hi Dragon Fire,
Is it now working ok? I have the HD8 (7th generation) and would like to eliminate the restrictions of the parental control.

masterted said:
Hi Dragon Fire,
Is it now working ok? I have the HD8 (7th generation) and would like to eliminate the restrictions of the parental control.
Click to expand...
Click to collapse
Every thing is working so far as I can see. There is a slight delay with some apps that require a lock screen be activated for them to work. I use a WiFi app my provider provides and it requires a screen lock. It failed to recognize it at first. Clearing the providers app cache and restarting it worked.
Sent from my Droid RAZR M using XDA Labs

Hi guys, I got a couple questions about this process...
Could someone who did it already check to see if it is possible to change the language of the tablet? On my own tablet, I get a message about parental controls being required, however my own tablet was rooted and debloated a different way last year. In my case, I don't care about changing the language, and I'm totally satisfied with the results I got.
I ask because I'd like to do this "stock Android look & feel" process for a friend (they do not even have an Amazon account, nor want one), but they need to be able to switch language between English and Spanish on a regular basis, and I don't want to mess up their tablet with mods that would prevent this.
Thanks for any insights you guys might have on this... really appreciate the hard work and vast knowledge represented here on XDA.

Kids Dashboard free app and free cloud (Basically you are making dashboard kiosk like small mdm).
PLAY STORE LINK : https://play.google.com/store/apps/details?id=com.tabnova.aidashboard
Cloud Login: https://cloud.kidsdashboard.com
Main site : http://www.kidsdashboard.com/
Complet free app enjoy dont waste money

Backup and Restore ALL Accounts on android

GOAL - a universal backup and restore solution that can take ALL device accounts and ALL their related passwords - back them up - and restore them to ANY version of android - including Phones, Tablets, and Emulators such as bluestacks, memu, nox etc. even from different android versions.
This is primarily to get all EMAILS - google - outlook - etc loaded into a new device *This is NOT for apps as there are plenty of solutions for apps already but none for ACCOUNTS
This software should basically have a database, preferably in an easy to edit CSV format - which would never need to change as it would always have ACCOUNT_TYPE,USERNAME,PASSWORD,RANDOM_DATA
-you could manually populate this via your computer or you could have the android software export it via coding magic. Maybe use a different format and have it load a spreadsheet or a different database type...
Importing would be trickier- you'd have to have a drop down asking questions like - What android version are you importing to- so that the code could be properly inserted...
I intend to ask for advice here and see what solutions you all have; I will edit this first topic to help others if a solution exists.
Some people spend 50 hours of labor installing hundreds of apps on their phone; each needing custom configured, many require having an Account to access data through the app.
What if you have to load 50+ emails into the phone; each of them having huge complicated passwords.
What if you are always buying new devices, changing roms and having to set this all up again?
=Some Solutions exist but none have worked for me.
1. Built in google 'set up new device' -
This only seems to work when you have reset your phone.. once the phone is active and you've actually used it -- there appears to be no way to turn this on and attempt to bring new accounts over...
q. How can you activate this after the fact?
If you have more than a few accounts on the device, say.. 4... maybe you have 20 or 40 email accounts loaded.. it is almost guaranteed to fail.
q. What causes it to fail? Is there any work around.
If you are on android versions too far apart its also likely to fail
q. Why? is there any work around.
*Here is a site with code related to the account transfer API; I'm not sure how accurate it is:
Account Transfer API | Android Developers
developer.android.com
2. Samsung Smart switch
This only copies ONE account - but it also does a fine job of moving text messages, SOME apps and other info over.
*Is there any way to get it to copy all email accounts; and other random app accounts to the new device?
3. Titanium backup - for non root and root.
I've played with this numerous times over the past 10 years and never successfully. I dont think it is capable of taking all accounts and backing up / restoring to different devices.
More to be added later.

Reserved for random info so I can update later;

One month later and no replies...
Anyone?
1. Is there any app on the planet that can do this - or close? ((samsung smart switch - sometimes - though it mostly fails -- Googles built in set up - which fails 95% of the time) - I know of no other solutions.
2. Is there any desire for this? have any of you been annoyed with the menial task of setting this stuff up again and again?

another month goes by.. now I have a new android tablet.. and guess what?
Samsung smart switch wont copy my accounts...
I cant seem to get the built in google 'set up device' to start == and I'm not looking forward to adding 50 email accounts and various other accounts into this manually.. thats gonna take ages...
Buying a new device every couple months.. is a grueling task when it comes to account transfers...
Nobody has any suggestions on a solution for this? I'm searching around randomly again and finding Nothing.

what is your concern?? reading your thread give me headache

I have the same issue. I am "bored" in getting another mobile because i have to setup from beggining soooo many things

IIRC then account details are stored in SQLite database named accounts.db, its location depends on Android version.
Wi-Fi passwords are stored in file named wpa supplicant.conf.

@jwoegerbauer thanks for the tip. using your filename I found a tutorial that listed the location as follows:
/data/system_de/0/accounts_de.db
I've verified this on Nox; my bluestacks still isnt rooted and it seems the phones I have with all email accounts loaded == are not rooted either== I'm going to need to find a workaround for that or make time to root bluestacks to get the account data out of it...
Problem is;
1 there are no passwords included here. Where are they? mine are all crazy long and I have no clue what they are... its very time consuming to manually input them via my password managing tool.
2 Once I export; and change the CSV into a spreadsheet to include all the other missing email /google accounts; how do I replace the accounts_de.db file on each device
3. Why isnt there an app that can do this already; lol?
EDIT
Titanium backup does have an 'accounts' export option that -sorta - works... problem is how picky the app is about using root plus super SU and refuses to work with Magisk (sometimes) or will constantly crash on (some) devices - or will fail to export/import unless you try (5 different file managers that can eventually figure out how to import their file type) - or is otherwise NEEDING root access to function...
Would be nice if a solution existed via ADB or simply in an un rooted device to do this; sorta like how google ''set up nearby device'' was supposed to work (and will; if you use only 5 or less accounts... but its also buggy and fails)

Any ideas on how we can export/import accounts?
Still no successful solution.
1. Notes regarding Titanium:
I've tried about 15 versions of bluestacks using android 4.4.2 and have had mild success with titanium to backup/restore =
however it seems to randomly restore less than all the accounts (missing a few different ones each time)
it also seems to randomly miss the google password tokens randomly =forcing me to log into 10% of the imported accounts with each restore.
It also seems to fail 100% when trying to restore a bluestacks 4.4.2 accounts file on to android 7 bluestacks; or nox / or memu
It has limited success importing into a proper non emulated tablet (again missing about 60% of the accounts randomly)
all in all Titanium doesn't appear to be a good solution.
2. Perhaps a direct edit of the Accounts DB file would be wiser;
I've attempted to export it a few times and am not sure yet how to edit it ...
HeidiSQL has errors when accessing the file
Oracle's sql developer is WORSE; most of the text is gibberish.
*Any ideas on how to edit this?
3. Other xda searches lead me to:
The google password isn't a real password. After first successful authentication, an Auth Token is downloaded to device which is stored in accounts.db.
From the Auth Token is impossible to guess the password.
So I guess I answered my own question on that... I was hoping the passwords were stored on the device database so I could import/export them via a text editor.
4.
*File manager for super users allows one to explore and edit (to a point) a sql database - but one can not add new entries; only edit existing entries.
one can only export to csv; not import.
so this is only a partial solution.
5. an open source XDA solution looks promising but will not work.
Each OnAndBackup version uses different file extensions that are not compatible between versions... so yuo can't backup one android version and restore to another.
OAndBackupX is a fork of the popular open source backup app for Android
Looking for an open source solution to backup individual apps and their data? OAndBackupX is a handy Android app for the job. Check it out!
www.xda-developers.com

Blombardo said:
2. Perhaps a direct edit of the Accounts DB file would be wiser;
I've attempted to export it a few times and am not sure yet how to edit it ...
HeidiSQL has errors when accessing the file
Oracle's sql developer is WORSE; most of the text is gibberish.
*Any ideas on how to edit this?
Click to expand...
Click to collapse
In post #7 you were told it's a SQLite database. Hence use a SQLite browser.
Downloads - DB Browser for SQLite
sqlitebrowser.org

It appears that the art of editing the database file on this is more complicated than it should be...
1. Taking the old DB file from 4.4.2 with a million accounts loaded... -- Export the 'accounts' table into csv
2. taking the new DB file from 7.1.1 with one account loaded - delete existing and then import the old 'accounts' table -
Swap original .db file with new edited one...
and congrats you too have a bootloop...
Anyone know how to PROPERLY export / import the accounts information ?
The sql table otherwise appears the same.. but I'm by no means an expert on these databases so perhaps I missed something simple.
Can't wait to see what happens from nox to bluestacks to memu to real versions of android on multiple devices with multiple android versions...
There HAS to be a better way to do this.?
Edit: 20 plus hours and many weeks into this problem
delving deeper into Titaniums site they have a suggestion for use on emulators that I did not notice; I will try and report back.
12. I have an Android device that is x86 based, and rooted. Can I use Titanium Backup ?​
YES. Please ensure that you have a working BusyBox on your device and make the following changes in TB preferences:
enable the “Force use external BusyBox” option (under Troubleshooting) then hit MENU -> Reload application.

1. I've noticed there are two places for saved account info; I still have no success in getting my edited database to properly recognize in the emulator.
system DE on older 4.4.2
and
system CE on 7.1 (also has the DE folder)
2. No luck on titanium either.
a. I've tried making busy box work on the emulator; it pretends to install successfully but when running shell commands it doesnt seem to work; therefore the number 12 from Titanium FAQ is something I can't seem to accomplish either... so Titanium will not work yet; maybe due to the busybox fail.

Blombardo said:
@jwoegerbauer thanks for the tip. using your filename I found a tutorial that listed the location as follows:
/data/system_de/0/accounts_de.db
I've verified this on Nox; my bluestacks still isnt rooted and it seems the phones I have with all email accounts loaded == are not rooted either== I'm going to need to find a workaround for that or make time to root bluestacks to get the account data out of it...
Problem is;
1 there are no passwords included here. Where are they? mine are all crazy long and I have no clue what they are... its very time consuming to manually input them via my password managing tool.
2 Once I export; and change the CSV into a spreadsheet to include all the other missing email /google accounts; how do I replace the accounts_de.db file on each device
3. Why isnt there an app that can do this already; lol?
EDIT
Titanium backup does have an 'accounts' export option that -sorta - works... problem is how picky the app is about using root plus super SU and refuses to work with Magisk (sometimes) or will constantly crash on (some) devices - or will fail to export/import unless you try (5 different file managers that can eventually figure out how to import their file type) - or is otherwise NEEDING root access to function...
Would be nice if a solution existed via ADB or simply in an un rooted device to do this; sorta like how google ''set up nearby device'' was supposed to work (and will; if you use only 5 or less accounts... but its also buggy and fails)
Click to expand...
Click to collapse
Thanks for the tip just used Titanium Backup to transfer accounts backup generated from one phone to another (using the generated backup files) both N916K rooted with Magisk version 23.0 (23000) without issues!

So is there any Progress or Solutions found yet?
A good thing would be to see all the accounts and then retype them manually if needed.
Else it would be much better to have something like Smart Switch.
Problem I noticed with SmartSwitch, when you try to transfer the Accounts. Samsung trys to grab and upload all the accounts to their server!! Why? I don't know, but it always asks for Internetconnection etc. ONLY when you want to transfer accounts, everything else works more or less.. some appdata not included sadly anyway.
Swift Backup doesn't seem to or did someone manage it to work with it?
Tipps and possible Solutions would be greatly appriciated.
It seems to be especially problematic with Android 12...

Hello, I'm having the same problem. I'm "bored" with obtaining a new phone because I have to set up so many things from scratch. real estate istanbul

A shame there still doesn't seem to be a good solution for this. TB only tries to backup the non-existent location, while the correct is /data/system_de/0/accounts_de.db
Manually moving just puts me into a bootloop, even after setting the correct permissions.

I dont know if this works, someone should test it.
GitHub - cluk33/android-multiuser-backup: A set of scripts to backup and restore apps and data of multiuser android devices.
A set of scripts to backup and restore apps and data of multiuser android devices. - GitHub - cluk33/android-multiuser-backup: A set of scripts to backup and restore apps and data of multiuser andr...
github.com

akhilkhan said:
I dont know if this works, someone should test it.
GitHub - cluk33/android-multiuser-backup: A set of scripts to backup and restore apps and data of multiuser android devices.
A set of scripts to backup and restore apps and data of multiuser android devices. - GitHub - cluk33/android-multiuser-backup: A set of scripts to backup and restore apps and data of multiuser andr...
github.com
Click to expand...
Click to collapse
I spent hours trying to get the script to work, but it will not backup anything in A13. I even disabled DFE on the device and started it over to test.