# Manualy copy backup in folder

**URL:** https://forum.antennapod.org/t/manualy-copy-backup-in-folder/365
**Category:** Support
**Created:** [November 13, 2020, 8:03pm UTC](https://forum.antennapod.org/t/manualy-copy-backup-in-folder/365 "2020-11-13T20:03:44Z")
**Posts on this page:** 1
**Showing post:** 8

<div class="post-metadata">

### Author: ![anxomaxon](https://forum.antennapod.org/letter_avatar_proxy/v4/letter/a/8baadc/32.png) [@anxomaxon](https://forum.antennapod.org/u/anxomaxon)
#### Post date: [December 4, 2020, 12:25pm UTC](https://forum.antennapod.org/t/manualy-copy-backup-in-folder/365/8 "2020-12-04T12:25:09Z")

</div>

I was faced with a similar situation - really wanted to re-use my local files, since some of my downloaded podcasts are no longer available online. It’s a bit tedious but was worth my while.  
Here is what I did:

1. Used the export function of AntennaPod on my old phone “Settings”-\>“Storage”-\>“Import/Export”-\> got to save the file “AntennaPodBackup-2020-12-04.db” on my phone
2. Transferred AntennaPodBackup-2020-12-04.db to my laptop
3. Installed an SQL-browser, eg. from [https://sqlitebrowser.org/](https://sqlitebrowser.org/) (available for all major platforms; for me it’s xubuntu 20.04 LTS) - I don’t know much about SQL so I wanted to make sure I do thinks right.
4. Opened AntennaPodBackup-2020-12-04.db with the sql-browser.
5. Clicked on the tab “Browse Data” (or equivalent), then selected the table “FeedsMedia”.
6. Clicked on “file\_url” to sort the rows for downloaded podcasts to the top. Each cell of “file\_url” contains the storage location on my old phone. The relevant parts of the path can also be looked up in AntennaPod: go to “Settings”-\>“Storage”-\>“Choose Data Folder”. I did this also on the new phone to find out what differs. On my old phone my podcasts where on an SD-card, on my new phone I only have internal storage.  
What I now want is to change all those cells, for example, I want  
/storage/3444-4326/Android/data/de.danoeh.antennapod/files/media/Seriously/Apollo 8.mp3  
to become  
/storage/emulated/0/Android/data/de.danoeh.antennapod/files/media/Seriously/Apollo 8.mp3
7. Clicked on the tab “Execute SQL”.
8. I entered the following SQL commands:  
update feedmedia set file\_url = replace(file\_url,“3444-4326”,“emulated/0”) where downloaded = 1;  
update feeds set file\_url = replace(file\_url,“3444-4326”,“emulated/0”);  
To execute this: CTRL+Enter.  
These commands replace the location for the media-files and temporary storage (not exactly sure about the latter, just to make sure).
9. Checked in “FeedsMedia” and “Feeds” that the cells in the “file\_url”-column have been updated
10. Clicked on “Write Changes”
11. Transferred “AntennaPodBackup-2020-12-04.db” to the new phone (again used USB-transfer)
12. I had already transferred the media files, you might still have to do that - copy the structure containing your podcast files in “/Internal shared storage/Android/data/de.danoeh.antennapod/files/media/” from the old phone to the new.
13. Used the import function of AntennaPod on my new phone (navigate to the location of file “AntennaPodBackup-2020-12-04.db”) -\> after restart AntennaPod recognised the files on the new phone

Notes:  
(1) There are more professional ways to issue the SQL commands but I preferred the SQL-browser to interactively check that I did not make a mistake.  
(2) The SD-card-ID “3444-4326” is just an example, to be replaced as needed.  
(3) File name “AntennaPodBackup-2020-12-04.db” and locations on the phone(s) may vary, to be adapted as needed. I used simple USB-transfer.

HTH

---

_[View the full topic](https://forum.antennapod.org/t/manualy-copy-backup-in-folder/365)._