There are two parts to backing up a WordPress site using 123-reg, backing up the files and then exporting the database.
Step 1: Backup Files
In order to backup the files, you will need to download the files using FTP.
Firstly download FileZilla. This tool will allow you to download the files from 123-reg to your personal PC.
Download it here: https://filezilla-project.org
Connect to your site via FTP
First make a note of your FTP credentials which can be found in the cpanel for your website:
Then open FileZilla and click the connect button in the top left of the application.
In the window that opens, enter the FTP data that you retrieved in the earlier step and click connect.
Copying the files
Now that you are connected to your website via ftp, you can download the files to your PC.
Local site on the left where you want to save the files.
Then on the right in the
Remote site section right click on the root directory and then click download.
All the website files will begin to download.
You will see the files downloading in the bottom left of the window where it says Queued Files and Successful Transfers.
Once this process completes and all of the files have successfully downloaded then all your website files are backed up.
Step 2: Export Database
Login to the database
Go to the cpanel for the website you want to backup and then select the
MariaDB Databases option under Web Tools.
Then go to the Manage MySQL Databases option. Enter the password for the database and then click manage.
NOTE: The password for the database can be found in your website files in the wp-config.php file in the public_html folder.
The config file will look similar to below and here you can find the database password.
/** The name of the database for WordPress */ define( 'DB_NAME', 'database_name_here' ); /** MySQL database username */ define( 'DB_USER', 'username_here' ); /** MySQL database password */ define( 'DB_PASSWORD', 'password_here' ); /** MySQL hostname */ define( 'DB_HOST', 'hostname_here' );
Once you have the password, enter it into the manage MySQL Databases section and then click Manage.
The phpMyAdmin console will load.
Export the database
Select the database you want to export from the left hand panel, then click the export tab near the centre of the screen.
Select the Quick export method.
Select the SQL format.
Then press Go.
The database will be exported/downloaded in your browser:
Store the export .sql database file somewhere safe if you need it for future backup.
The backup is complete.