Re: How to create a windows folder using mysql - tatskie - com.mysql.lists.win32

4 messages in com.mysql.lists.win32Re: How to create a windows folder us...

From	Sent On	Attachments
tatskie	10 Sep 2003 17:21
Edwards	10 Sep 2003 18:21
Paul DuBois	10 Sep 2003 18:43
tatskie	11 Sep 2003 00:35

Subject:	Re: How to create a windows folder using mysql
From:	tatskie (melc...@yahoo.com)
Date:	09/11/2003 12:35:39 AM
List:	com.mysql.lists.win32

is there any limitation as to the number of the databases in the host? will this not cause a slower performance on the host server if i will be making a maximum of 5 databases a day?

--- Paul DuBois <pa...@mysql.com> wrote:

At 5:21 PM -0700 9/10/03, tatskie wrote:

i am thinking of making a program that creates a backup of tables to a new folder specified by the user. i am using foxpro thru MyODBC. Of course i can let the server do the backup by executing BACKUP TABLES command. But this is only possible if the specified folder already exist in the server. Now how i am going to do it in a new folder? My problem then is boiled down on how to let the MySQL server create a folder on the server computer.

You cannot. The server cannot be instructed by a client to create a directory on the server host. The exception to this (which is not a solution to your task) is that if the client can issue a CREATE DATABASE db_name statement, the server creates in the data directory a new directory named db_name to represent the database.

Please help me...

melchor

Are you MySQL certified? http://www.mysql.com/certification/