After migrating wordpress to a new domain, URL redirects to previous domain. Can't access backend or phpmyadmin - Openlitespeed droplet

Question

Usually if I was stuck, I would make the change by changing wp_options table in phpmyadmin. But I cannot access it because phpmyadmin was on the domain.

Can someone show what could be done to get to the new domain through SSH, hopefully or some other way?
Also, for Openlitespeed droplet, any idea how to access file manager other than SSH?

Thanks in advance.

KFSys · Answer

HI @notslow , It seems you’ll indeed need to change the settings from your database. For your first question , I have two suggestions. Install phpMyAdmin. There is a really good article on how to do it here at DigitalOcean - https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-18-04 Change your options directly via your mysql shell. To do so, you can ssh to your server ssh root@IpOfYourDroplet mysql use databasename; select * from wp_options; Once you are sure, you are in the right database, you can perform your update query and change your website’s address UPDATE `table_name` SET `column_name` = `new_value' [WHERE condition]; Regarding your second question , if you wish to have a GUI, you’ll need to install some kind of a web panel on your droplet otherwise, you’ll need to use SSH. Regards,KDSys

eleu · Answer

Hi @notslow , You should still able to have the access to the IP with phpmyadmin url. Then change both siteurl and home values from table wp_options . If you want to update it from SSH console:Login to the mysql and use the database, e.g. wordpress update siteurl value by: UPDATE `wp_options` SET `option_value` = 'http://example.com' WHERE `wp_options`.`option_id` = 1; update home value by UPDATE `wp_options` SET `option_value` = 'http://example.com' WHERE `wp_options`.`option_id` = 2; Be sure to substitute the your domain for http://example.com Best,Eric

alexdo · Answer

Hello there, If you’ve already updated the Home and Site URLs from the WordPress admin panel then you can take the next step and update all the references for the old domain name in the database to match the new domain. **Note:**Please before you proceed take a snapshot of the droplet and also create a backup of the site (both files and database). This will ensure that if something goes wrong you can easily restore your site or droplet if needed There are a few ways to update the references in your database and it’s totally up to you which one you’ll choose. You can either change them manually if they’re not many or use an automation tool like a plugin or an external app. One of the external apps that I’ve used and I know for sure that it’s working okay is: https://interconnectit.com/products/search-and-replace-for-wordpress- You need to upload the script in your public_html folder and access it in your browser, then you’ll need to fill in your database details and enter the old name (IP address or domain) and the domain name you want to use. Then you can first use the dry-run option and if there are references that need to be updated you can then run the script and update them. Also, an alternative way is to use a plugin called “Duplicator” it will update all of the paths and references from the dev domain to the main domain. This is why we usually recommend using a plugin called: Duplicator. The plugin will generate a backup for your website’s files and database. Then when you import the files to the new domain, all of the references for the old domain name will be updated properly with the correct ones. Another option is to use the All-in-One WP Migration plugin. The plugin will do the replacement for you during import. You do not need to use any additional database search and replace https://wordpress.org/plugins/all-in-one-wp-migration/ Once this is done you can check the site for any errors as there might be some hardcoded references for the domain name in the files like paths to directories, files and etc. Hope this helps!

Become a contributor for community

DigitalOcean Documentation

Resources for startups and AI-native businesses

The developer cloud

Start building today

Report this

After migrating wordpress to a new domain, URL redirects to previous domain. Can't access backend or phpmyadmin - Openlitespeed droplet

Related questions

Mysql Data disappears intermittently

Droplet: Docker => laravel (mysql) + astro app [unusable]

docker laravel app with astro frontend

Can I create a managed MySQL cluster running a recent version?

how to connect digital ocean app platform app with cpanel mysql database?

What’s the best way to handle downtime during software deployments?

Where to Find Slow Query Logs in Managed Database (Already Enabled)?

Search index command in pimcore 10.5.15 production gives error.

Query taking 1 minute to run

Fullstack Architecture Deployments Recomendations

Mysql CPU alerts and max_execution_time

I can't install MySQL on the server

Report this

After migrating wordpress to a new domain, URL redirects to previous domain. Can't access backend or phpmyadmin - Openlitespeed droplet

Related questions

Mysql Data disappears intermittently

Droplet: Docker => laravel (mysql) + astro app [unusable]

docker laravel app with astro frontend

Can I create a managed MySQL cluster running a recent version?

how to connect digital ocean app platform app with cpanel mysql database?

What’s the best way to handle downtime during software deployments?

Where to Find Slow Query Logs in Managed Database (Already Enabled)?

Search index command in pimcore 10.5.15 production gives error.

Query taking 1 minute to run

Fullstack Architecture Deployments Recomendations

Mysql CPU alerts and max_execution_time

I can't install MySQL on the server