Transfer a WordPress Installation from One.com to WebGo

Important Links

In this article we follow following description

https://www.ionos.de/digitalguide/hosting/blogs/wordpress-migration-tipps-fuer-den-serverumzug

WordPress Site Transfer Information

Site to be migrated [ One.com ] : fcw-intern.de

	Domain	Hoster	PHP Version	Root
Site to be migrated	fcw-intern.de	One.com		fcw-intern.de/httpd.www
New Site	fcw-intern-new.com	Webgo	8.3

New Site [ WebGo ] : fcw-intern-new.com

Run an inital Install of WordPress on your Webgo Site

Click on the One-Click Installer and select WordPress Software

Change the PHP Version

Your newly created Wortporess Page should be available at : https://fcw-intern-new.com

Switch bacck to Wego Admin page and Verify PHP version and SSH settings

Select the newest PHP Verssion available [ in our case it ist PHP 8,3]

Login to the One.com Control Panel and Export Database

Select the correct database an export database and export database

Remember the WordPress prefix : in our case its wp. We need this Info to prepare our wp_config.php later in this process
Press Exportieren to start the process

A new SQL File should be created in the download section for your local browser

Connect via FileZilla to your One.Com Site am download the WordPress Files

Create a new Database on your WebGo Site

Dont forget to allow External Access to our newly created database

Check database Status

Login via phpadmin

Note the new db user is web191_2 and the database name is web

Run some SQL Queries via phpadmin

select version();
10.11.4-MariaDB-1:10.11.4+maria~deb11-log

select database();
web191_db2

Modify

Modify SQL Exportfile

Comment out the create database command as db is already create with WebGo phpadmin tool
Modify use statemnet to pick up the correct database
Change the wp_options table to set up correct site-url / home entry

-- CREATE DATABASE IF NOT EXISTS `fcw_intern_de` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
USE `web191_db2`;
..
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES
(1, 'siteurl', 'https://fcw-intern-new.com', 'yes'),
(2, 'home', 'https://fcw-intern-new.com', 'yes'),
(3, 'blogname', 'FCW Intern', 'yes'),
..

Import ONE.COM database

Validate wp_option table

Change user-name / password for the admin account via phpadmin

After Import we still have the Admin Account Credentials from the One.Com side.

You use the following query to modify the login credentials

UPDATE `wp_users` SET `user_login` = 'fcw', `user_pass` = MD5('your-new-password') WHERE `wp_users`.`ID` = 1;

SELECT * FROM `wp_users`;
1	fcw	8..... 	admin	Helmut.Hutzler@gmail.com

For Details read

https://www.wpbeginner.com/beginners-guide/how-to-reset-a-wordpress-password-from-phpmyadmin/

Validate Migration

Check PHP Version

Goto : Wekzeuge -> Website-Zustand -> Bericht -> Server