If your site is hosted in a *nix machine with shell access, another option
might be to create a database and write up the SQL you need to structure
it in a text file, then just feed it straight into MySQL like this:

mysqladmin -uusername -ppassword create yourdatabase
mysql -uusername -ppassword yourdatabase < yoursqlfile

Provided you have the access and permissions, it's that simple.


On Tue, 4 Jun 2002, Jason Wong wrote:

> On Tuesday 04 June 2002 19:03, Jason Teagle wrote:
> > > Ummm, not sure exactly what you're asking but you can use mysql_query to
> > > issue the relevant sql commands to create your database and tables and
> >
> > Am I correct in saying that none of the SQL functions in PHP can actually
> > create a database file when no file existed before? In other words, an
> > empty database file must exist before SQL functions can be called on it?
> As the guy said, use mysql_query() to issue the sql commands to create the 
> database:
>  CREATE DATABASE my_database;
> > This is the problem - how _do_ you create it? What does your install script
> > do? Copy a blank template of a DB from a file in your installation package,
> > or literally create a new file? I have no existing databases to work
> > with... (what's the file extension for a MySQL-type database anyway [i.e.,
> > MS Access = .MDB, MySQL = ?] ?)
> The problem is that you haven't read the (mysql) manual. Either read the 
> manual or search out (and read) the numerous tutorials that are available.

n   i   n   t   i  .   c   o   m
Michael Hall     [EMAIL PROTECTED]

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to