Joomla Backup Restore

Miscellaneous Joomla Backup Restore

Joomla Backup Restore

Joomla backup and restore

In order to restore a Joomla CMS website there needs to be a backup of the websites home folder.

A – Making a backup of MySQL

1. Using phpMyAdmin

There are 2 ways of making a backup.

This backs up the SQL database into an .sql file.

2. To make a backup using the terminal

Unix/Linux

mysqldump -u kullanıcı_adı -p VT_Ad > dump_dosya_ADI.sql.gz mysqldump -u wikiuser -p wikidb &gt; Wikidb.sql

1	mysqldump -u kullanıcı_adı -p VT_Ad > dump_dosya_ADI.sql.gz mysqldump -u wikiuser -p wikidb > Wikidb.sql

Şifre eklenebilir (Boylece backup dan once sormasi engellenir)

mysqldump -u wikiuser -pwikiuser wikidb > Wikidb.sql      (şifre : wikiuser)

1	mysqldump -u wikiuser -pwikiuser wikidb > Wikidb.sql (şifre : wikiuser)

mysqldump.exe -u kullanıcı_adı -p veritabanı_Adı > dump_dosya_ADI.sql

1	mysqldump.exe -u kullanıcı_adı -p veritabanı_Adı > dump_dosya_ADI.sql

Select wikidb from the left and follow the steps shown in the screenshots. First make a new database and user, then restore the backup database.

2. With a terminal

Create the database

CREATE DATABASE wikidb DEFAULT CHARACTER SET utf8 COLLATE utf8_turkish_ci;

1	CREATE DATABASE wikidb DEFAULT CHARACTER SET utf8 COLLATE utf8_turkish_ci;

Create a user

CREATE USER 'wikiuser'@'localhost' IDENTIFIED BY 'wikiuser'; GRANT ALL PRIVILEGES ON * . * TO 'wikiuser'@'localhost' IDENTIFIED BY 'wikiuser' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

1	CREATE USER 'wikiuser'@'localhost' IDENTIFIED BY 'wikiuser'; GRANT ALL PRIVILEGES ON * . * TO 'wikiuser'@'localhost' IDENTIFIED BY 'wikiuser' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

Granting Privileges to the user

GRANT ALL PRIVILEGES ON `wikidb` . * TO 'wikiuser'@'localhost';

1	GRANT ALL PRIVILEGES ON `wikidb` . * TO 'wikiuser'@'localhost';

Restoring from the backup

mysql -u wikiuser -p wikidb > /yedek/alinan/path/Wikidb.sql

1	mysql -u wikiuser -p wikidb > /yedek/alinan/path/Wikidb.sql

B – Restoring from the Joomla home folder

This can be easily be done by copying from the operating system’s root/home folder to /var/www/html.

Note:

It would be necessary to edit configuration.php if there are differences in the database name, username and paths.
Problems uploading large files can be solved by editing the max_upload_size value in php.ini.
It is necessary to reorganise /var/www/html/logs and /var/www/html/tmp.

Written By

sysdba.org