Support Forums
PHP automatically create new database after x tables - Printable Version

+- Support Forums (https://www.supportforums.net)
+-- Forum: Categories (https://www.supportforums.net/forumdisplay.php?fid=87)
+--- Forum: Coding Support Forums (https://www.supportforums.net/forumdisplay.php?fid=18)
+---- Forum: PHP The Hypertext Preprocessor (https://www.supportforums.net/forumdisplay.php?fid=21)
+---- Thread: PHP automatically create new database after x tables (/showthread.php?tid=5005)



PHP automatically create new database after x tables - Dutchcoffee - 02-24-2010

Hello,

Is it possible to create a whole new mysql database, after one database reaches a certain amount of tables?

For example, if one database reaches over 200 tables, automatically create a new table.

Thanks


RE: PHP automatically create new database after x tables - Omniscient - 02-24-2010

Why would you want to do this? Curious because I don't see how this is a benefit.

However it should be possible as long as the DB user has the proper permissions with MySQL.


RE: PHP automatically create new database after x tables - Dutchcoffee - 02-24-2010

(02-24-2010, 08:48 PM)Omniscient Wrote: Why would you want to do this? Curious because I don't see how this is a benefit.

However it should be possible as long as the DB user has the proper permissions with MySQL.

I am looking in to doing this because I am working on opening a MyBB web host, and I don't want to overload one MySQL database with all the tables.


RE: PHP automatically create new database after x tables - Omniscient - 02-25-2010

Why not just create a new database for every site?


RE: PHP automatically create new database after x tables - Peachyâ„¢ - 02-25-2010

I agree with Omni, Creating a new database for every site would be a wiser idea.


RE: PHP automatically create new database after x tables - Dutchcoffee - 02-25-2010

I can't do that, because I only have a limit of 170 databases.