mysql <database> < ****.sql thru a php script
| From: | Robert Race | Date: | Sun, 23 Mar 2003 17:49:16 +0000 |
| Subject: | mysql <database> < ****.sql thru a php script | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-26570@lists.php.net to get a copy of this message | ||
I have a large sql file that I would like to load into mysql database from a
remote client. Is there a way through a php script to do this?
I have tried $query = " <contents of database.sql> "; (where the contents of
the sql file was pasted into the query)
then $results = mysql_db_query("database", $query);
but it fails. Any ideas or experience?
R Race