Share your knowledge at the LQ Wiki.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 07-08-2004, 01:21 PM   #1
Registered: Oct 2001
Location: Texas
Distribution: Slackware 13
Posts: 214

Rep: Reputation: 31
SQLite database backup

I've been searching around for a while trying to find out where SQLite saves its databases to, but I can't seem to find the answer. I figured that I would find the database in my user home directory but it is not there.

I am using KRecipes with SQLite as the database engine. The options show that it is saving the database to the LocalHost. This is the first time I have used SQLite or any other database before so I am at a loss to how they really work. I have my database ready and I want to transfer it from my laptop to my desktop.

What I have done:

Read the man pages and help for SQLite. (Did not find my answer.)
Check on KRecipes website. (They are still working on their Docs.)
Searched with Google. (Did not find my answer.)

Thanks ahead of time for any ideas,
Old 07-09-2004, 03:22 PM   #2
LQ Newbie
Registered: May 2002
Distribution: Mandrake 9.2 + Cooker
Posts: 8

Rep: Reputation: 0
The file is at ~/.kde/share/apps/krecipes/krecipes.krecdb.

If you want to transfer it to another computer just copy it onto the other computer into the same directory, run Krecipes (you may get the wizard, and there you just selected SQLite), and that's it.

-Jason K
Old 11-01-2004, 06:54 PM   #3
Registered: Apr 2003
Location: Baton Rouge, LA
Distribution: Kubuntu 12.04, 12.10, 13.04a
Posts: 244

Rep: Reputation: 30
One of my sqlite databases is called 'personal.' The file is at .../SQLite/personal.db.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQLite database security - doesn't exist? vharishankar Linux - Security 2 11-30-2005 08:40 PM
automate database backup Stormproof Linux - Networking 1 10-19-2004 03:19 AM
Automating a full database backup dominant Linux - Newbie 2 07-10-2004 07:59 AM
Need script to dump database, ftp file to backup server glock19 Linux - Networking 17 05-12-2003 05:56 PM
Had to restore database from backup - about 5 minutes lost jeremy LQ Suggestions & Feedback 0 01-21-2001 10:31 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 09:36 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration