J4.x:CLI Database Exporter Importer - Revision history

Ceford: Remove --all it is not used in J4.2.5 and throws an error

2022-11-29T19:01:21Z

Remove --all it is not used in J4.2.5 and throws an error

← Older revision		Revision as of 19:01, 29 November 2022
Line 25:		Line 25:

	* <translate><!--T:7--> List all available commands of the Joomla Console:<br /><tt>php cli/joomla.php list</tt></translate>		* <translate><!--T:7--> List all available commands of the Joomla Console:<br /><tt>php cli/joomla.php list</tt></translate>
	* <translate><!--T:8--> Export the database to the folder:<br /><tt>php cli/joomla.php database:export ~~--all~~ --folder <folder_path></tt></translate>		* <translate><!--T:8--> Export the database to the folder:<br /><tt>php cli/joomla.php database:export --folder <folder_path></tt></translate>
	* <translate><!--T:9--> Import the database from folder:<br /><tt>php cli/joomla.php database:import ~~--all~~ --folder <folder_path></tt></translate>		* <translate><!--T:9--> Import the database from folder:<br /><tt>php cli/joomla.php database:import --folder <folder_path></tt></translate>

	<translate><!--T:10--> You can also:</translate>		<translate><!--T:10--> You can also:</translate>
	<translate><!--T:11-->		<translate><!--T:11-->
	* Export the database as a .zip file:<br /><tt>php cli/joomla.php database:export ~~--all~~ --zip</tt>		* Export the database as a .zip file:<br /><tt>php cli/joomla.php database:export --zip</tt>
	* Export a table:<br /><tt>php cli/joomla.php database:export --table <table_name></tt>		* Export a table:<br /><tt>php cli/joomla.php database:export --table <table_name></tt>
	* Export a table as a .zip file:<br /><tt>php cli/joomla.php database:export --table <table_name> --zip</tt>		* Export a table as a .zip file:<br /><tt>php cli/joomla.php database:export --table <table_name> --zip</tt>

Wilsonge at 23:13, 29 March 2020

2020-03-29T23:13:31Z

← Older revision		Revision as of 23:13, 29 March 2020
Line 7:		Line 7:
	<translate><!--T:2-->		<translate><!--T:2-->
	Before updating Joomla! or [[S:MyLanguage/J4.x:CLI Update\|installing a third party extension]], it is strongly recommended that you back up your site.<br />		Before updating Joomla! or [[S:MyLanguage/J4.x:CLI Update\|installing a third party extension]], it is strongly recommended that you back up your site.<br />
	The Joomla! 4.x Console provides commands for exporting (backing up) and importing (restoring) your Joomla! database.</translate>		The Joomla! 4.x Console provides commands for exporting (backing up) and importing (restoring) your Joomla! database. Note that it doesn't backup your filesystem which should be done separately</translate>

	<translate>		<translate>

	== Requirements == <!--T:3-->		== Requirements == <!--T:3-->
	</translate>		</translate>

Wilsonge: added Category:Joomla CLI using HotCat

2020-03-29T23:12:48Z

added Category:Joomla CLI using HotCat

