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 03-17-2005, 05:25 PM   #1
blizunt7
Member
 
Registered: Mar 2004
Distribution: Fedora Core 1,2,3, RHEL3,4,5 Ubuntu
Posts: 272

Rep: Reputation: 30
SQLITE + problems saving tables


hey all, i am a newbie to SQL, and decided to start with SQLITE3. I am learning commands and manipulating data in a table. HOwever every time i .quit sqlite and open again, any new table i have just made is not saved?? DO i understand that sqlite should execute the transaction commands by itself (begin, commit).

i downloaded sqlite-3.1.6.tar.gz, unziped, configure, make && makeinstall
with no problems

WHen i run i can enter data into a table but does not save.

i have tried to open sqlite3 like so:
$ ./sqlite3 testdb

but when i try to create a table i get the error:
Unable to open database "testdb": unable to open database file

$ ./sqlite // this works, but again .tables shows nothing after .quit

ANy ideas???
thanks all
josh
 
Old 03-21-2005, 08:05 AM   #2
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,406

Rep: Reputation: 1965Reputation: 1965Reputation: 1965Reputation: 1965Reputation: 1965Reputation: 1965Reputation: 1965Reputation: 1965Reputation: 1965Reputation: 1965Reputation: 1965
i'd assume that you've not got permissions to save it. you're calling sqlite with a relative path.. are you working in /usr/local/bin directly or something? is there some reason sqllite isn't working on just a path statement?
 
  


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
Gnome - problems saving settings nalmeth Debian 0 08-25-2005 04:57 PM
IP Tables, POP and Proxy Problems bytebrowser Linux - Security 4 09-12-2004 11:33 PM
problems with SQLITE DBMS leochen Linux - Software 0 05-20-2004 08:51 PM
Problems saving to proc folder Dawyea Linux - Newbie 2 05-19-2004 09:24 PM
IP TABLES Firewall Script problems... Nosram Linux - Networking 2 02-11-2004 04:22 AM


All times are GMT -5. The time now is 11:46 AM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration