Re: Import .sql file via PHP
- From: Ivan Omelchenko 608308824 <news@xxxxxxxxxxxxxx>
- Date: Mon, 30 May 2005 15:16:06 +0300
Tim Van Wassenhove пишет:
I guess it will NOT working, because of line can be much more than 2048 bytes, or it can be BLOB or another..On 2005-05-30, Jamie Meyers <gtg061q@xxxxxxxxxxxxxxx> wrote:
Nevermind, I decided to parse the .sql file and create the query there. I do not think there is any way to import the .sql file via php. Thanks anyways. And if anyone would like this script after I fix it up a little more, let me know.
Assuming each instruction is on a line.. (untested)
$db = mysql_connect(....); mysql_select_db(....);
$fp = fopen('somefile.sql', 'r'); while($fp != feof()) { $line = fread($fp, 2048); $line = mysql_real_escape_string($db, $line); mysql_query($line); } fclose($fp);
Or, can be comment multi line. your script will failed.
.
- References:
- Import .sql file via PHP
- From: Jamie Meyers
- Re: Import .sql file via PHP
- From: Stephen Harris
- Re: Import .sql file via PHP
- From: Jamie Meyers
- Re: Import .sql file via PHP
- From: Tim Van Wassenhove
- Import .sql file via PHP
- Prev by Date: Re: Opnion needed on image manipulation (not neccesarilly PHP)
- Next by Date: Re: How to create html list from such array ?
- Previous by thread: Re: Import .sql file via PHP
- Next by thread: Re: Import .sql file via PHP
- Index(es):
Relevant Pages
|
