Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revisionLast revisionBoth sides next revision |
| 76:sql_monitor [2021/03/04 14:52] – created 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. |
| |
| aaa | [[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. |
| | |
| | [[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> |
| | |
| | In doubt, please contact the [[stages-support@methodpark.com?subject=Stages SQL Monitor|Stages customer care team]]. |
| |
| |