This guide explains how to export a database from your current host and import it into your new Hostek account. This process ensures that all your website's content, such as posts, pages, and settings, is moved accurately during a migration.
Before you begin
You will need:
Access to your current hosting control panel (e.g., cPanel, Plesk, or a custom dashboard).
Access to your Hostek account.
The database name, username, and password for your new database on Hostek.
A tool to manage the database, such as phpMyAdmin or a command-line interface.
Export the database from your current host
Log in to your current hosting control panel.
Locate and open the database management tool, typically phpMyAdmin.
Select the database associated with your website from the list on the left.
Click the Export tab at the top of the page.
Select Custom (or "Rapid" if you do not need to customize settings) as the export method.
Ensure the format is set to SQL.
Click Go or Export. The browser will download a
.sqlfile to your computer.
Import the database to your Hostek account
Log in to your Hostek account and open your management panel.
Open the database management tool (e.g., phpMyAdmin).
Select the new database you created for your migration from the left-hand sidebar.
Click the Import tab at the top of the page.
Click Choose File (or Browse) and select the
.sqlfile you downloaded from your previous host.Leave the other settings as default.
Click Go or Import.
Confirm the result
The import process should complete without any "Error" messages appearing in the phpMyAdmin interface.
You can verify the import by checking that the number of tables in the new database matches the number of tables in your original database.
Your website should now be able to connect to the new database using the credentials provided by Hostek.
If the database file is too large to import
If your database exceeds the maximum upload limit of your web browser or the phpMyAdmin tool, you can use a command-line tool to import the file.
Connect to your Hostek server via SSH.
Use the following command to import the database:
mysql -u [username] -p [database_name] < /path/to/your/file.sql
Replace
[username],[database_name], and/path/to/your/file.sqlwith your actual details.
Limitations
This procedure only moves the data within the database. It does not move your website's files (images, themes, or plugins).
This process does not update your application's configuration files. You must still update your website's configuration (e.g.,
wp-config.phpfor WordPress) with the new database credentials after the import is complete.Ensure you are importing the file into the correct database. Importing a database into the wrong database can overwrite existing data.
