Are You Ready to Move Your WordPress Site from Localhost to cPanel?
Moving a WordPress site from localhost to cPanel could be intimidating, especially if you are new to web development. However, we are here to guide you step-by-step and provide you with all the information you need to move your WordPress site effortlessly.
Step One: Export the Database from localhost
To export your database, you need to launch phpMyAdmin from the XAMPP control panel, select the database and click on the “Export” tab. Under “Export Method”, select “Quick”, and then choose “SQL” as the format, and finally check “Save as file” before hitting the “Go” button. This will save your database as an SQL file, which you can import into cPanel later.
Step Two: Export the WordPress Files
To export the WordPress files, zip the entire WordPress folder and download it to your computer. On a Mac, right-click on the WordPress folder and select “Compress”.
Step Three: Create a New Database and User in cPanel
Before you import your WordPress database, create a new database and user in cPanel. To do this, go to the “MySQL Databases” section on your cPanel account, and under “Create a New Database”, enter a name for your database, and under “Create a New User”, enter a username and password. Remember to write down the database and user information for later use.
Step Four: Import the Database into cPanel
Once you’ve created a new database and user, import your exported database by navigating back to phpMyAdmin, selecting your database, clicking on the “Import” tab and importing the SQL file you exported earlier. Click “Go” at the bottom of the page, and wait for the import to complete.
Step Five: Modify the wp-config.php File
Your wp-config.php file contains all the information WordPress needs to connect to your new database. Open the file in a text editor, and replace the values inside the single quotes with your new database and user information. Save the changes and close the file.
Step Six: Upload WordPress Files to cPanel
After modifying the wp-config.php file, upload the WordPress files to your cPanel account by opening the file manager and uploading the zip file you created. Once uploaded, select the file and click on the “Extract” button in the top toolbar to unzip the WordPress files into a new directory.
Step Seven: Update DNS and Test the Site
Finally, update your DNS to point to your new server and test your site by navigating to your domain in a web browser. If done correctly, your WordPress site should be live on the internet.
In summary, even if you’re new to web development, moving your WordPress site from localhost to cPanel could be done effortlessly by following these steps: export your database and WordPress files, create a new database and user in cPanel, modify your wp-config.php file, upload the WordPress files to cPanel, and update your DNS. You’ve got this!