Database

database:drop

Drop the site's database

Syntax

joomla database:drop [--www WWW] [-L|--mysql-login MYSQL-LOGIN] [-H|--mysql-host MYSQL-HOST] [-P|--mysql-port MYSQL-PORT] [--mysql_db_prefix MYSQL_DB_PREFIX] [-db|--mysql-database MYSQL-DATABASE] [--mysql-driver MYSQL-DRIVER] [--] <site>

Arguments

site: Alphanumeric site name. Also used in the site URL with .test domain

Options

--www=<value>: Web server root
Default: /var/www
--mysql-login=<value> , -L=<value>: MySQL credentials in the form of user:password
Default: root:root
--mysql-host=<value> , -H=<value>: MySQL host
Default: localhost
--mysql-port=<value> , -P=<value>: MySQL port
Default: 3306
--mysql_db_prefix=<value>: MySQL database prefix
Default: sites_
--mysql-database=<value> , -db=<value>: MySQL database name. If set, the --mysql_db_prefix option will be ignored.
--mysql-driver=<value>: MySQL driver
Default: mysqli

database:install

Install the Joomla database

Syntax

joomla database:install [--www WWW] [-L|--mysql-login MYSQL-LOGIN] [-H|--mysql-host MYSQL-HOST] [-P|--mysql-port MYSQL-PORT] [--mysql_db_prefix MYSQL_DB_PREFIX] [-db|--mysql-database MYSQL-DATABASE] [--mysql-driver MYSQL-DRIVER] [--sample-data SAMPLE-DATA] [--sql-dumps SQL-DUMPS] [-d|--drop] [-e|--skip-exists-check] [--] <site>

Arguments

site: Alphanumeric site name. Also used in the site URL with .test domain

Options

--www=<value>: Web server root
Default: /var/www
--mysql-login=<value> , -L=<value>: MySQL credentials in the form of user:password
Default: root:root
--mysql-host=<value> , -H=<value>: MySQL host
Default: localhost
--mysql-port=<value> , -P=<value>: MySQL port
Default: 3306
--mysql_db_prefix=<value>: MySQL database prefix
Default: sites_
--mysql-database=<value> , -db=<value>: MySQL database name. If set, the --mysql_db_prefix option will be ignored.
--mysql-driver=<value>: MySQL driver
Default: mysqli
--sample-data=<value>: Sample data to install (default|blog|brochure|learn|testing). Ignored if custom dump files are given using --sql-dumps.
--sql-dumps=<value>: Full path to SQL dump file to import. If not set, the command will use the default Joomla installation files.
--drop , -d: Drop database if it already exists
--skip-exists-check , -e: Do not check if database already exists or not.

database:export

Export the Joomla database

Syntax

joomla database:export [--www WWW] [-L|--mysql-login MYSQL-LOGIN] [-H|--mysql-host MYSQL-HOST] [-P|--mysql-port MYSQL-PORT] [--mysql_db_prefix MYSQL_DB_PREFIX] [-db|--mysql-database MYSQL-DATABASE] [--mysql-driver MYSQL-DRIVER] [--filename FILENAME] [--folder FOLDER] [--per-table]–<site>

Arguments

site: Alphanumeric site name. Also used in the site URL with .test domain

Options

--www=<value>: Web server root
Default: /var/www
--mysql-login=<value> , -L=<value>: MySQL credentials in the form of user:password
Default: root:root
--mysql-host=<value> , -H=<value>: MySQL host
Default: localhost
--mysql-port=<value> , -P=<value>: MySQL port
Default: 3306
--mysql_db_prefix=<value>: MySQL database prefix
Default: sites_
--mysql-database=<value> , -db=<value>: MySQL database name. If set, the --mysql_db_prefix option will be ignored.
--mysql-driver=<value>: MySQL driver
Default: mysqli
--folder=<value>: Target folder where the backup should be stored. Defaults to site folder
--filename=<value>: If set, each table will be exported into a separate file
--per-table: File name for the backup. Defaults to sitename_date.format