Database Issue (out of my depth)

Try repairing the database using PHPMYADMIN after validating that those tables do, in fact, exist.

https://www.a2hosting.com/kb/cpanel/cpanel-database-features/optimizing-and-repairing-mysql-databases-with-phpmyadmin

Okay – I will give that a shot. Thanks.

The tables do not exist.

Should I re-export the database and start from scratch?

Yes, but if you still have the old DB online somewhere, check it with PHPMYADMIN (on that host) to verify the tables are there and in good shape before you export.

Okay will do.

I checked the original database tables. There were a lot more tables than WordPress gave errors for.

So, I did a quick SQL export. Opened the file in a text editor. Was looking to change the username and password but could not find that section.

DO NOT edit the .sql files. You’ll almost certainly break things.

This article lists 7 completely different ways to reset your password. Any one of them will work and do the job. Find the one that’s right for you and use that: https://www.ads-software.com/support/article/resetting-your-password/

I’m not at the point of logging in yet.

The url still gives me “Error establishing a database connection” message.

I re-imported the database without any luck.

They only SQL changes I made was find and replace. It was replacing the old url with the new url.

How would I change the url if I don’t edit it directly in the SQL file?

I would have liked to use a plugin to do the work. But from what I read, one can’t use a plugin to transfer a subdomain to a domain. Plus im going from one server to another.

Sorry if I don’t explain the situation that well.

Thanks for your help.

-Dan

>> They only SQL changes I made was find and replace. It was replacing the old url with the new url. <<

Yeah, that broke it.

Use the database WITHOUT CHANGE. Add the new URL to wp-config.php as here: https://www.ads-software.com/support/article/editing-wp-config-php/#wp_siteurl

Then, install the plugin “better search replace”. Search for the old URL and replace with the new one.

Great! Thanks for the push in the right direction.

-Dan