inquiring about how I can access the php database of the Atom system

[محمود محمد‎]

Dears

I installed Atom on my computer perfectly, but I want to inspect the database itself to get a closer look at the system fields. I am inquiring about how I can access the php database of the Atom system. Thank you.

[Dan Gillean]

Hi there, 

We have instructions on how to access the MySQL command prompt (including where to find the access credentials in case you don't remember them from installation), as well as a number of example SQL queries that can be useful in test and development environments (or for advanced troubleshooting), here: 

• https://www.accesstomemory.org/docs/latest/admin-manual/maintenance/common-atom-queries/#accessing-the-mysql-command-prompt
  

We do not recommend accessing MySQL directly on a public-facing production installation unless absolutely necessary. Additionally, even if you are using a test installation, I strongly encourage you to make a database backup FIRST before proceeding if keeping your AtoM data is important to you. See: 

• https://www.accesstomemory.org/docs/latest/admin-manual/maintenance/common-atom-queries/#backing-up-the-database
  

We also have Entity Relationship Diagrams of AtoM's database schema on our wiki. Here is the latest, rendered as a searchable PDF: 

• https://wiki.accesstomemory.org/Development/ERDs#July_2023
  

Finally, I have also recently shared a brief overview of some of the entities you will find in our schema and how it is organized, in this user forum thread: 

• https://groups.google.com/g/ica-atom-users/c/ACZH5mTOd2E/m/57EnlvRaCgAJ
  

Cheers, 

Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
604-527-2056

@accesstomemory

he / him

‪On Tue, Sep 5, 2023 at 4:13 PM ‫محمود محمد‬‎ <mahmoud...@gmail.com> wrote:‬

Dears

I installed Atom on my computer perfectly, but I want to inspect the database itself to get a closer look at the system fields. I am inquiring about how I can access the php database of the Atom system. Thank you.

--
You received this message because you are subscribed to the Google Groups "AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/CAB5aXs%3D-U54GG1Pz-fZnfiquA98gPjSZ_vZHDy-S-Xu3tZ97qQ%40mail.gmail.com.

[محمود محمد‎]

Thank you very much ... Thanks a  lot

To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/CAC1FhZ%2BhJ2pu4rqvz9-xU6VYYRgRB3WA%3Dvz3LLpKB6i%2BNk91FA%40mail.gmail.com.