thank you for answer Igor At once , i didn't knew if i could use restore function with sqlite corrupt database file .It seems that if i use corrupt file or empty file, restore function failed . With database file and table dropped it's ok Regards Roger
________________________________ De : Igor Tandetnik <itandet...@mvps.org> À : sqlite-users@sqlite.org Envoyé le : Jeu 14 octobre 2010, 2h 28min 18s Objet : Re: [sqlite] restore function Roger MARTINEZ <roger.martine...@yahoo.fr> 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 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