Re: MySQL - Creating The Database

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. Michael 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 php-python-perl-mysql-postgresql -------------------------------- Michael Hall ninti@ninti.com --------------------------------