On 20 Dec 2013, at 7:32am, José Romero Ortega <[email protected]> wrote:
> I try to make à clean copy of the database with the following command: > > Sqlite3 MYDB.db .dump | sqlite3 MYDB _NEW.db Split that into its two halves: inside the SQLite shell do .dump MYDB.txt then read the .txt file into an editor and look at the commands it issues. You should be able to work out whether they would violate your UNIQUE constraints or not, and whether they do correctly represent the data you want or not. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
