| |||||||
This is a discussion on Multiple databases within the Technical Help forums, part of the Off Topic category; Does anyone know or have any instructions on how to create a database inside a database? sort of like a ...
 |
| | Thread Tools |
16-06-09, 07:02 PM
| #1 |
| Mini Mac  Join Date: Dec 2006 Location: Aberdeenshire
Posts: 4,038
   | Multiple databasesDoes anyone know or have any instructions on how to create a database inside a database? sort of like a sub-database. Not sure on what it would be called. I know I have done it before but I can't remember how. Any help will be much appreciated
__________________ My Sites Free Nintendo DSi Free Macbook Pro Free Galaxy Nexus Free iPhone 4S Free iPad 2 open spoiler to see what im doing Spoiler |
 |
|
16-06-09, 08:49 PM
| #2 |
| iPod 20gb  Join Date: May 2009 Location: Sussex
Posts: 505
| Do you mean multiple tables within one database or a relational database? I'm not sure you can create databases within databases but I might be wrong there. |
| |
|
16-06-09, 08:50 PM
| #3 |
| Mini Mac Join Date: Dec 2006 Location: Aberdeenshire
Posts: 4,038
| To be honest I'm not sure. I did one before for a couple of my blogs using just one main database but I can't remember how.
__________________ My Sites Free Nintendo DSi Free Macbook Pro Free Galaxy Nexus Free iPhone 4S Free iPad 2 open spoiler to see what im doing Spoiler |
| |
|
16-06-09, 10:15 PM
| #4 |
| iPod 20gb  Join Date: Jan 2009
Posts: 455
| Anytime I created a database I always used Microsoft Access. We had to create them for our A-Level IT Coursework. If I can find it for you I'd be willing to send you it as an example. This is one of the better tutorial sites I've used in the past: Microsoft Access Tutorials Hope that's of some use! |
| |
|
16-06-09, 10:20 PM
| #5 |
| Mini Mac Join Date: Dec 2006 Location: Aberdeenshire
Posts: 4,038
| What I'm really needing to do is this I have a database already set up which has wordpress installed on it. Can i create a seperate partition on that database to upload the database used in this. ip2nation - resolve IP to country It's just a database that would hold the IP information for different countries and I would access it by making a query in the PHP. Is this possible at all? I'm not really that great with databasing stuff to be honest
__________________ My Sites Free Nintendo DSi Free Macbook Pro Free Galaxy Nexus Free iPhone 4S Free iPad 2 open spoiler to see what im doing Spoiler |
| |
|
16-06-09, 10:23 PM
| #6 |
| iPod 20gb Join Date: Jan 2009
Posts: 455
| Found this, not sure if it's what you mean but: MySQL :: Improving Database Performance with Partitioning SQL Server 2Kx: How to move a database to a different partition in the local file system? - Server Fault |
| |
|
16-06-09, 10:35 PM
| #7 | |
| Site Owner: KUDOS network  Join Date: May 2007 Location: Suffolk. UK
Posts: 2,680
 | Quote:
Just upload the .sql file into your existing db and it will create 2 new tables within that db. You can then reference those tables using php. Dead easy. If you need help PM me. 
__________________ ::KUDOS network:: :: Check out the new KUDOS design :: << eXceem Network Staff Member of the Year 2010 >> << eXceem New and Unproven Network of the Year 2008 >> consoles - apple - ps3 - gadgets - hdtv - gifts - points - mobiles Follow us on Twitter Owned & Operated By Kudos Media Limited | |
| |
|
17-06-09, 10:29 AM
| #8 |
| is meant to be revising  Join Date: Dec 2008 Location: Nottinghamshire
Posts: 6,451
| Hmmm, I might be Pm'ing too, if you don't mind?
__________________ Well since as my SERPS are now dead, I won't belearning how to get an iPad for nothing anymore| My Free Xbox 360 sitehas tanked |And the only one that was an experiment and doesn't make money is Free 3DS darn it. Want to know how to get greens (referrals) for FreebieJeebies? I'll tell you how..... Work hard, like the rest of us! Feel free to ask questions! |
| |
|
17-06-09, 10:35 AM
| #9 | |
| Site Owner: KUDOS network Join Date: May 2007 Location: Suffolk. UK
Posts: 2,680
| Quote:
__________________ ::KUDOS network:: :: Check out the new KUDOS design :: << eXceem Network Staff Member of the Year 2010 >> << eXceem New and Unproven Network of the Year 2008 >> consoles - apple - ps3 - gadgets - hdtv - gifts - points - mobiles Follow us on Twitter Owned & Operated By Kudos Media Limited | |
| |
|
17-06-09, 11:00 AM
| #10 |
| iPod 20gb Join Date: May 2009 Location: Sussex
Posts: 505
| Are you going to use this as a kind of "If country not in list show this"? I might do something similar and edit the file so that of the users IP address isn't in the table I'll display a "Sorry, at the moment these offers aren't available in your country" message. Kudos is right, just run the sql file in your phpmyadmin area and two tables will be created which can then be queried in exactly the same way as you're doing for existing tables. |
| |
|
17-06-09, 11:08 AM
| #11 |
| Mini Mac Join Date: Dec 2006 Location: Aberdeenshire
Posts: 4,038
| I want it to run sort of the same as the one I have already on my site, but more accurate than just detecting the users language on their browser
__________________ My Sites Free Nintendo DSi Free Macbook Pro Free Galaxy Nexus Free iPhone 4S Free iPad 2 open spoiler to see what im doing Spoiler |
| |
|
17-06-09, 11:17 AM
| #12 | |
| Site Owner: KUDOS network Join Date: May 2007 Location: Suffolk. UK
Posts: 2,680
| Quote:
Be careful with restricting visitors based on their IP. It isnt 100% accurate. What I do with kudos is default to UK, if the user is showing up as anything other than UK, US or CA.
__________________ ::KUDOS network:: :: Check out the new KUDOS design :: << eXceem Network Staff Member of the Year 2010 >> << eXceem New and Unproven Network of the Year 2008 >> consoles - apple - ps3 - gadgets - hdtv - gifts - points - mobiles Follow us on Twitter Owned & Operated By Kudos Media Limited | |
| |
|
17-06-09, 11:24 AM
| #13 |
| Mini Mac Join Date: Dec 2006 Location: Aberdeenshire
Posts: 4,038
| I'm just going to have mine as a checker that they can open if they wish to check and see if they can get stuff for free or not. They will click a link called country checker that will open a new window and will run the script to check their ip. Depending on whether they can or not they will either see a success screen which will allow them to click and visit the freebie site or they will see a sorry you cannot blah blah image.
__________________ My Sites Free Nintendo DSi Free Macbook Pro Free Galaxy Nexus Free iPhone 4S Free iPad 2 open spoiler to see what im doing Spoiler |
| |
|
17-06-09, 11:31 AM
| #14 | |
| Site Owner: KUDOS network Join Date: May 2007 Location: Suffolk. UK
Posts: 2,680
| Quote:
__________________ ::KUDOS network:: :: Check out the new KUDOS design :: << eXceem Network Staff Member of the Year 2010 >> << eXceem New and Unproven Network of the Year 2008 >> consoles - apple - ps3 - gadgets - hdtv - gifts - points - mobiles Follow us on Twitter Owned & Operated By Kudos Media Limited | |
| |
|
17-06-09, 12:09 PM
| #15 | |
| iPod 20gb Join Date: May 2009 Location: Sussex
Posts: 505
| Quote:
| |
| |
|
| Thread Tools | |
| |
