January 27, 201016 yr Okay I have a client who has an ecom site that won't let him have an additonal database for a blog. What I would like to do is have the wordpress blog on the main site as a subdomain and get hosting for the database. Is that possible. If so how would I do that in Wordpress?
January 27, 201016 yr Why can't your client use the same database? As long as the table names are unique (i.e. wp_<whatever> for the WordPress files, ecom_<whatever> for the ecommerce tables) it shouldn't matter.
January 27, 201016 yr Author His service corecommerce won't let him. So this is a work around. Possible?
January 27, 201016 yr His service corecommerce won't let him. So this is a work around. Possible? hmm? You don't really need a new database, in the wordpress config file just set the table prefix to wp_ or whatever you want. if you wanted to have the wordpress blog on the main site you'd point the nameservers to another webhosting account and then add a CNAME/A record on the DNS to ppoint to the corecommerce install. i.e. shop.hisdomain.com(CNAME) == corecommerce install (on server ) hisdomain.com == wordpress install (on server A)
January 27, 201016 yr Author Okay corecommerce is telling us we need a separate database. So I need a separate database. We can't put another DB on that server. I want to have the WP blog on the main server and have the content be hosted in the db on another server. Could you please give me the step by steps? thanks a million
January 27, 201016 yr Flatpress does not use a database for data storage and the name suggests a wordpress duplicate. I haven't used it myself so I'm only basing this on the name and the default front end theme. The are alternative DBless CMS's but this is the closest to your request of wordpress. You should be able to URL mask the subdomain to a wordpress.COM hosted solution however there customization is a little more limited compared to a self hosted install. Regardless, to relieve all doubts, it IS absolutely possible to use a database hosted elsewhere for the software on a different software. Wordpress doesn't know the database isn't on the same server it just knows the DBs identity and the speed of the responses being high. There may be a lag putting the database on a server in say a Glasgow server and the wordpress install on a Chicago server.
January 28, 201016 yr Author Okay.... This needs to have a database. It needs to be Wordpress. Can not be Wordpress.com What I want to know are the steps to tell the wp-config.php file that the database is remote. How do I do this. Please give me the step-by-step to do this. I don't want alternatives. If this is not possible the way my client wants it I NEED to know this. Thank you.
January 28, 201016 yr The simple answer is no. You could not have wordpress installed on one server, but get the content from a remote database. Your client might have to get extra hosting to provide for the wordpress, thus having another domain name.
January 28, 201016 yr Author Thank you for actually answering my question. That's strange though and ashame. Anyone else have any ideas? -Seth
January 28, 201016 yr You could have a subdomains pointing to two different websites: blog.websitename.com - takes you to blog store.websitename.com - takes you to online store I would also look into an ecommerce solution that's able to be hosted on your own host, and then set the blog and store in separate db's.
January 28, 201016 yr Author Okay so it's not doable. then The reason why I ask is because we will not move the ecommerce anywhere else to another platform. He ranks well and the site is up and running. How can I get the subdomain to point to another website? -Seth
January 28, 201016 yr Use the domain name's control panel. If you have the domain name anywhere with a good control panel you should be able to just setup an A record (under DNS settings) that points a subdomain to a different IP address. We use 123-reg.co.uk and do it all the time.
Create an account or sign in to comment