show content from another sites's database

[crazynp]

Hi,

I am building three websites. The first site has a mysql database with necessary contents for two other sites. The two websites should show the content stored in the first site's database, is it possible without using xml? or is xml the best way or is there any other way to do it?

Regards!
Binod

[Rhyan]

Hi, I am building three websites. The first site has a mysql database with necessary contents for two other sites. The two websites should show the content stored in the first site's database, is it possible without using xml? or is xml the best way or is there any other way to do it? Regards! Binod

Are the 3 websites hosted on the same server?

If the 3 websites are not stored on the same server, then the server where the mysql database is should allow connections from the internet, not only localhost requests.

If the sites are hosted on a public webserver, I doubt that the server would allow access from the internet, as it is potentially unsafe.

Still, if you can perform grants, you can configure a read-only access to the database for a user, explicitly allowing access from the IP of the website that needs to acces the database. It seems confusing, so I will explain like this:

1. website 1 holds the database.
2. website 2 needs access to the database of website 1 from ip 1.2.3.4 .

Create a user named e.g. web2 with pass web2 in the database server.
Grant to user web2 SELECT on DATABASE.* from host with ip 1.2.3.4.

open port in firewall at website1 server for access to the database server normally on port 3306 for mysql.

it should work this way.

If you need any info check resources available on mysql.com or check the hosting server help and faq manuals and sections on how to allow access, grant permissions, etc.

[chrisranjana]

Would the first site's database get updated frequently.
If not you can achieve good performance if you run a cron script to transfer content from the first site's database to your other server periodically.

[crazynp]

Are the 3 websites hosted on the same server? If the 3 websites are not stored on the same server, then the server where the mysql database is should allow connections from the internet, not only localhost requests. If the sites are hosted on a public webserver, I doubt that the server would allow access from the internet, as it is potentially unsafe. Still, if you can perform grants, you can configure a read-only access to the database for a user, explicitly allowing access from the IP of the website that needs to acces the database. It seems confusing, so I will explain like this: 1. website 1 holds the database. 2. website 2 needs access to the database of website 1 from ip 1.2.3.4 . Create a user named e.g. web2 with pass web2 in the database server. Grant to user web2 SELECT on DATABASE.* from host with ip 1.2.3.4. open port in firewall at website1 server for access to the database server normally on port 3306 for mysql. it should work this way. If you need any info check resources available on mysql.com or check the hosting server help and faq manuals and sections on how to allow access, grant permissions, etc.

Thanks Rhyan,

Again a little question

Can I do this if I have got only access to the cpanel of the website or do I need access to the WHM or where Can I configure that and if I can do that with cpanel how to do that?

[Rhyan]

Well, it is not 1 but three questions :) .

Ok, now, I do not know how many and what opitons do you have on your control panel. But, if you are familiar with MySQL, you maybe will be able to do it on your own, if you answer the following questions:

1. Are you allowed to create database schemas on your server?
2. Are you able to create new tables on your server?
3. Are you allowed to create mysql database users, or you have been given a limit of only 1 user per database?
4. Are you able to grant permissions on your database and tables on your server? Especially check if you can grant permissions to mysql users to access from other locations than localhost!
5. Check if you can connect to your mysql database server from your home computer using the root password you have been supplied by the hosting provider.
E.g. your website name is www.myweb.com
run mysql console and type

mysql -h www.myweb.com:3306 -u root -p

You will be prompted for a password, and if everything is ok, you will receive a message like," welcome, blabla for help type /h for exit type /q"

If this test passes, then you will be able to access your mysql DB from the remote website.

If not, then we may be able to figure it out another way maybe.

Goodluck

[crazynp]

Thanks Rhyan!
I can create users but how to connect the database from another site other than local host? Can you give me a small example like query

Thanks in advance

[Rhyan]

As I have told you earlier, all your code should be the same as it is for website 1(where the database is), however, on website 2 instead of localhost in your mysql_connect statement you should insert website 1.

[php]
// from website 2 make the following
$connect = mysql_connect('website1.com:3306', 'website2_user', 'website2_password');

[/php]

The rest is the same...

If you have any difficulties, read the php and mysql dox more thoroughly.

[crazynp]

Thanks Rhyan.

[DarrenC]

I don't know if you have thought of this, and whilst it's not directly answering your question you might be interested.

If you have 3 websites on the same IP range, make sure you don't link to the 3 sites, as the search engines could penalise you for this.

[crazynp]

I don't know if you have thought of this, and whilst it's not directly answering your question you might be interested. If you have 3 websites on the same IP range, make sure you don't link to the 3 sites, as the search engines could penalise you for this.

The IP address are of different range. Is creating RSS feed is better than this?

[Rhyan]

The IP address are of different range. Is creating RSS feed is better than this?

Depends on what you want to do. RSS are good for blogs, news, forums where users get notified with rss, instead of e-mail, and so on.

If you want to make some sort of a on-line shop, or something similar, RSS is not a good option in my opinion.

[crazynp]

I simply want to extract the article from the databse with optional image to the other site. What will be the better choice?

[crazynp]

I simply want to extract the article from the database with optional image to the other site. What will be the better choice?

[Rhyan]

If it's an article, like news, the RSS is better, but a bit more complex. Still more secure.

It is up to you now!