bluetoother Posted January 6, 2007 Share Posted January 6, 2007 iam developing a php site on mysql data basefirst time for me working on mysqlfrom what i read it is a limited databaseso that hosting sites say that i can put 2 or 3 mysql databasesbut till now i develop the site on 1 databasedo i have to spilt it into 2 databases ?like removing some big table from the main database , then put it in another databasehope i learn about this before i present my site to the owners Link to comment Share on other sites More sharing options...
Kristian_C Posted January 6, 2007 Share Posted January 6, 2007 iam developing a php site on mysql data basefirst time for me working on mysqlfrom what i read it is a limited databaseso that hosting sites say that i can put 2 or 3 mysql databasesbut till now i develop the site on 1 databasedo i have to spilt it into 2 databases ?like removing some big table from the main database , then put it in another databasehope i learn about this before i present my site to the owners Hehe, if you are makeing 3sites you can use all three, but if you just are makeing 1 site one database is enough, you can have unlimited tables in a db so you can create like 10000 functions on one db.the limit of 3 databases is just if you want to make 2 other sites or if you want to separate some things, i like to separate all my admin login/logs ++ tables from the normal db i use for my game. So yeah one db is enough hehe.. ->Kristian_C.------------Edit:Ops dident see the limited db before now, hmm, never heard about a limited db :s.. so then i really dont know .-> Kristian_C. Link to comment Share on other sites More sharing options...
justsomeguy Posted January 8, 2007 Share Posted January 8, 2007 Hosts can optionally limit the number of databases available to a user. It's not a limit with MySQL, it's whatever the host wants the user to be able to do. If you install MySQL at home you can create as many databases as you want. You don't have to use anything, they are just giving you the option to use more then one. You may want one for your site content, maybe another one for phpbb or something like that, and another one for a shopping cart. Or, if all the tables had unique names, then you could put them all in the same database. It's just for organization. Link to comment Share on other sites More sharing options...
vytas Posted January 8, 2007 Share Posted January 8, 2007 I too have a question about the MySQL.My freehost uses PHPmyAdmin for the making of MySQL databases.I need some1 familiar with PHPmyAdmin to help me make those tables.Because i don't know how to make them. Link to comment Share on other sites More sharing options...
aspnetguy Posted January 8, 2007 Share Posted January 8, 2007 try the phpmyadmin website for instructions Link to comment Share on other sites More sharing options...
vytas Posted January 8, 2007 Share Posted January 8, 2007 Ok thx .Il think il find it on google. Link to comment Share on other sites More sharing options...
aspnetguy Posted January 8, 2007 Share Posted January 8, 2007 http://www.phpmyadmin.net/ Link to comment Share on other sites More sharing options...
bluetoother Posted January 9, 2007 Author Share Posted January 9, 2007 i thought it is limited because the hosting site said i can get more than 1 DB . so from ur talk i think it is not limited and the other DBs are for another sites as u said .. TY guys Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now