CMS backup and restoring - Historial de revisió

Enric: /* Adjusting config files of the new CMS */

2014-05-07T15:48:22Z

Adjusting config files of the new CMS

Enric: /* Adjusting config files of the new CMS */

2011-04-04T15:19:12Z

Adjusting config files of the new CMS

Enric a 07:42, 4 abr 2011

2011-04-04T07:42:01Z

Enric: /* More */

2011-03-26T20:31:26Z

Enric: /* Importing in the new system */

2011-03-26T19:44:20Z

Importing in the new system

Enric: /* Adjusting config files of the new CMS */

2011-03-26T19:41:04Z

Adjusting config files of the new CMS

Enric: /* Importing in the new system */

2011-03-26T19:37:50Z

Importing in the new system

Enric: Es crea la pàgina amb «To backup and restore a CMS we have to follow the following procedure: # Export database and filesystem of the original CMS. # Import files and database in the new system…».

2011-03-26T19:36:51Z

Es crea la pàgina amb «To backup and restore a CMS we have to follow the following procedure: # Export database and filesystem of the original CMS. # Import files and database in the new system…».

Pàgina nova

To backup and restore a CMS we have to follow the following procedure:
# Export database and filesystem of the original CMS.
# Import files and database in the new system.
# Adjust the config files of the CMS to make it work.

=== Export your original CMS ===
# Backup files in the source CMS (with tar, zip, etc.).
#: Our suggestion is to use the command: <pre>$ tar cvfz cmsfoldername.tar.gz cmsfoldername</pre> (obviously changing ''cmsfoldername'' for your CMS folder name).
# Export database with mysqldump (in a *.sql file). We can use:
#* Command mysqldump. With:<pre>$ mysqldump -u enric -p cmsdbname > cmsdb.sql</pre>We will create the file cmsdb.sql with all CMS DB data. Obsioulsy you have to change "enric" for your user name.
#* phpmyadmin: too easy to give explanations for that.
That should result in having 2 files, (1) *.tar.gz and (2) *.sql.

=== Importing in the new system ===
We need 2 files: the tarball and the sql for database.
# Copy the files (*.sql and *.tar.gz) to your target system.
# Extract files in the target system.
#: Using tar the command is:<pre>$ tar xvfz cmsfoldername.tar.gz</pre>
# Create the database in the target system.
#* Using ''mysqladmin'' command:<pre>$ mysqladmin -u enric -p create enric_newdb</pre>(Obviously changing ''enric'' for your username).
#* Using ''mysql'' command:<pre>$ mysql -u enric -p</pre>
#: <pre>mysql> create database enric_newdb;</pre>
#* Using phpmyadmin
# Import the old database in the new database.
#* Using ''mysql'' command:<pre>$ mysql -u enric -p enric_newdb < cmsdb.sql</pre>
#* Using phpmyadmin

=== Adjusting config files of the new CMS ===
...

== More ==
To know more you can read that articles for database creation, export and import:
* [[SQL exportacio]]: DB export.
* [[SQL creacio]]: creation and import of databases.

@@ Línia 47: / Línia 47: @@
 In '''Wordpress''' you also have to change the SITE DIRECTORY that is not in the wp-config.php file but in the DATABASE. If you don't change it, the images will not appear and some functionalities may not work.
 * Go to PHPMYADMIN and select the WP database
 * Go to the table WP_OPTIONS

@@ Línia 37: / Línia 37: @@
 * Mediawiki: LocalSettings.php
 * Joomla!: configuration.php
 You have to review this settings to make the CMS work again:
@@ Línia 43: / Línia 44: @@
 * DB password
 * root folder of the installation
 == More ==

← Versió més antiga		Revisió del 20:31, 26 març 2011
Línia 46:		Línia 46:
	* [[SQL exportacio]]: DB export.		* [[SQL exportacio]]: DB export.
	* [[SQL creacio]]: creation and import of databases.		* [[SQL creacio]]: creation and import of databases.
		+
		+	You can use several commands to synchronize your data in a remote server with your local filesystem:
		+	* '''''rsync''''' is the most common used, but you need SSH access to your site.
		+	* Some hostings just provide FTP service, so you can read [http://serverfault.com/questions/24622/how-to-use-rsync-over-ftp this article for other ways to syncronize over FTP]. Particularly you can use this ones:
		+	** mirror
		+	** wget: can work over FTP as well as HTTP
		+	** sitecopy
		+	** lftp (seems more complex needing a script)

@@ Línia 5: / Línia 5: @@
-=== Export your original CMS ===
+== Backup (export) existing CMS ==
 # Backup files in the source CMS (with tar, zip, etc.).
-#: Our suggestion is to use the command: <pre>$ tar cvfz cmsfoldername.tar.gz cmsfoldername</pre> (obviously changing ''cmsfoldername'' for your CMS folder name).
+#: Our suggestion is to use the command: <pre>$ tar cvfz cmsfoldername.tar.gz <cms_folder_name></pre> (obviously changing ''<cms_folder_name>'' for your CMS folder name).
 # Export database with mysqldump (in a *.sql file). We can use:
-#* Command mysqldump. With:<pre>$ mysqldump -u enric -p cmsdbname > cmsdb.sql</pre>We will create the file cmsdb.sql with all CMS DB data. Obsioulsy you have to change "enric" for your user name.
+#* Command mysqldump. With:<pre>$ mysqldump -u <username> -p cmsdbname > cmsdb.sql</pre>We will create the file cmsdb.sql with all CMS DB data. Obsioulsy you have to change ''<username>'' for your user name.
 #* phpmyadmin: too easy to give explanations for that.
 That should result in having 2 files, (1) *.tar.gz and (2) *.sql.
-=== Importing in the new system ===
+== Restore (import) the backuped CMS ==
 We need 2 files: the tarball and the sql for database.
 # Copy the files (*.sql and *.tar.gz) to your target system.
@@ Línia 20: / Línia 22: @@
 #* Using the tar command is (you need SSH access to your system)<pre>$ tar xvfz cmsfoldername.tar.gz</pre>
 #* If your system doesn't have SSH you can uncompress the files in your local machine and upload it using FTP.
-# Change the folder name if you need it.<pre>$ mv cmsfoldername newfoldername</pre>
+# Change the folder name if you need it.<pre>$ mv <cmsfoldername> <newfoldername></pre>
 # Create the database in the target system.
-#* Using ''mysqladmin'' command:<pre>$ mysqladmin -u enric -p create enric_newdb</pre>(Obviously changing ''enric'' for your username).
+#* Using ''mysqladmin'' command:<pre>$ mysqladmin -u <username> -p create <username>_newdb</pre>(Obviously changing ''<username>'' for your user name and ''newdb'' for something related to your CMS as "wp1" or "wiki2").
-#* Using ''mysql'' command:<pre>$ mysql -u enric -p</pre>
+#* Using ''mysql'' command:<pre>$ mysql -u <username> -p</pre>
-#: <pre>mysql> create database enric_newdb;</pre>
+#: <pre>mysql> create database <username>_newdb;</pre>
 #* Using phpmyadmin
 # Import the SQL file in the new database.
-#* Using ''mysql'' command:<pre>$ mysql -u enric -p enric_newdb < cmsdb.sql</pre>
+#* Using ''mysql'' command:<pre>$ mysql -u <username> -p <username>_newdb < cmsdb.sql</pre>
 #* Using phpmyadmin

@@ Línia 29: / Línia 29: @@
 === Adjusting config files of the new CMS ===
-...
+Each CMS needs to change different things. You have to look for the config file, depending on your CMS, for example:
 == More ==