View source for Using the CLI

=== Database === <!--T:36-->
Export or Import the database. You can export or import all tables or a selected table. Do not use this feature to import all tables of a multi-lingual site. There is a problem that could stop Smart Search working completely.

<!--T:37-->
<syntaxhighlight lang="bash">
php joomla.php database:export --help
php joomla.php database:export --table f4rc2_banners --folder /home/username/tmp/mydb (one table)
php joomla.php database:export --folder /home/username/tmp/mydb (all tables)

<!--T:38-->
php joomla.php database:import --help
php joomla.php database:import --table /home/username/tmp/mydb/f4rc2_banners (one table)
[ERROR] The /home/username/tmp/mydb/f4rc2_banners.xml file does not exist.
php joomla.php database:import --folder /home/username/tmp/mydb (all tables in this folder)
</syntaxhighlight>