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
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,
