Sample restore and backup script SQLite3

Asked By 20 points N/A Posted on -
qa-featured

Dear Techyv Experts,

Please do the needful for providing a sample restore and backup script SQLite3 using a sample database for me to understand the coding. If you have any online tutorial having the mentioned details, that will also help. Please do the needful for helping me.

Thanks in Advance,

James K Blevins

SHARE
Answered By 30 points N/A #130299

Sample restore and backup script SQLite3

qa-featured

Hi,

You will have to create a directory say for example sqlite. Then you will have to give permissions using chmod to that directory and the new file that you created using the .db extension.After this create a table with all the necessary attributes.Open up the directory that you created before using cd command.Then verify that data was successfully enter by using the following command " sqlite3 example.db 'select * from tablename' ", you should be able to see the attributes entered or there is an error in creating your table.

I have a couple of tutorials for you, that could be useful for backing up and restoring the database using SQlite3.

1) http://www.ibiblio.org/elemental/howto/sqlite-backup.html

Hope this helps you.

Regards,

Login/Register to Answer

Related Questions