Pages: [1]   Go Down
Send this topic | Print
Author Topic: Only one database per account??  (Read 1472 times)
chazz
Member
*
Offline Offline

Posts: 44


« on: January 15, 2007, 10:10:04 PM »

 undecided

So how many accounts can u have??  afro
Logged
irvan
Member
*
Offline Offline

Posts: 27


« Reply #1 on: January 15, 2007, 10:39:09 PM »

you can have multiple accounts as long as you dont create some junk account or test account. but dont register more than what you need.

and yes there is only one database per account. but you can use one database for several things. like having joomla, and vbulletin installed on the same database, as long as the db prefix is not the same.
Logged
MO
Hyper-Active Member
***
Offline Offline

Posts: 353


Hope we all will wake up!


WWW
« Reply #2 on: January 15, 2007, 10:51:09 PM »

I also had a problem to understand how this works! But see if I get right, You will have only one DB account with one DataBase but every time you install a program which needs the DB you will have a different prefix Example below!
 
Below shows you the structuring within the MySql Database (All in one DB)
 
Quote from: MySql Database
alex_livre_img_verif_add    //All the alex_* are belong to the Guestbook entry's! //
 alex_livre_ip
 alex_livre_messages
 alex_livre_sessions
 alex_livre_smileys
 alex_livre_txt_lang
 alex_livre_users              
 
 net2ftp_log_access                    //All the net2ftp_* are belong to the net2ftp entery's! //
 net2ftp_log_consumption_ftpserver
 net2ftp_log_consumption_ipaddress
 net2ftp_log_error
 net2ftp_users
 
 sql_iden                          //All the sql_* are belong to the Mysql_Admin3.3 entry's! //
 sql_keys
 sql_user
But all this entry's are in one DataBase so you don't need multiple DB, one is enough!
Nearly all programmes will give you the option to nominate a prefix (sql_ ore net2ftp_ ...and so on_ so you will never end-up having a double entry!

The Limit Question = maximum is your total account use Domain+MySql = 2GB (I think this is correct)

So I hope I got this right explained! (if not please anyone correct me!)
« Last Edit: January 15, 2007, 11:27:30 PM by Mario » Logged

reyyy
Hyper-Active Member
***
Offline Offline

Posts: 381

Game Dev Master


WWW
« Reply #3 on: January 15, 2007, 10:54:16 PM »

This is very fair, that Andre gave to us 1 database, because on almost all other hosts you can have unlimited databases, but there is like 10-15mb limit for all databases, but here is no limit.
Logged
chazz
Member
*
Offline Offline

Posts: 44


« Reply #4 on: January 15, 2007, 11:34:56 PM »

well the only reason i ask is that i assume having multiple DBs might quicken the access time,
Logged
MO
Hyper-Active Member
***
Offline Offline

Posts: 353


Hope we all will wake up!


WWW
« Reply #5 on: January 15, 2007, 11:47:20 PM »

well the only reason i ask is that i assume having multiple DBs might quicken the access time,
I dont think it would be quicker! Having everything under one House (DB) should be quicker by logic! Running to 10 different houses opening the door and collecting your data would take much longer correct?
Logged

AD
Hyper-Active Member
***
Offline Offline

Posts: 150

U NEVER ASK, U'LL NEVER KNOW


WWW
« Reply #6 on: January 16, 2007, 12:11:39 AM »

But a forum database will never need to access the other database until and unless they are related in anyways. So it will reduce the database efficiency if they all are using same database.
As i read somewhere we can get some free data base providers and they work well ( i tried it once just to check and then deleted by account as i dont need more database at the moment )

So should not be a porblem.
Logged

reyyy
Hyper-Active Member
***
Offline Offline

Posts: 381

Game Dev Master


WWW
« Reply #7 on: January 16, 2007, 12:25:06 AM »

But still the function runs through all database in few secs, so it really doesn't matter if there is one or many databases, i would understand if on one database there would be more than 10 table prefixes, but with only few it really doesn't matter
Logged
Diemux
Underground3k.com!
Administrator
Official 110mb Guru
*****
Offline Offline

Posts: 12099


Use search before asking...


WWW
« Reply #8 on: January 16, 2007, 12:42:03 AM »

You can get a free SQL database here:

http://www...net/v2/
Logged

Problems with your 110MB account of website: Visit the support database: http://help.110mb.com!
NOW available: PHPfusion-mods.net!
Underground3k
chazz
Member
*
Offline Offline

Posts: 44


« Reply #9 on: January 16, 2007, 09:12:19 AM »

so how do i link from here to their DBs?
Logged
AD
Hyper-Active Member
***
Offline Offline

Posts: 150

U NEVER ASK, U'LL NEVER KNOW


WWW
« Reply #10 on: January 16, 2007, 11:01:35 AM »

They will provide u a username and password and will also provide u with a sql access link
While installing ur cms or forum instead of using localhost and ur 110mb.com database use the details given by the sql service provider.
Logged

chazz
Member
*
Offline Offline

Posts: 44


« Reply #11 on: January 16, 2007, 11:09:46 AM »

whats the speed like lol

btw, that sparkz site doesnt work lol
Logged
AD
Hyper-Active Member
***
Offline Offline

Posts: 150

U NEVER ASK, U'LL NEVER KNOW


WWW
« Reply #12 on: January 16, 2007, 11:16:25 AM »

The speed is just fine. For more u can test it youself as account registration is free and in case u are not satisfied u can get it deleted. And for sparkz, as box1 is currently down from 110mb.com side.
So i cant do anything about it then to just wait. hehe
Logged

freemysql.net
Member
*
Offline Offline

Posts: 14


« Reply #13 on: January 16, 2007, 03:57:15 PM »

lol I want that little guy above your URL lol, that alone I bet gets you 2 or 3 extra clicks - if you need any help PM me - You shouldn't see much of a change in speed using a remote system, at max you'll only see a few more seconds loading time.
Logged
chazz
Member
*
Offline Offline

Posts: 44


« Reply #14 on: January 16, 2007, 07:25:00 PM »

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 1 bytes) in /home/freemys/public_html/sql06/libraries/read_dump.lib.php on line 173


Need help on that area then lol.....should it be this dificult to set up a site LOL Cheesy

Need my box back lol
Logged
freemysql.net
Member
*
Offline Offline

Posts: 14


« Reply #15 on: January 17, 2007, 10:17:36 AM »

I replyed to your post on our forum
Logged
Pages: [1]   Go Up
Send this topic | Print
Jump to: