Re: [sqlite] version 3.7.3 on linux, commands do not respond
Glubs! Are yout right. At some point I misspelled the name of the database by invoking sqlite and even if you do nothing it writes an empty file. Thank you and excuse me for that so silly question. Conxita. El 22/03/2012 10:27, Simon Davies escribió: 2012/3/22 Conxita Marín: It has to be something more complexof course, I tried the same database in Debian Lenny + Sqlite3 3.5.9 and it works perfectly: conxita@my_other_linux# sqlite3 backup_bd SQLite version 3.5.9 Enter ".help" for instructions sqlite> .tables android_metadata dbversion prefs Compare from your original post and above: conxita@mylinux$: sqlite3 backup.bd SQLite version 3.7.3 conxita@my_other_linux# sqlite3 backup_bd SQLite version 3.5.9 We can't tell if they are really the same underlying data, but the names are different. Do you change the db name when moving between machines? Any other ideas? Conxita Regards, Simon ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] version 3.7.3 on linux, commands do not respond
2012/3/22 Conxita Marín : > It has to be something more complexof course, I tried the same database in > Debian Lenny + Sqlite3 3.5.9 and it works perfectly: > > conxita@my_other_linux# sqlite3 backup_bd > SQLite version 3.5.9 > Enter ".help" for instructions > sqlite> .tables > android_metadata dbversion prefs Compare from your original post and above: conxita@mylinux$: sqlite3 backup.bd SQLite version 3.7.3 conxita@my_other_linux# sqlite3 backup_bd SQLite version 3.5.9 We can't tell if they are really the same underlying data, but the names are different. Do you change the db name when moving between machines? > > Any other ideas? > > Conxita > Regards, Simon ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] version 3.7.3 on linux, commands do not respond
It has to be something more complexof course, I tried the same database in Debian Lenny + Sqlite3 3.5.9 and it works perfectly: conxita@my_other_linux# sqlite3 backup_bd SQLite version 3.5.9 Enter ".help" for instructions sqlite> .tables android_metadata dbversion prefs Any other ideas? Conxita El 21/03/2012 13:26, Igor Tandetnik escribió: Conxita Marín wrote: I'm in my new Linux box, Linux Debian Squeeze, I installed the version 3.7.3.of sqlite3, that comes in the repositories that I use. Any command respond, no error, nothing conxita@mylinux$: sqlite3 backup.bd SQLite version 3.7.3 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .tables sqlite> This just means the database in backup.bd doesn't contain any tables. Did you perhaps mean backup.db ? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] version 3.7.3 on linux, commands do not respond
On 21 Mar 2012, at 12:23pm, Conxita Marín wrote: > Any command respond, no error, nothing > > conxita@mylinux$: sqlite3 backup.bd > SQLite version 3.7.3 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> .tables > sqlite> If you have made a new database with that command, then it will have no tables in, so the '.tables' command will produce no output. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] version 3.7.3 on linux, commands do not respond
Conxita Marín wrote: > I'm in my new Linux box, Linux Debian Squeeze, I installed the version > 3.7.3.of sqlite3, that comes in the repositories that I use. > > Any command respond, no error, nothing > > conxita@mylinux$: sqlite3 backup.bd > SQLite version 3.7.3 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> .tables > sqlite> This just means the database in backup.bd doesn't contain any tables. Did you perhaps mean backup.db ? -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] version 3.7.3 on linux, commands do not respond
Hi all, I'm in my new Linux box, Linux Debian Squeeze, I installed the version 3.7.3.of sqlite3, that comes in the repositories that I use. Any command respond, no error, nothing conxita@mylinux$: sqlite3 backup.bd SQLite version 3.7.3 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .tables sqlite> Any idea? Conxita ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users