SQL logic error

1. sqlite3 /var/lib/asterisk/astdb.sqlite3
2. (Check for integrity using )----> pragma integrity_check;
3. (Help can be of help too) ----> .help
4. (You can check tables to see what is inside) ----> .tables
5. .mode insert
6. .output mydb_export.sql
7. .dump
8. .exit
9. mv /var/lib/asterisk/astdb.sqlite3 /var/lib/asterisk/astdb.sqlite3.orig
10. sqlite3 /var/lib/asterisk/mydb.db < mydb_export.sql (mydb_export.sql will most likely be in your pwd)
11. sqlite3 /var/lib/asterisk/astdb.sqlite3
12. analyze;
13. .exit

Share this post for your friends:

Friend me: