# Restore post from files not from Exporter **URL:** \ **Category:** Developer help\ **Created:** [January 15, 2019, 6:40pm UTC](https://forum.ghost.org/t/restore-post-from-files-not-from-exporter/5087 "2019-01-15T18:40:47Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![Doris\_Ulysse](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/doris_ulysse/32/2315_2.png) [@Doris\_Ulysse](https://forum.ghost.org/u/Doris_Ulysse)\ **Post date:** [January 15, 2019, 6:40pm UTC](https://forum.ghost.org/t/restore-post-from-files-not-from-exporter/5087/1 "2019-01-15T18:40:48Z")
I lost my website and was able to recover the folders. Can I restore post from an existing backup folders if a backup file from export of json does not exist? ---
**Author:** ![Hannah](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/hannah/32/22_2.png) [@Hannah](https://forum.ghost.org/u/Hannah)\ **Post date:** [January 15, 2019, 9:52pm UTC](https://forum.ghost.org/t/restore-post-from-files-not-from-exporter/5087/2 "2019-01-15T21:52:46Z")
Was your Ghost install using MySQL or sqlite? If it was using sqlite, you may have a copy of the database in a .db file in /content/data. You maybe also have a backup JSON file in that folder. If you were using MySQL and you don’t have a .json file, you’ll need a mysql dump from the server in order to restore your content. ---
**Author:** ![Doris\_Ulysse](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/doris_ulysse/32/2315_2.png) [@Doris\_Ulysse](https://forum.ghost.org/u/Doris_Ulysse)\ **Post date:** [January 16, 2019, 1:33pm UTC](https://forum.ghost.org/t/restore-post-from-files-not-from-exporter/5087/3 "2019-01-16T13:33:15Z")
Good morning, Let me start of by saying thank you !!! 😁👏 I allowed ghost cli to install default settings my sql . Can I just keep it simple by uploading those files mention above with the import tool within ghost admin? ---
**Author:** ![Hannah](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/hannah/32/22_2.png) [@Hannah](https://forum.ghost.org/u/Hannah)\ **Post date:** [January 16, 2019, 1:36pm UTC](https://forum.ghost.org/t/restore-post-from-files-not-from-exporter/5087/4 "2019-01-16T13:36:52Z")
If you’re restoring from a JSON file that was in your /content/data file you would need to upload that file to the import tool in Ghost admin. You will also want to make sure you copy across all the files and folders from the old /content/ folder, as that includes your images, themes and some settings. ---
**Author:** ![Doris\_Ulysse](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/doris_ulysse/32/2315_2.png) [@Doris\_Ulysse](https://forum.ghost.org/u/Doris_Ulysse)\ **Post date:** [January 16, 2019, 3:29pm UTC](https://forum.ghost.org/t/restore-post-from-files-not-from-exporter/5087/5 "2019-01-16T15:29:16Z")
This is great ! I miss spoke earlier it is actually sql lite. Do you have docs that explain how to import sql into the current database? ---
**Author:** ![Doris\_Ulysse](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/doris_ulysse/32/2315_2.png) [@Doris\_Ulysse](https://forum.ghost.org/u/Doris_Ulysse)\ **Post date:** [January 16, 2019, 3:41pm UTC](https://forum.ghost.org/t/restore-post-from-files-not-from-exporter/5087/6 "2019-01-16T15:41:20Z")
I was able to locate this documentation ! and dont want to corrupt the database ! ![03%20AM](https://us1.discourse-cdn.com/flex015/uploads/ghost2/original/2X/1/17cd512901dfcb3e7d7f7a2cb8b9784a8eb29769.jpeg) ![17%20AM](https://us1.discourse-cdn.com/flex015/uploads/ghost2/original/2X/9/9ba4a004f4a261cc199011251f86a6d72691a43c.jpeg) ![31%20AM](https://us1.discourse-cdn.com/flex015/uploads/ghost2/original/2X/5/53c530f8e35e2cb5d574a3ef1301e5f534eee4fb.jpeg) ---
**Author:** ![Hannah](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/hannah/32/22_2.png) [@Hannah](https://forum.ghost.org/u/Hannah)\ **Post date:** [January 16, 2019, 3:52pm UTC](https://forum.ghost.org/t/restore-post-from-files-not-from-exporter/5087/7 "2019-01-16T15:52:47Z")
With SQLite, your database _is just a file_. So there’s no “importing” as such. On your server, make sure ghost is stopped using `ghost stop`. Then copy the database file into place, and then `ghost start`. You can copy all of the /content/ directory. ---
**Author:** ![Doris\_Ulysse](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/doris_ulysse/32/2315_2.png) [@Doris\_Ulysse](https://forum.ghost.org/u/Doris_Ulysse)\ **Post date:** [January 16, 2019, 6:30pm UTC](https://forum.ghost.org/t/restore-post-from-files-not-from-exporter/5087/8 "2019-01-16T18:30:21Z")
Pardon the confusion, when I looked in the data content folder. I found this file when I opened it said Sqlite and made the assumption that the database was sqllite ![29%20AM](https://us1.discourse-cdn.com/flex015/uploads/ghost2/original/2X/4/4c3085a0971c67fb43cc7d81c23235c0ae8929cf.jpeg) ![21%20PM](https://us1.discourse-cdn.com/flex015/uploads/ghost2/original/2X/8/87e57d8ccae7e4797bae2ab070aa00b6f8a238d3.png) But when I compare the old config.production.json and come it to the new blog configuration I see Mysql ![24%20PM](https://us1.discourse-cdn.com/flex015/uploads/ghost2/original/2X/5/55ca90e0c381142610b841074a24e9fa56c68877.png) So far I havent found a way to reinstall the old ghost site to do the mys ---
**Author:** ![Hannah](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/hannah/32/22_2.png) [@Hannah](https://forum.ghost.org/u/Hannah)\ **Post date:** [January 17, 2019, 2:56pm UTC](https://forum.ghost.org/t/restore-post-from-files-not-from-exporter/5087/9 "2019-01-17T14:56:47Z")
That SQLite DB looks like it was just for dev mode, perhaps the blog got fired up in dev mode once. Doesn’t look like it contains any content. ---
**Author:** ![Doris\_Ulysse](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/doris_ulysse/32/2315_2.png) [@Doris\_Ulysse](https://forum.ghost.org/u/Doris_Ulysse)\ **Post date:** [January 17, 2019, 3:00pm UTC](https://forum.ghost.org/t/restore-post-from-files-not-from-exporter/5087/10 "2019-01-17T15:00:59Z")
How could that be dev mode when the config file was built in production. I fired this up I digital ocean but did not use the one clock installation. These file have to be in another folder. ---
**Author:** ![Hannah](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/hannah/32/22_2.png) [@Hannah](https://forum.ghost.org/u/Hannah)\ **Post date:** [January 17, 2019, 3:08pm UTC](https://forum.ghost.org/t/restore-post-from-files-not-from-exporter/5087/11 "2019-01-17T15:08:58Z")
Your production config is for MySQL. There are not going to be any SQLite DB files for production mode in any folder. The only way to restore your content would be to do a mysql dump or a Ghost export from the original server. ---
**Author:** ![Doris\_Ulysse](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/doris_ulysse/32/2315_2.png) [@Doris\_Ulysse](https://forum.ghost.org/u/Doris_Ulysse)\ **Post date:** [January 18, 2019, 1:15pm UTC](https://forum.ghost.org/t/restore-post-from-files-not-from-exporter/5087/12 "2019-01-18T13:15:12Z")
Got it but the system crashed. All I have are the files is there a way to create a mysql dump with the files. Any suggestion is much appreciated! Cheers ! ![22%20AM%20(2)](https://us1.discourse-cdn.com/flex015/uploads/ghost2/original/2X/e/e92a44b905c3d5727383461c3edcda52401439d5.png) ---
**Author:** ![Hannah](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/hannah/32/22_2.png) [@Hannah](https://forum.ghost.org/u/Hannah)\ **Post date:** [January 18, 2019, 3:10pm UTC](https://forum.ghost.org/t/restore-post-from-files-not-from-exporter/5087/13 "2019-01-18T15:10:18Z")
That’s not something I’ve ever had to do - my best advice is to ask google 🙂 Maybe someone else has pointers… ---
**Author:** ![Doris\_Ulysse](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/doris_ulysse/32/2315_2.png) [@Doris\_Ulysse](https://forum.ghost.org/u/Doris_Ulysse)\ **Post date:** [January 25, 2019, 3:53pm UTC](https://forum.ghost.org/t/restore-post-from-files-not-from-exporter/5087/14 "2019-01-25T15:53:17Z")
This was a learning curve you can close this ticket. But I got the the post back. Now the blog shows up on my device and not everyone else. Any Insight on how nginx server block may affect this. ![35%20AM%20(2)](https://us1.discourse-cdn.com/flex015/uploads/ghost2/original/2X/4/4002b2ecbe5a822646d75890fe9c726e0dbf739c.png) ![17%20AM](https://us1.discourse-cdn.com/flex015/uploads/ghost2/original/2X/e/e624af67006a6754f01b2f22a57cc3d806e293bc.jpeg) ---
**Author:** ![Doris\_Ulysse](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/doris_ulysse/32/2315_2.png) [@Doris\_Ulysse](https://forum.ghost.org/u/Doris_Ulysse)\ **Post date:** [January 25, 2019, 3:55pm UTC](https://forum.ghost.org/t/restore-post-from-files-not-from-exporter/5087/15 "2019-01-25T15:55:07Z")
![49%20AM](https://us1.discourse-cdn.com/flex015/uploads/ghost2/original/2X/c/cec723ff5301636ed2d286c9e9b7daa2adeba927.png) ![28%20AM](https://us1.discourse-cdn.com/flex015/uploads/ghost2/original/2X/b/ba2b17b0dc26a8c65ef217f0e2fdf3a22bd549ce.png) ---
**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/ghost2/original/2X/b/ba9ce5100b8bb264586f4f572545596b2ce3f081.png) [@system](https://forum.ghost.org/u/system)\ **Post date:** [February 8, 2019, 3:55pm UTC](https://forum.ghost.org/t/restore-post-from-files-not-from-exporter/5087/16 "2019-02-08T15:55:07Z")
Closed on February 8, 2019, 3:55pm UTC This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.