[sqlite] version 3.7.3 on linux, commands do not respond

Conxita Marín

unread,

Mar 21, 2012, 8:23:31 AM3/21/12

to sqlite...@sqlite.org

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...@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Igor Tandetnik

unread,

Mar 21, 2012, 8:26:19 AM3/21/12

to sqlite...@sqlite.org

Conxita Marín <cma...@dims.com> 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

Simon Slavin

unread,

Mar 21, 2012, 8:27:08 AM3/21/12

to General Discussion of SQLite Database

On 21 Mar 2012, at 12:23pm, Conxita Marín <cma...@dims.com> 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.

Conxita Marín

unread,

Mar 22, 2012, 3:54:13 AM3/22/12

to General Discussion of SQLite Database, itand...@mvps.org

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<cma...@dims.com> 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 ?

Simon Davies

unread,

Mar 22, 2012, 5:27:57 AM3/22/12

to General Discussion of SQLite Database

2012/3/22 Conxita Marín <cma...@dims.com>:

> 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

Conxita Marín

unread,

Mar 22, 2012, 11:38:36 AM3/22/12

to General Discussion of SQLite Database

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.