LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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.

Notices


Reply
  Search this Thread
Old 07-08-2004, 01:21 PM   #1
ddpicard
Member
 
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,
Dave
 
Old 07-09-2004, 03:22 PM   #2
Fungmeista
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
jdtiede
Member
 
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.
 
  


Reply


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

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 04:29 AM.

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