RE: multiple databases creation

2003-08-14 Thread Dan Muey
> Hi, Howdy > > I know that Mysql handles large database very well, but there > is a project > that requires more than 2000 small databases(about 20 talbes > with a few > rows) to be created within a Mysql server. Could somebody > tell me does it > make sense? Err.. Sure it makes sense I

Re: multiple databases creation

2003-08-14 Thread Mike . Kent
My recommendation would be to use phpmyadmin, http://www.phpmyadmin.net/. Takes just a few minutes to pull out the original database schema then feed it back to create new tables. Or you can do it with command-line instructions. 2000 small databases shouldn't be a problem as long as the server it'