Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Last revisionBoth sides next revision |
76:sql_monitor [2021/03/04 15:10] – emr | 76:sql_monitor [2021/03/04 15:10] – emr |
---|
If you see problems with the data stored in Stages or if it is necessary to access the database directly, a SQL monitor capability can be used. | If you see problems with the data stored in Stages or if it is necessary to access the database directly, a SQL monitor capability can be used. |
| |
To access the SQL monitor, log in as ''root'', go to ''Administration'' and __click 6 times__ on the database version number. | To access the SQL monitor, log in as ''root'', go to ''Administration'' and __click 6 times__ on the database version number in the Version Details box. |
| |
{{ https://doc.stagesasaservice.com/lib/plugins/ckgedit/fckeditor/userfiles/image/76/sql_monitor_access.png?direct&400x218 }} | [[https://doc.stagesasaservice.com/lib/exe/fetch.php?tok=d6e6d7&media=https://doc.stagesasaservice.com/lib/plugins/ckgedit/fckeditor/userfiles/image/76/sql_monitor_access.png|{{ https://doc.stagesasaservice.com/lib/plugins/ckgedit/fckeditor/userfiles/image/76/sql_monitor_access.png?direct&400x218 }}]] |
| |
You can enter SQL select, update, insert, or delete statements and execute those. | You can enter SQL select, update, insert, or delete statements and execute those. |
| |
{{ https://doc.stagesasaservice.com/lib/plugins/ckgedit/fckeditor/userfiles/image/76/sql_monitor_results.png?direct&600x281 }} | [[https://doc.stagesasaservice.com/lib/exe/fetch.php?tok=965321&media=https://doc.stagesasaservice.com/lib/plugins/ckgedit/fckeditor/userfiles/image/76/sql_monitor_results.png|{{ https://doc.stagesasaservice.com/lib/plugins/ckgedit/fckeditor/userfiles/image/76/sql_monitor_results.png?direct&600x281 }}]] |
| |
<font inherit/inherit;;#e74c3c;;inherit>**CAVEAT: All modifications go directly into the live database. The database might become incostinent. Please be careful!**</font> | <font inherit/inherit;;#e74c3c;;inherit>**CAVEAT: All modifications go directly into the live database. The database might become incostinent. Please be careful!**</font> |