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

[Conxita Marín]

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

[Simon Davies]

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

[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 

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

[Simon Slavin]

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

[Igor Tandetnik]

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

[Conxita Marín]

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