How to create database?

How to create database?

Postby newyuppie » Fri 07 Jul 2006 22:22

hi,

i was wondering how to create a new database in the host and port specified. my problem is that using MySQLDump or MySQLScript both require the MySQLConnection as input parameter, but MySQLConnection requires a database as parameter, so its a bit of a loop.

is there a way to connect to the host and port (no specified database) and execute a "CREATE DATABASE" statement?

thank you for the time
ny
newyuppie
 
Posts: 13
Joined: Fri 07 Jul 2006 05:48

Postby Alexey » Mon 10 Jul 2006 11:40

You may omit database name in a connection string.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby newyuppie » Mon 10 Jul 2006 13:36

thank you
newyuppie
 
Posts: 13
Joined: Fri 07 Jul 2006 05:48

Postby Alexey » Mon 10 Jul 2006 15:26

You are welcome.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL