Failed website migration to Hostinger

Web hosting discussion, programming, and shared and dedicated servers.
4 posts Page 1 of 1
by royj » Tue Jul 16, 2024 4:22 pm
Here's the email message I sent to Sonic Tech Support, they won't help, sent me to this forum:

I'm in the process of trying to complete a website migration from Sonic to Hostinger.

Using FTP, I pulled a backup of the complete contents of risaaratyr.com, zipped it and passed it to Hostinger.

After redirecting DNS, the main website works, but a link from the website to the blog built with WordPress tools, and hosted at Sonic (I guess as a subdomain? I'm not knowledgeable enough about this stuff to be sure I'm getting all the terms right) that worked under Sonic doesn't work at Hostinger even though they have all the contents of the /blog and /images subfolders.

Their support says the problem is with the wp-config.php file, and here are the contents of that file:

<?php
// ** MySQL settings ** //
define('DB_NAME', 'aratyr_oc_1'); // The name of the database
define('DB_USER', 'aratyr_oc_1'); // Your MySQL username
define('DB_PASSWORD', 'f7c3ec705b0ce629e226d970f819d5c0'); // ...and password
define('DB_HOST', 'b.custsql.sonic.net');
define('DB_CHARSET', 'utf8');
define('DB_COLLATE', '');
define('WP_SITEURL', 'http://risaaratyr.com/blog');

// You can have multiple installations in one database if you give each a unique prefix
$table_prefix = 'wp_'; // Only numbers, letters, and underscores please!

// Change this to localize WordPress. A corresponding MO file for the
// chosen language must be installed to wp-content/languages.
// For example, install de.mo to wp-content/languages and set WPLANG to 'de'
// to enable German language support.
define ('WPLANG', '');

/* That's all, stop editing! Happy blogging. */

define('ABSPATH', dirname(__FILE__).'/');
require_once(ABSPATH.'wp-settings.php');
?>

According to Hostinger support, they need to have a backup of the SQL database for the blog. How do I get a backup of the database referred to in the wp-config.php file?
by joemuller » Tue Jul 16, 2024 4:55 pm
Hi Roy,

I'm sending you a zip file with a backup of your database - the folks at Hostinger should either have a tool or a way for their support staff to make a working copy on their end using the contents of the file. Afterwards, you will probably need to change some of the lines starting with 'define('DB_' in the wp-config.php file so that the Wordpress part of your website knows where the new database is and how to connect. (At a minimum, the DB_HOST value will change to whatever server Hostinger puts your database on.)

-- Joe M
I'm a proud employee of Sonic.net! :-)
by royj » Tue Jul 16, 2024 5:00 pm
Hallelujah! Thanks for the effort and the quick reply. I eagerly await the arrival of the zipped DB backup

Roy J
by royj » Wed Jul 17, 2024 7:39 am
It worked! Thanks
4 posts Page 1 of 1

Who is online

In total there are 0 users online :: 0 registered, 0 hidden and 0 guests (based on users active over the past 5 minutes)
Most users ever online was 999 on Mon May 10, 2021 1:02 am

Users browsing this forum: No registered users and 0 guests