Check the Magento database status

First steps

  1. Log in to the Magento server as, or switch to, a user who has permissions to write to the Magento file system. One way to do this is to switch to the Magento file system owner.

    If you use the bash shell, you can also use the following syntax to switch to the Magento file system owner and enter the command at the same time:

    su <Magento file system owner> -s /bin/bash -c <command>
    

    If the Magento file system owner does not allow logins you can do the following:

    sudo -u <Magento file system owner>  <command>
    
  2. To run Magento commands from any directory, add <your Magento install dir>/bin to your system PATH.

    Because shells have differing syntax, consult a reference like unix.stackexchange.com.

    bash shell example for CentOS:

    export PATH=$PATH:/var/www/html/magento2/bin
    

You can also run the commands in the following ways:

  • cd <your Magento install dir>/bin and run them as ./magento <command name>
  • php <your Magento install dir>/bin/magento <command name>

<your Magento install dir> is a subdirectory of your web server's docroot. Need help locating the docroot? Click here.

In addition to the command arguments discussed here, see Common arguments.

Prerequisites

Before you run this command, you must Create or update the deployment configuration.

Command usage

To check the status of the Magento database, enter

magento setup:db:status

This command has no arguments or options.

Sample output follows:

All modules are up to date.

The command returns one of the following exit codes:

Exit code Description Suggested action
0 Normal None
1 Some modules use code versions newer or older than the database Run magento setup:upgrade to update the database schema and run composer update from the Magento root directory to update component dependencies
2 setup:upgrade is required magento setup:upgrade to update the database schema