Database backup problem

Phoenix_Down

I'm trying to make something that can execute a SQL file within a query. Here is my code:

$filePointer=fOpen("$UploadedFile","rb");
$fileContents=fRead($filePointer, fileSize("$UploadedFile"));
fClose($filePointer);

include '../config.php';

$dbi = mysql_connect ("$server", "$user", "$pass") or die ("Error connecting.");
mysql_select_db ("$db") or die ("Error selecting database.");

$result = mysql_query("$fileContents", $dbi);

echo mysql_error();

Here is what mysql_error reports:

You have an error in your SQL syntax near '; CREATE TABLE admin ( id int(10) NOT NULL auto_increment, username var' at line 14

What's wrong?

Mordecai

Have you tried it with some easier queries? It might just be something wrong with the query.

The code appears to be correct.

Phoenix_Down

I don't think it's the query. The SQL file is generated 100% from PHPMyAdmin.

Mordecai

Do you have quotes in the query? It might be adding slashes.

Try using stripslashes().

Phoenix_Down

Okay, I added the stripslashes(); thing--still the same error:

You have an error in your SQL syntax near '; CREATE TABLE admin ( id int(10) NOT NULL auto_increment, username var' at line 14

spirp

As Mordecai said, start with an easy query, then go for more complex. You code looks fine, and it might just as well be a problem with slashes, or the lack of slashes.

Start with a simple query without any quotes:

SELECT * FROM table;

Add some quotes:

SELECT * FROM table WHERE test LIKE 'teststring';

And keep creating complex queries, until you get an error. then compare the last error free query with the the one that generated the error. In what way are they different? A good idea might also be logging what's being done, what the query looks like and so on..

Good luck,
Olle