Roger MARTINEZ <[email protected]> wrote: > restore function is not ok for me . > Before I make a backup with > /usr/local/sqlite-3.7.2/bin/sqlite3 spip.sqlite > sqlite>.backup main spip.save > ... > /usr/local/sqlite-3.7.2/bin/sqlite3 spip.save > sqlite>.database > seq name file > --- ------------ > ------------------------------------------------------------------------- > 0 main /home/roger/htdocs/essai/spip/config/bases/spip.save > ... > > sqlite>.restore spip.sqlite spip.save > Error: unknown database spip.sqlite
The first parameter of .restore is not the file name. It's the database name, e.g. "main" or a name you passed to ATTACH DATABASE. You got it right for .backup. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
