from the mysql invoked by ? while in the mysql client the command \. is what you use. the blurb after is "Execute a SQL script file. Takes a file name as an argument. Dump a file with phpMyAdmin you get a sql file. at least in Windows you do so I assume you do in non windows OS'es also.
Advertising
John On Sat, 2002-09-21 at 09:27, Brad Bonkoski wrote: > I don't think it quite works that way through PHP. You could send the > _contents_ of the file through PHP, like open the file, and read it into a > buffer, and send that as a query. I actually create the files and then go into > my database system (MySQL -or- PostgreSQL) and then execute a command. I think > for MySQL it is: > mysql> \i <name_of_file> > and then that will step through the file executing the SQL statements. > -Brad > > Bryan McLemore wrote: > > > So I would send the file through with a sql query? > > > > -Bryan > > ----- Original Message ----- > > From: "Brad Bonkoski" <[EMAIL PROTECTED]> > > To: "Bryan McLemore" <[EMAIL PROTECTED]> > > Cc: "PHP DB LIST" <[EMAIL PROTECTED]> > > Sent: Saturday, September 21, 2002 8:18 AM > > Subject: Re: [PHP-DB] SQL file, > > > > > Typically, it is a text file that has SQL in it. > > > Like: > > > CREATE DATABASE some_name ( > > > ID int NOT NULL AUTO_INCREMENT PRIMARY KEY, > > > NAME varchar(30), > > > etc.... > > > > > > Usually they are used to store the database information, and can be used > > in many of the database systems. Within the database itself, there is a > > command to insert from a file. Not sure off the top of my head, but the > > help menu should provide that > > > information, then the database would go through your file and execute > > those commands as if you were entering them in manually on the command line. > > Espescially helpful for huge tables where you might be open to a typo, and > > have to start all over. > > > HTH > > > -Brad > > > > > > Bryan McLemore wrote: > > > > > > > in an example I saw in a book while I was leafing through it at barnes > > and nobles I saw a .sql file. It appeared to have the schema for a db in > > it. I was wondering what exactly what it is and how one could use it in a > > php application like he was doing. > > > > > > > > Thanks, > > > > Bryan > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
