Migrate WordPress Multisite from localhost to public hosting (Error establishing
-
I’m a little desperate because I’ve been trying to find the problem I have for several days and there is no way. I am new to WordPress but I have already developed several sites in PHP / Laravel.
But I have created a WordPress Multisite website in local and when I try to publish it to my IONOS hosting, after doing everything that needs to be done, I get the error “Error establishing a database connection”, it does not say anything else. In the browser console I see also a very generic error (Failed to load resource: the server responded with a status of 500 ())
The way to publish was as follows:
1. Create site generated by the same hosting IONOS with all the Multisite configuration done automatically by this site, adding the lines indicated in wp-config.php:
define( 'WP_ALLOW_MULTISITE', true ); define( 'MULTISITE', true ); define( 'SUBDOMAIN_INSTALL', false ); define( 'DOMAIN_CURRENT_SITE', 'xxxx' ); define( 'PATH_CURRENT_SITE', '/' ); define( 'SITE_ID_CURRENT_SITE', 1 ); define( 'BLOG_ID_CURRENT_SITE', 1 );and in .htaccess:
RewriteEngine On RewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization}] RewriteBase / RewriteRule ^index\.php$ - [L] # add a trailing slash to /wp-admin RewriteRule ^([_0-9a-zA-Z-]+/)?wp-admin$ $1wp-admin/ [R=301,L] RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^ - [L] RewriteRule ^([_0-9a-zA-Z-]+/)?(wp-(content|admin|includes).*) $2 [L] RewriteRule ^([_0-9a-zA-Z-]+/)?(.*.php)$ $2 [L] RewriteRule . index.php [L]2.Delete the wp-content folder to upload the (wp-content) that I already have in local of the finished site.
3. Edit wp-config changing the domain from ‘localhost’ to the domain of my hosting.
4.Edit the .htaccess changing the “RewriteBase /” from local to hosting. 5.In the database created by the hosting delete all the tables and import the database of the local site replacing the local domain by the new one in all the tables, starting with the wp-options tables and going through the posts, etc. tables. I have checked the PHP versions and they are 7.4 for my hosting and local, the WordPress version is also the same 5.8. The local DB version is MariaDB 10.4 and the hosting one is MySQL 5.7. (It will be because of the version of BD????)I have checked everything a thousand times and I do not understand what can be happening, the database access credentials in the wp-config are correct, in fact I did the test with a script checking the DB connection in case the DB host does not work but the connection was made correctly.
-
in fact I put the following script in the wp-config file, with the corresponding connection parameters, and the response is that the connection has been established correctly
<?php $host_name = 'xxxx'; $database = 'xxxx'; $user_name = 'xxxxx'; $password = 'xxxxx'; $link = new mysqli($host_name, $user_name, $password, $database); if ($link->connect_error) { die('<p>Error al conectar con servidor MySQL: '. $link->connect_error .'</p>'); } else { <strong>echo '<p>Se ha establecido la conexión al servidor MySQL con éxito.</p>';</strong> } ?>
- The topic ‘Migrate WordPress Multisite from localhost to public hosting (Error establishing’ is closed to new replies.