Community discussions

MikroTik App
 
abdrzj1989
just joined
Topic Author
Posts: 3
Joined: Thu Sep 29, 2016 3:35 pm

Repair Database Usermanager

Sat Oct 08, 2016 12:27 am

1- Download sqlite3.exe from http://www.sqlite.org/2013/sqlite-shell ... 080100.zip
2- Copy sqlite3.exe from downloaded ZIP file to C:\SQLRepair
3- open cmd (Command prompt) and go to C:\SQLRepair
4- type following in command prompt (or copy-paste these commands into cmd ):
sqlite3 sqldb
pragma integrity_check;
5- If you see an error message then:
exit sqlite3.exe with CTRL+C
type following in command prompt (or copy-paste these commands into cmd) : A and B
A- echo .dump | sqlite3.exe sqldb > ff1.sql
B- sqlite3.exe -init ff1.sql sqldb-new
echo .dump | sqlite3.exe sqldb > ff1.sql
sqlite3.exe -init ff1.sql sqldb-new
" sqldb-new " This is a new database file for usermanager

https://youtu.be/Z5DQa-zxj18


Best Regards
ِAbdulkader Alrazj

Who is online

Users browsing this forum: mwm1x and 28 guests