When installing a site with Duplicator, you need to create a database or connect to an existing one. Below are several options to set up the database:

Creating a new database:

Option 1: Using Your Host’s Control Panel

• Log in to your host’s control panel and navigate to the section for database management.
• Create a new database and note down the database name.
• Create a new database user or assign an existing user to the new database. Ensure this user has full permissions for the database, and note down the username and password.
• Open the installer.php file generated by Duplicator and use these credentials to test the connection to the new database. If successful, proceed with the installation.

Option 2: Using Duplicator’s Database Creation Tool

• On Step 1 of the installer, select the option for Create New Database from the Database Action dropdown.
• Enter the name of the new database you want to create.
• Provide the name of an existing database user with the necessary permissions.

Option 3: Duplicator Pro with cPanel Integration

• Go to the installer page and navigate to Duplicator Pro » Advanced » cPanel.
• The cPanel integration will use the cPanel API to create a new database and user.
• Select the database and user from the dropdown boxes that appear.

Note: Most hosting providers do not support creating a new database through this option due to server restrictions.

Connecting to an existing database:

Option 4: Overwrite Mode

• Overwrite Mode is used when you place the installer.php and archive file (.zip or .daf) into a directory where WordPress already exists.
• This mode allows you to overwrite the existing site’s database and files with the database and files of the backup.
• During the installation, you’ll see the existing database and user details. Confirm these details and click Apply to use the existing database settings.

Note: By default, this option overwrites the existing website files and database with the content from the backup.

Here’s a refined and clearer version of your sentence:

However, during the backup installation process, you can choose to skip overwriting specific database tables. To do this, enable Advanced Mode in Step 1 of the installer, then go to Step 2 → Tables tab, and uncheck the tables you want to exclude from being overwritten.

Option 5: Import Backup Mode

• Switch the installation mode to Import Backup Mode. This mode uses the database settings from the currently installed WordPress site on which the import is taking place.

Video Resources

Follow Along Step-By-Step (starting @ 14:30 of 24:57)
How to Set Up Database in cPanel

Choose the option that best fits your needs and hosting environment.