On 15 Sep 2009, at 3:41pm, Jimmy Verner wrote: > Here's what happens: So far as I can tell, my new databases are built > just like the old one, but when I try to import them with SQLite > Database Browser ( see sqlitebrowser.sourceforge.net ) I am told > "Error importing data at line 7345345."
Forget third-party tools. There's no way we can possibly know every bug in every third-party tool. Use the ones included with SQLite. There's a command-line tool on your Mac called 'sqlite3'. It can read databases, it can read SQL commands and use them to build a database. It can turn the database into whatever SQL commands are needed to reproduce it. You can use it to execute SQLite commands line-by-line including ones that check the database for corruption. To get more information use man sqlite3 Copy your database onto your Mac and use sqlite3 on it. Try some SELECT commands. If sqlite3 produces an unexpected error, tell us what it is and we'll look into it. Don't worry: some of us understand iPhone and Mac here and people can help. > because when I open the > database in Text Wrangler, it's there. Wait. A text editor shows your database as a series of SQL commands ? That's not a database file at all, that's a text file with some SQL commands in. A proper SQLite database file shows up as mostly gibberish when viewed with a text editor, except for the bit at the beginning that says what it is. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
