Sample restore and backup script SQLite3

Asked By James K Blevins 20 points N/A Posted on - 03/18/2013

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

• Status: Open
• Question Views: 1115
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: ActionScript

Answered By Joseph S Peterson 35 points N/A #130299

Sample restore and backup script SQLite3

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,

About Joseph S Peterson

Questions
19

Answers
101

Best Answers
13

• Vote Up 0 Vote Down

• Posted on - 04/05/2013
• Question Category: ActionScript