PSA otherwise known as Plesk Server Administrator database is the heart and lungs of Plesk. It will be a lot easier to understand a person if we know them by their heart. Same here, if we know about psa, it’s contents and it’s defaults, then we can easily understand plesk and troubleshoot it’s issues.
It is a mysql database which contains all the information regarding plesk and it’s contents like accounts, clients, databases, database servers, mail servers, mail accounts, passwords etc. This a list of commonly used tables and its structures in Plesk.
So, let’s take a look at the tables of psa.
There are 210 tables in the psa database, explaining then will take months to describe all the contents of it. We will check the most important and commonly used tables only.
Remember the golden thumb rule – Backup. Backup your PSA. Once gone, its gone for ever. A single faulty command can cost your entire server. So, beware when you play with one.
- psa.accounts
- psa.actions
- psa.anon_ftp
- psa.BackupsSetting
- psa.BackupsScheduled
- psa.badmailfrom
- psa.Cards
- psa.certificates
- psa.cl_param
- psa.clients
- psa.ClientsTraffic
- psa.cp_access
- psa.data_bases
- psa.DatabaseServers
- psa.db_users
- psa.disk_usage
- psa.dns_recs
- psa.dns_recs_t
- psa.dns_zone
- psa.dom_level_usrs
- psa.dom_param
- psa.domainaliases
- psa.domains
- psa.forwarding
- psa.hosting
- psa.IP_Addresses
- psa.Limits
- psa.log_actions
- psa.log_components
- psa.log_rotation
- psa.mail
- psa.mail_aliases
- psa.mail_redir
- psa.mail_resp
- psa.MailLists
- psa.misc
- psa.mn_param
- psa.Parameters
- psa.pd_users
- psa.Permissions
- psa.protected_dirs
- psa.Repository
- psa.sessions
- psa.sys_users
- psa.Templates
The post Plesk Database Documentation appeared first on Sysally.
This post first appeared on Make IT Work - A Complete Solutions For IT Professionals, please read the originial post: here
