Welcome Guest ( Log In | Register )



2 Pages V  < 1 2  
Reply to this topicStart new topic
> Can I Remotely Access Astahost MySQL DBs?, Remote Ascess???
sparkx
post Feb 18 2007, 01:54 AM
Post #11


Sparkx
Group Icon

Group: [HOSTED]
Posts: 366
Joined: 11-October 06
From: Dana Point, CA, USA
Member No.: 16,496
myCENTs:44.66



I was woundering the same question. You want to access an sql database from a differant site. I know its possible because many people use multiple servers for one sql. I would like the source code for that also please. Is there a way to make 2 dbs with same tables but differant entries to applear on a site (lets say one db gets full so you make another one to store other usersers on but you want them both to be accessed when someone does something like searching members). Im not sure if thats possible or if anyone knows what I am talking about.
Thanks,
Sparkx
Go to the top of the page
 
+Quote Post
faulty.lee
post Feb 18 2007, 05:39 AM
Post #12


Super Member
Group Icon

Group: [HOSTED]
Posts: 500
Joined: 5-November 06
Member No.: 17,016
myCENTs:NEGATIVE[-20.12]



QUOTE(sparkx @ Feb 18 2007, 09:54 AM) *
I was woundering the same question. You want to access an sql database from a differant site. I know its possible because many people use multiple servers for one sql. I would like the source code for that also please. Is there a way to make 2 dbs with same tables but differant entries to applear on a site (lets say one db gets full so you make another one to store other usersers on but you want them both to be accessed when someone does something like searching members). Im not sure if thats possible or if anyone knows what I am talking about.
Thanks,
Sparkx


You can try the federated database, it serve as a link to another databased located else where. But this require MySQL 5.0, most common hosting server only has MySQL 4.

http://dev.mysql.com/tech-resources/articl...ed-storage.html

Go to the top of the page
 
+Quote Post

2 Pages V  < 1 2
Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. MySQL - Trouble With Bulk Insert Statements(3)
  2. MySQL Realtime Replication(4)
  3. Recover Tables From A MySQL .frm File(8)
  4. Mirror My MySQL Database To Another Mysql Server(4)
  5. How To Connect MySQL With Flash?(8)
  6. MySQL Output Database Question(18)
  7. MySQL, Multiple Tables(24)
  8. Read/Write Issues After Copying An Access .mdb File(3)
  9. Navcat For MySQL(9)
  10. Mysql And Php(15)
  11. Login System Using A Mysql Db(5)
  12. Access(17)
  13. Access 97 To Access 2003(15)
  14. Mysql - So Hard(14)
  15. Sun Bought Mysql(6)
  1. Integrate Access Database Onto Intranet Site(5)
  2. Mysql Backup With Another Address?(4)
  3. I Have An Error With My Mysql Connection(7)
  4. Accessing Ms Access Database From A Centralized Location?(5)
  5. Mysql And User File_priv(0)
  6. Mysql Database Management(1)
  7. Mysql Database Entry By Excel Sheets(2)
  8. Mysql On Computer(9)
  9. Database Access On Remote Server W/jsp(0)
  10. Any Website Provide Free Host Mysql Host?(4)
  11. Mysql Multiple Tables(1)
  12. Mysql Overhead(3)
  13. Login System(6)


 



- Lo-Fi Version Time is now: 5th December 2008 - 05:18 PM