 Mysql Question... |
|
|
|
|
  |
 Nov 22 2007, 10:40 PM
Post
#1
|
|
|
Newbie [ Level 2 ]  Group: Members Posts: 16 Joined: 6-January 07 Member No.: 19,171  |
I was wondering if you could use mysql databases to combine with a totally different host.
Example... I do not want to move my files from my 1and1 hosting. But I am out of databases i need 2 more. Would I be able to use these ones if i decide to sign up for hosting with my 1and1 hosting? like the file is on my 1and1 hosting, just upload myphp or w/e and tables etc to the other mysql...? |
 |
 
|
|
Nov 23 2007, 12:12 AM
Post
#2
|
|
|
Absolute Newbie  Group: Admin Posts: 887 Joined: 20-February 05 From: Indianapolis, Indiana, USA (Midwest) Member No.: 2,714 |
Why don't you just use the same database over!
If you add a different prefix for your tables, then you can get away with only one database for several scripts or even several installations of the same script. For example this forum system, Invision Power Board, uses "ibf_" as a prefix for all of the tables it uses. So, in the same database, I could use the same set of tables for a second installation except use a different prefix like "ibf2_". It is very difficult to get one host to connect to an MySQL server on a different host. Most host block such a connect to prevent security problems. vujsa |
|
|
|
|
Nov 23 2007, 12:39 AM
Post
#3
|
|
|
Newbie [ Level 2 ] Group: Members Posts: 12 Joined: 22-November 07 Member No.: 26,376 |
QUOTE(vujsa @ Nov 23 2007, 12:12 AM)  Why don't you just use the same database over! If you add a different prefix for your tables, then you can get away with only one database for several scripts or even several installations of the same script. For example this forum system, Invision Power Board, uses "ibf_" as a prefix for all of the tables it uses. So, in the same database, I could use the same set of tables for a second installation except use a different prefix like "ibf2_". It is very difficult to get one host to connect to an MySQL server on a different host. Most host block such a connect to prevent security problems. vujsa Thank you so much for your help, I am a PHP/MySQL Newbie so I had no idea, thanks  |
|
|
|
|
Nov 27 2007, 09:27 PM
Post
#4
|
|
|
Super Member  Group: [HOSTED] Posts: 750 Joined: 8-April 06 From: Lima - Peru Member No.: 12,579 |
Yes you could do that but what vujsa says is correct and it is the best way to avoid a lot of problems.
Check the following topics for more information about:Best regards, |
|
|
|
|
Dec 24 2007, 05:29 AM
Post
#5
|
|
|
Member [ Level 1 ] Group: [HOSTED] Posts: 44 Joined: 26-August 07 Member No.: 24,372 |
I don't think it is possible to do so. As I know, connecting with MySQL shouldn't cross domains.
|
|
|
|
|
Dec 25 2007, 12:45 AM
Post
#6
|
|
|
Super Member Group: [HOSTED] Posts: 750 Joined: 8-April 06 From: Lima - Peru Member No.: 12,579 |
QUOTE(takashiro @ Dec 24 2007, 12:29 AM) I don't think it is possible to do so. As I know, connecting with MySQL shouldn't cross domains. Yes, it is possible to do, but it is not recommended. Best regards and merry christmas, |
|
|
|
|
Dec 26 2007, 02:46 PM
Post
#7
|
|
|
Advanced Member Group: [HOSTED] Posts: 177 Joined: 25-December 07 Member No.: 27,129 |
QUOTE(takashiro @ Dec 24 2007, 05:29 AM) I don't think it is possible to do so. As I know, connecting with MySQL shouldn't cross domains. It is possible. It all depends on your host, if they permit you to use their mySQL databases on a different website hosted outside of them, feel free to. Otherwise, do as vujsa says and use different table prefixes. |
|
|
|
|
Similar Topics
|
Lo-Fi Version | Time is now: 8th September 2008 - 03:09 AM |