← Older revision		Revision as of 23:12, 29 March 2020
Line 56:		Line 56:
	[[Category:Platform{{#translation:}}]]		[[Category:Platform{{#translation:}}]]
	[[Category:Tutorials{{#translation:}}]]		[[Category:Tutorials{{#translation:}}]]
			[[Category:Joomla CLI]]
	</noinclude>		</noinclude>

Greggaffney: Grammar error

2019-10-19T01:57:16Z

Grammar error

← Older revision		Revision as of 01:57, 19 October 2019
Line 29:		Line 29:
	<translate><!--T:10--> You can also:</translate>		<translate><!--T:10--> You can also:</translate>
	<translate><!--T:11-->		<translate><!--T:11-->
	* Export the database in a zip file:<br /><tt>php cli/joomla.php database:export --all --zip</tt>		* Export the database as a .zip file:<br /><tt>php cli/joomla.php database:export --all --zip</tt>
	* Export a table:<br /><tt>php cli/joomla.php database:export --table <table_name></tt>		* Export a table:<br /><tt>php cli/joomla.php database:export --table <table_name></tt>
	* Export a table as a .zip file:<br /><tt>php cli/joomla.php database:export --table <table_name> --zip</tt>		* Export a table as a .zip file:<br /><tt>php cli/joomla.php database:export --table <table_name> --zip</tt>

Greggaffney: Grammar error

2019-10-19T01:54:19Z

Grammar error

← Older revision		Revision as of 01:54, 19 October 2019
Line 20:		Line 20:
	</translate>		</translate>
	<translate><!--T:6-->		<translate><!--T:6-->
	Log ~~in to~~ your host and go to the root folder of your site.<br />		Log into your host and go to the root folder of your site.<br />
	I recommend to use the Joomla 'tmp' folder in your <folder_path> to have read/write permissions.</translate>		I recommend to use the Joomla 'tmp' folder in your <folder_path> to have read/write permissions.</translate>

Line 36:		Line 36:

	<translate>		<translate>

	== Back up and restore == <!--T:12-->		== Back up and restore == <!--T:12-->
	</translate>		</translate>

Sandra97: Marked this version for translation

2019-05-27T22:55:35Z

Marked this version for translation

← Older revision		Revision as of 22:55, 27 May 2019
Line 3:		Line 3:
	{{-}}		{{-}}
	<translate>		<translate>
	== About ==		== About == <!--T:1-->
	</translate>		</translate>
	<translate>Before updating Joomla! or [[S:MyLanguage/J4.x:CLI Update\|installing a third party extension]], it is strongly recommended that you back up your site.<br />		<translate><!--T:2-->
			Before updating Joomla! or [[S:MyLanguage/J4.x:CLI Update\|installing a third party extension]], it is strongly recommended that you back up your site.<br />
	The Joomla! 4.x Console provides commands for exporting (backing up) and importing (restoring) your Joomla! database.</translate>		The Joomla! 4.x Console provides commands for exporting (backing up) and importing (restoring) your Joomla! database.</translate>

	<translate>		<translate>
	== Requirements ==		== Requirements == <!--T:3-->
	</translate>		</translate>
	<translate>To use these commands, you need a secured shell access (SSH) to your host on which the PHP CLI (Command Line Interface) is installed.		<translate><!--T:4-->
			To use these commands, you need a secured shell access (SSH) to your host on which the PHP CLI (Command Line Interface) is installed.
	Consider to have basic knowledge of using shell commands.</translate>		Consider to have basic knowledge of using shell commands.</translate>

	<translate>		<translate>
	== Instructions ==		== Instructions == <!--T:5-->
	</translate>		</translate>
	<translate>Log in to your host and go to the root folder of your site.<br />		<translate><!--T:6-->
			Log in to your host and go to the root folder of your site.<br />
	I recommend to use the Joomla 'tmp' folder in your <folder_path> to have read/write permissions.</translate>		I recommend to use the Joomla 'tmp' folder in your <folder_path> to have read/write permissions.</translate>

	* <translate>List all available commands of the Joomla Console:<br /><tt>php cli/joomla.php list</tt></translate>		* <translate><!--T:7--> List all available commands of the Joomla Console:<br /><tt>php cli/joomla.php list</tt></translate>
	* <translate>Export the database to the folder:<br /><tt>php cli/joomla.php database:export --all --folder <folder_path></tt></translate>		* <translate><!--T:8--> Export the database to the folder:<br /><tt>php cli/joomla.php database:export --all --folder <folder_path></tt></translate>
	* <translate>Import the database from folder:<br /><tt>php cli/joomla.php database:import --all --folder <folder_path></tt></translate>		* <translate><!--T:9--> Import the database from folder:<br /><tt>php cli/joomla.php database:import --all --folder <folder_path></tt></translate>

	<translate>You can also:</translate>		<translate><!--T:10--> You can also:</translate>
	<translate>* Export the database in a zip file:<br /><tt>php cli/joomla.php database:export --all --zip</tt>		<translate><!--T:11-->
			* Export the database in a zip file:<br /><tt>php cli/joomla.php database:export --all --zip</tt>
	* Export a table:<br /><tt>php cli/joomla.php database:export --table <table_name></tt>		* Export a table:<br /><tt>php cli/joomla.php database:export --table <table_name></tt>
	* Export a table as a .zip file:<br /><tt>php cli/joomla.php database:export --table <table_name> --zip</tt>		* Export a table as a .zip file:<br /><tt>php cli/joomla.php database:export --table <table_name> --zip</tt>
Line 32:		Line 36:

	<translate>		<translate>
	== Back up and restore ==		== Back up and restore == <!--T:12-->
	</translate>		</translate>
	<translate>To make a full backup (with folders, files and database) of your site, you can execute these commands:</translate>		<translate><!--T:13--> To make a full backup (with folders, files and database) of your site, you can execute these commands:</translate>
	<translate>		<translate>
			<!--T:14-->
	# Archive your Joomla root directory:<br /><tt>tar --exclude='./tmp/joomla_bak.*' -zcvf tmp/joomla_bak.tgz . > tmp/joomla_bak.log</tt>		# Archive your Joomla root directory:<br /><tt>tar --exclude='./tmp/joomla_bak.*' -zcvf tmp/joomla_bak.tgz . > tmp/joomla_bak.log</tt>
	# Export all the Joomla database:<br /><tt>php cli/joomla.php database:export --all --folder tmp/db_bak</tt></translate>		# Export all the Joomla database:<br /><tt>php cli/joomla.php database:export --all --folder tmp/db_bak</tt></translate>

	<translate>And to restore it, execute these commands:</translate>		<translate><!--T:15--> And to restore it, execute these commands:</translate>
	<translate># Import all the Joomla database:<br /><tt>php cli/joomla.php database:import --all --folder tmp/db_bak</tt>		<translate><!--T:16-->
			# Import all the Joomla database:<br /><tt>php cli/joomla.php database:import --all --folder tmp/db_bak</tt>
	# Extract the archive:<br /><tt>tar --recursive-unlink -xvf tmp/joomla_bak.tgz .</tt></translate>		# Extract the archive:<br /><tt>tar --recursive-unlink -xvf tmp/joomla_bak.tgz .</tt></translate>

Sandra97 at 22:55, 27 May 2019

2019-05-27T22:55:23Z

Sandra97: Marked for translation - Markup edits - Categories added

2019-05-27T22:54:45Z

Marked for translation - Markup edits - Categories added

← Older revision		Revision as of 22:54, 27 May 2019
Line 1:		Line 1:
			<noinclude><languages /></noinclude>
			<noinclude>{{Joomla version\|version=4.0}}</noinclude>
			{{-}}
			<translate>
	== About ==		== About ==
	Before updating Joomla! or [[J4.x:CLI Update\|installing a third party extension]], it is strongly recommended that you back up your site.		</translate>
	The Joomla! 4.x Console provides commands for exporting (backing up) and importing (restoring) your Joomla! database.		<translate>Before updating Joomla! or [[S:MyLanguage/J4.x:CLI Update\|installing a third party extension]], it is strongly recommended that you back up your site.<br />
			The Joomla! 4.x Console provides commands for exporting (backing up) and importing (restoring) your Joomla! database.</translate>

			<translate>
	== Requirements ==		== Requirements ==
	To use these commands, you need a secured shell access (SSH) to your host on which the PHP CLI (Command Line Interface) is installed.		</translate>
	Consider to have basic knowledge of using shell commands.		<translate>To use these commands, you need a secured shell access (SSH) to your host on which the PHP CLI (Command Line Interface) is installed.
			Consider to have basic knowledge of using shell commands.</translate>

			<translate>
	== Instructions ==		== Instructions ==
	Log in to your host and go to the root folder of your site.		</translate>
	I recommend to use the Joomla! 'tmp' folder in your <folder_path> to have read/write permissions.		<translate>Log in to your host and go to the root folder of your site.<br />
			I recommend to use the Joomla! 'tmp' folder in your <folder_path> to have read/write permissions.</translate>

	* List all available commands of the Joomla! Console:		* <translate>List all available commands of the Joomla! Console:<br /><tt>php cli/joomla.php list</tt></translate>
	<tt>php cli/joomla.php ~~list~~</tt>		* <translate>Export the database to the folder:<br /><tt>php cli/joomla.php database:export --all --folder <folder_path></tt></translate>
			* <translate>Import the database from folder:<br /><tt>php cli/joomla.php database:import --all --folder <folder_path></tt></translate>

	* Export the database to the folder :		<translate>You can also:</translate>
	<tt>~~php cli/joomla.php database~~:~~export --all --folder <folder_path>~~</tt>		<translate>* Export the database in a zip file:<br /><tt>php cli/joomla.php database:export --all --zip</tt>
			* Export a table:<br /><tt>php cli/joomla.php database:export --table <table_name></tt>
	* Import the database from folder:		* Export a table as a .zip file:<br /><tt>php cli/joomla.php database:export --table <table_name> --zip</tt>
	~~<tt>php cli/joomla.php database:import --all --folder <folder_path>~~<~~/tt~~>		* Import a table:<br /><tt>php cli/joomla.php database:import --table <table_name></tt>
			* If you need help:<br /><tt>php cli/joomla.php database:export --help</tt> <tt>php cli/joomla.php database:import --help</tt></translate>
	~~You can also :~~

	* Export the database in a zip file :
	<tt>php cli/joomla.php database:export --all --zip</tt>

	* Export a table :
	<tt>php cli/joomla.php database:export --table <table_name></tt>

	* Export a table as a .zip file :
	<tt>php cli/joomla.php database:export --table <table_name> --zip</tt>

	* Import a table :
	<tt>php cli/joomla.php database:import --table <table_name></tt>

	* If you need help:
	<tt>php cli/joomla.php database:export --help</tt>

	<tt>php cli/joomla.php database:import --help</tt>

			<translate>
	== Back up and restore ==		== Back up and restore ==
	To make a full backup (with folders, files and database) of your site, you can execute these commands:		</translate>
			<translate>To make a full backup (with folders, files and database) of your site, you can execute these commands:</translate>
	# Archive your joomla root directory:		<translate>
	<tt>tar --exclude='./tmp/joomla_bak.*' -zcvf tmp/joomla_bak.tgz . > tmp/joomla_bak.log</tt>		# Archive your joomla root directory:<br /><tt>tar --exclude='./tmp/joomla_bak.*' -zcvf tmp/joomla_bak.tgz . > tmp/joomla_bak.log</tt>
			# Export all the joomla database:<br /><tt>php cli/joomla.php database:export --all --folder tmp/db_bak</tt></translate>
	# Export all the joomla database:
	<tt>php cli/joomla.php database:export --all --folder tmp/db_bak</tt>


	~~And to restore it, execute these commands:~~

	~~# Import all the joomla database:~~
	~~<tt>php cli/joomla.php database:import --all --folder tmp/db_bak~~</tt>

	# Extract the archive:		<translate>And to restore it, execute these commands:</translate>
	<tt>tar --recursive-unlink -xvf tmp/joomla_bak.tgz .</tt>		<translate># Import all the joomla database:<br /><tt>php cli/joomla.php database:import --all --folder tmp/db_bak</tt>
			# Extract the archive:<br /><tt>tar --recursive-unlink -xvf tmp/joomla_bak.tgz .</tt></translate>

	<noinclude>[[Category:Joomla! 4.x]]</noinclude>		<noinclude>
			[[Category:Joomla! 4.x]]
			[[Category:Joomla! 4.0{{#translation:}}]]
			[[Category:Development{{#translation:}}]]
			[[Category:Platform{{#translation:}}]]
			[[Category:Tutorials{{#translation:}}]]
			</noinclude>

Sandra97: Sandra97 moved page CLI Database Exporter Importer to J4.x:CLI Database Exporter Importer: Using the correct namespace

2019-05-27T21:41:59Z

Sandra97 moved page CLI Database Exporter Importer to J4.x:CLI Database Exporter Importer: Using the correct namespace

← Older revision	Revision as of 21:41, 27 May 2019
(No difference)

Alikon: Created page with "== About == Before updating Joomla! or installing a third party extension, it is strongly recommended that you back up your site. The Joomla! 4.x Console p..."

2019-05-27T06:31:15Z

Created page with "== About == Before updating Joomla! or installing a third party extension, it is strongly recommended that you back up your site. The Joomla! 4.x Console p..."

New page

== About ==
Before updating Joomla! or [[J4.x:CLI Update|installing a third party extension]], it is strongly recommended that you back up your site.
The Joomla! 4.x Console provides commands for exporting (backing up) and importing (restoring) your Joomla! database.

== Requirements ==
To use these commands, you need a secured shell access (SSH) to your host on which the PHP CLI (Command Line Interface) is installed.
Consider to have basic knowledge of using shell commands.

== Instructions ==
Log in to your host and go to the root folder of your site.
I recommend to use the Joomla! 'tmp' folder in your <folder_path> to have read/write permissions.

* List all available commands of the Joomla! Console:
<tt>php cli/joomla.php list</tt>

* Export the database to the folder :
<tt>php cli/joomla.php database:export --all --folder <folder_path></tt>

* Import the database from folder:
<tt>php cli/joomla.php database:import --all --folder <folder_path></tt>

You can also :

* Export the database in a zip file :
<tt>php cli/joomla.php database:export --all --zip</tt>

* Export a table :
<tt>php cli/joomla.php database:export --table <table_name></tt>

* Export a table as a .zip file :
<tt>php cli/joomla.php database:export --table <table_name> --zip</tt>

* Import a table :
<tt>php cli/joomla.php database:import --table <table_name></tt>

* If you need help:
<tt>php cli/joomla.php database:export --help</tt>

<tt>php cli/joomla.php database:import --help</tt>

== Back up and restore ==
To make a full backup (with folders, files and database) of your site, you can execute these commands:

# Archive your joomla root directory:
<tt>tar --exclude='./tmp/joomla_bak.*' -zcvf tmp/joomla_bak.tgz . > tmp/joomla_bak.log</tt>

# Export all the joomla database:
<tt>php cli/joomla.php database:export --all --folder tmp/db_bak</tt>

And to restore it, execute these commands:

# Import all the joomla database:
<tt>php cli/joomla.php database:import --all --folder tmp/db_bak</tt>

# Extract the archive:
<tt>tar --recursive-unlink -xvf tmp/joomla_bak.tgz .</tt>

<noinclude>[[Category:Joomla! 4.x]]</noinclude>

← Older revision		Revision as of 22:55, 27 May 2019
Line 18:		Line 18:
	</translate>		</translate>
	<translate>Log in to your host and go to the root folder of your site.<br />		<translate>Log in to your host and go to the root folder of your site.<br />
	I recommend to use the Joomla! 'tmp' folder in your <folder_path> to have read/write permissions.</translate>		I recommend to use the Joomla 'tmp' folder in your <folder_path> to have read/write permissions.</translate>

	* <translate>List all available commands of the Joomla! Console:<br /><tt>php cli/joomla.php list</tt></translate>		* <translate>List all available commands of the Joomla Console:<br /><tt>php cli/joomla.php list</tt></translate>
	* <translate>Export the database to the folder:<br /><tt>php cli/joomla.php database:export --all --folder <folder_path></tt></translate>		* <translate>Export the database to the folder:<br /><tt>php cli/joomla.php database:export --all --folder <folder_path></tt></translate>
	* <translate>Import the database from folder:<br /><tt>php cli/joomla.php database:import --all --folder <folder_path></tt></translate>		* <translate>Import the database from folder:<br /><tt>php cli/joomla.php database:import --all --folder <folder_path></tt></translate>
Line 36:		Line 36:
	<translate>To make a full backup (with folders, files and database) of your site, you can execute these commands:</translate>		<translate>To make a full backup (with folders, files and database) of your site, you can execute these commands:</translate>
	<translate>		<translate>
	# Archive your ~~joomla~~ root directory:<br /><tt>tar --exclude='./tmp/joomla_bak.*' -zcvf tmp/joomla_bak.tgz . > tmp/joomla_bak.log</tt>		# Archive your Joomla root directory:<br /><tt>tar --exclude='./tmp/joomla_bak.*' -zcvf tmp/joomla_bak.tgz . > tmp/joomla_bak.log</tt>
	# Export all the ~~joomla~~ database:<br /><tt>php cli/joomla.php database:export --all --folder tmp/db_bak</tt></translate>		# Export all the Joomla database:<br /><tt>php cli/joomla.php database:export --all --folder tmp/db_bak</tt></translate>

	<translate>And to restore it, execute these commands:</translate>		<translate>And to restore it, execute these commands:</translate>
	<translate># Import all the ~~joomla~~ database:<br /><tt>php cli/joomla.php database:import --all --folder tmp/db_bak</tt>		<translate># Import all the Joomla database:<br /><tt>php cli/joomla.php database:import --all --folder tmp/db_bak</tt>
	# Extract the archive:<br /><tt>tar --recursive-unlink -xvf tmp/joomla_bak.tgz .</tt></translate>		# Extract the archive:<br /><tt>tar --recursive-unlink -xvf tmp/joomla_bak.tgz .</tt></translate>