James,
I am using mandrake linux 8.1 and have a command 'mysqladmin' i wouldn't
of thought this was anything special to mandrake so check to see if you have
that command. If you have then it is a simple case of executing :-
mysqladmin <options> create <database_name>
just type the command on it's own to see all the possible commands/options
HTH
Mark.
On Tuesday 19 March 2002 10:50 pm, Hanson, Robert wrote:
> "How do I CREATE a database from within perl with MySQL?"
>
> I don't think you can... but you can run the mysql interface from the
> script. Actually I think that you can pipe a list of commands to mysql.
>
> Rob
>
> -----Original Message-----
> From: James Taylor [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 19, 2002 5:20 PM
> To: [EMAIL PROTECTED]
> Subject: DBI really quick question
>
>
> CPAN is running exremely slow (as per usual) and I just have a quick
> question. How do I CREATE a database from within perl with MySQL?
> Generally
>
> the first command you give for DBI will be a statement to connect to a db,
> but what if I have to have the db created first?
>
> This is for a script that will automate the installation of a set of 12
> scripts, and sets up 6 tables, and I don't want to have to tell users to
> first have to run mysql, type in "create database blah", quit, and then run
> the script.
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
