Hi all, i just have one problem here, how to manage multiple website using one database, i mean using same database. Please tell me from starting because i'm blind in database. Please pm me.
Same way you attached your database with your first website, just create new users for the database and use with the other sites. I usually do that for demo Joomla installations. Hope that helps.
Hi, It's only possible from "Remote Database Connection" You can find it on you control panel "Remote MySql" In every of yours website, you will have to use Remote Database Address using Main Database Hosting IP. If you have your personal hosting server then you can manage it easily, If not. Then it will difficult. Because most of the hosting services not allow Remote Database Connection. If all your websites hosted in same hosting server, Then it's possible. For more help, google: "Remote MySQL Database Connection" or "Remote Database Connection" Check these links: http://www.ferdychristant.com/blog//archive/DOMM-6GRGQ7 http://developer.mindtouch.com/en/kb/Enabling_remote_access_to_MySQL_database http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
I was doing like you said, but all of my website going like my 1st website. All templates, username follow the 1st website. I dont want like this, I just want to share database, not template and username.
I was add domain to host,, but nothing happen. If i not mistake, remote sql for external web servers right? My website located at same host.
I was doing what like you said, but all my website follow the 1st site. All templates, username and etc come from 1st site. I just want content like post, thumbnail from 1st site.
I want to share just one table from my database. Example, mysite have a 20 database tables, so i want all of my sites to share only table_1 database for all website. It is possible?
Use table prefix... in systems like wordpress, joomla, drupal you can define a prefix for your tables so you can have something like: tables: site1_news site1_users site2_news site2_users site3_news site3_users sharedtable
You can do the same if you have customs sites, also if you have many databases (one per site) and the sharedtable into another database. You can do something like SELECT * FROM databasename.sharedtable So you can use something like this in your querys... Excuse my english i hope you understand...
i vote for this solution.. i believe your site is using wordpress ? if yes.. this is the solution.. and when u install the table to database.. please make sure the table prefix .. default for wordpres is wp_
just connect to the database like you did in your first site with all of them, use the same lines of coding.