Backup & Restore Guide

This guide shows how to create a full backup of your BDExchanger installation — including both website files and the MySQL database.

📁 Part 1: Backup Website Files using cPanel File Manager

1. Login to your cPanel
   Use yourdomain.com/cpanel and log in with your credentials.

2. Open File Manager
   From the cPanel dashboard, go to File Manager.

3. Locate the Website Folder
   Go to public_html/ or wherever your BDExchanger files are installed.

4. Select All Files
   Press Ctrl + A (or manually select all files and folders related to BDExchanger).
   

5. Compress the Files

   • Click “Compress” in the top menu.
     

   • Choose ZIP Archive.
     

   • Name it something like bdexchanger_backup.zip.

   • Click Compress Files.

6. Download the ZIP Backup

   • After compression is complete, right-click on the .zip file.

   • Select Download to save it to your local computer.

🗄️ Part 2: Backup the MySQL Database using phpMyAdmin

1. Open phpMyAdmin from cPanel
   From the cPanel dashboard, click phpMyAdmin under the Databases section.
   

2. Select Your Database
   In the left sidebar, click on the database used by your BDExchanger installation.

3. Export the Database

   • Click the Export tab at the top.
     

   • Choose Quick export method.

   • Format should be SQL.
     

   • Click Go — the .sql file will download to your computer.

✅ Done!

You now have a complete backup of your website files and database. You can restore them anytime to recover your system in case of any issues.

♻️ Restore Guide: Files & Database

This guide explains how to restore your full BDExchanger system using a previously created backup (ZIP file for files and SQL file for the database).

📁 Part 1: Restore Website Files via cPanel File Manager

1. Login to cPanel
   Go to yourdomain.com/cpanel and log in.

2. Open File Manager
   Go to File Manager.

3. Navigate to Website Directory
   Usually under public_html/ or your subdomain directory.

4. Delete Old Files (Optional but Recommended)

   • Select all existing BDExchanger files.

   • Click Delete (make sure you have a backup first).

5. Upload Backup ZIP File

   • Click Upload (top menu).

   • Upload your backup file, e.g., bdexchanger_backup.zip.

6. Extract ZIP File

   • After upload completes, right-click the ZIP file.

   • Click Extract.

   • Confirm extraction path (usually public_html/).

7. Verify File Structure
   Ensure your extracted files are in the correct location (e.g., not inside a subfolder like /bdexchanger_backup/).

🗄️ Part 2: Restore MySQL Database via phpMyAdmin

1. Login to phpMyAdmin
   From cPanel, open phpMyAdmin.

2. Create a New Database (Optional)

   • Go to MySQL Databases in cPanel.

   • Create a new database and user.

   • Add user to database with ALL PRIVILEGES.

3. Select the Database in phpMyAdmin
   Click on the newly created (or existing) database from the left sidebar.

4. Import SQL File

   • Click Import tab.

   • Choose your .sql file from the backup.

   • Click Go to start the import.

5. Wait for Completion
   You’ll see a success message once import is complete.

⚙️ Final Step: Configure config.php 

If you restored to a new database, update your configuration file:

• Go to your website root via File Manager.

• Edit includes/config.php or wherever DB credentials are stored.

• Update:

   

  $db_host = 'localhost';

  $db_user = 'your_db_user';


  $db_pass = 'your_db_password';

  $db_name = 'your_db_name';


✅ Your BDExchanger is Now Restored!

You should now be able to visit your website and use the admin panel as before.

🔄 How to Update Site URL After Changing Domain

You can do this directly from phpMyAdmin or using MySQL query. The column you’re updating is:

• Table: bdex_settings

• Column: url

🧩 Option 1: Update via phpMyAdmin

1. Log in to cPanel and open phpMyAdmin.

2. Click on your database name from the left panel.

3. Find and click on the table bdex_settings.

4. Click Edit (✏️) on the row that contains the column url.

5. In the url field, replace the old domain:

    

   https://oldsite.com


   with your new domain:

    

   https://newsite.com


6. Click Go to save.

💻 Option 2: Use SQL Query (phpMyAdmin → SQL Tab)

Go to the SQL tab and run this:

⚠️ Make sure you adjust the id = 1 part if your settings are stored in a different row.

📌 Final Step: Clear Cache & Test

• Clear your browser cache

• Try logging into the Admin Panel

• Make sure links and redirects are working