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's on can handle the load.
"Kai Li"
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
.com> cc:
Subject: multiple databases creation
08/05/2003 08:12
PM
Hi,
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?
Thanks for your consideration.
likai
_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
