jamisonb

Hello Catezee,

What is the domain that you are working on, or having the issue with so we can check the DNS. If it is bringing you the ssquarespace’s websites, it sounds like your A Record is going to Squarespace instead of your new cPanel host.

So the way DNS works, to make it simple, is your Domain should have 2 or more Nameservers, those name servers have DNS zones which will control traffic for the domain (This includes e-mail, the MX record). If you are using squarespace’s nameservers for example, the DNS records there probably point your domain to them. If you have a new host provided now, and they have a cPanel, then they probably have Nameservers for you to use and you can use the cpanels DNS zone manager after you change your nameservers to theirs.

I can give you more information if you need it but the first step is probably just checking the DNS so we know what is going on. If you please provide the domain, I will do that with you.

Or go here https://toolbox.googleapps.com/apps/dig/#NS/
and type your domain and see what you get back.

If it is nameservers that need to be changed then that will be done with NetRegistry, the domain registrar. You get the nameservers from the cPanel server provider, they should be like ns1.hostingcompany.com ns2.hostingcompany.com usually. Then you go to NetRegistry account and it should have a place for custom nameservers so you can change them.

best of luck,

Jamison

No Problem! I hope it works, I can’t think of a reason it wouldn’t, but there is a lot I don’t know. I have never done what you are trying to do, but I have done most the steps separately (connected a remote DB in one instance, change tables in another, just never to the same instance).
So I am still hoping someone with more experience answers this questions cause I also want to know now.
I tried to test on my end, but I only have a few resources (1 remote server, I turned my desktop into a LAMP stack to try and replicate with my remote server, but my remote AWS server was a package install for convenience, and it doesn’t allow remote DB connections even after I changed my.cnf bind address to 0.0.0.0, so something is blocking me, but since it was pre-configured I am not sure what yet, but the problem I am having is an environment error, nothing that is being blocked by WordPress software, so I am still hopeful this is a working solution for you.)

If you run into an issue, let me know and I will try to troubleshoot it with you.

Hey ltd2009,

That’s a great question, hopefully, someone comes up with a better idea, cause I only found what you found as far as

define(CUSTOM_USER_TABLE,’wp_users’);
define(CUSTOM_USER_META_TABLE,’wp_usermeta’);

and I don’t believe you can make those remote by themselves, you could always make site B connect remotely to the same database as site A under a different prefix (SiteA would connect to db as localhost, SiteB would connect to the host of site A, same user and password, different prefix) , and then I think you could use those defines so they use the same table for users and usermeta tables.

Inside SiteB wpconfig, things that would need to be changed:
define( ‘DB_NAME’, ‘siteA’s Db’ );

/** MySQL database username */
define( ‘DB_USER’, ‘SiteA’s User for DB’ );

/** MySQL database password */
define( ‘DB_PASSWORD’, ‘SiteA’s Password for DB’ );

/** MySQL hostname */
define( ‘DB_HOST’, ‘SiteA’s hostname’ );

define( ‘CUSTOM_USER_TABLE’, ‘SiteA’s table for users’ );
define( ‘CUSTOM_USER_META_TABLE’, ‘SiteA’s table for usermeta’ );

$table_prefix = ‘anything that is not what SiteA is using’;

Although that sounds like it might slow Site B down since it has to communicate with Site A hosting for the database.

this site goes over the basic idea of everything except how to connect to a remote DB for siteB, but everything else would stay the same.
https://trickspanda.com/wordpress-share-users-login/
But I think that would work,
I am not sure, I might try to do a test and see later, hopefully, someone has another solution.

• This reply was modified 8 years, 6 months ago by jamisonb.
• This reply was modified 8 years, 6 months ago by jamisonb.