DE

↑ ↓ select, Enter open, Esc close

Check the Plesk database for inconsistencies

harmless rootPleskdebian, ubuntu
root@server
plesk repair db -n

Runs the database check of plesk repair as a dry run. The -n option only reports inconsistencies instead of fixing them. Useful after aborted migrations or when the panel throws errors when opening certain objects.

Note: Before a real repair without -n, back up the database, for example with plesk db dump psa > psa.sql.

Also searched as

  • plesk database corrupted
  • plesk error when opening a domain
  • check psa database

Related one-liners

All in Plesk

Check the mail configuration in Plesk without changes

#plesk repair mail -n
harmlessPlesk

Check the Plesk installation for errors without changes

#plesk repair all -n
harmlessPlesk

Find the system user of each domain in Plesk

#plesk db "SELECT d.name, s.login FROM domains d JOIN hosting h ON h.dom_id = d.id JOIN sys_users s ON s.id = h.sys_user_id ORDER BY d.name"
harmlessPlesk

Fix file permissions and ownership with plesk repair

#plesk repair fs example.com -y
cautionPlesk

List all databases with their domain in Plesk

#plesk db "SELECT d.name AS domain, db.name AS datenbank, db.type FROM data_bases db JOIN domains d ON d.id = db.dom_id ORDER BY d.name, db.name"
harmlessPlesk

List all email addresses on a Plesk server

#plesk db "SELECT CONCAT(m.mail_name, '@', d.name) AS adresse, m.postbox FROM mail m JOIN domains d ON d.id = m.dom_id ORDER BY d.name, m.mail_name"
harmlessPlesk

Read first, then run.

The commands on myline.de act directly on servers, files and databases. A wrong path or placeholder can delete data irreversibly or make a server unreachable.

  • All commands are provided without warranty and are not tested on every system.
  • Understand what a command does before running it, and check every placeholder.
  • Make a backup first and, if possible, try it on a test system.
  • You run commands at your own risk. Liability for damages is excluded to the extent permitted by law.