MySQL Forums
Forum List  »  Newbie

Re: How to migrate WordPress site using Mysql
Posted by: jon gore
Date: March 06, 2023 11:30PM

To migrate a WordPress site using MySQL, you can follow these steps:

1- Backup the original site: Before migrating, you should backup the original site's files and database.

2- Export the database: To export the MySQL database, you can use the phpMyAdmin tool or any other MySQL client tool. In phpMyAdmin, select the database you want to export, click on the "Export" tab, select the export method as "Quick" and format as "SQL", then click on the "Go" button to download the database SQL file.

3- Create a new database: Create a new MySQL database on the new server or hosting account where you want to migrate your site. You can use cPanel, Plesk, or any other hosting control panel to create a new database.

4- Import the database: Use phpMyAdmin or any other MySQL client tool to import the SQL file into the new database you just created. In phpMyAdmin, select the new database, click on the "Import" tab, select the SQL file you just exported, and click on the "Go" button to import the database.

5- Edit the wp-config.php file: Edit the wp-config.php file located in the root directory of your WordPress installation. Update the database connection details to match the new database credentials you just created.

6- Upload files: Transfer all the WordPress files to the new server or hosting account using FTP or any other file transfer method.

7- Test the new site: Test your new WordPress site by visiting its URL in your web browser.

Options: ReplyQuote


Subject
Written By
Posted
Re: How to migrate WordPress site using Mysql
March 06, 2023 11:30PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.