SQL Backup not working with PHP Script

Question

I am using the script found at this blog post.

What I am trying to do is output the SQL Code onto the screen and then using file_get_contents from my local web server to get the SQL Query and mysql_query it to my local database.

The problem is when I do this it gives me an error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO...

If I copy and paste the SQL Code from the screen it's executed perfectly fine.

I know this is quite a weird request but if someone could help me find the problem it'll be great.

Unfortunately not as it contains client information

Sandeep Bansal
– Sandeep Bansal

2011-09-24 02:47:10 +00:00
Commented Sep 24, 2011 at 2:47 — Sandeep Bansal
– Sandeep Bansal, Commented Sep 24, 2011 at 2:47

Eli Y · Accepted Answer · 2011-09-24 03:25:57Z

1

well i used this

    $file = file_get_contents("db-backup-1316832550-6f1ed002ab5595859014ebf0951522d9.sql");
foreach(explode(';', $file) as $value => $key)
{
if($key == ''){continue;}

echo $key;
mysql_query($key) or die(mysql_error());
}

of course the file is example one

there's seems to be a problem with the delimiter = ";"

answered Sep 24, 2011 at 3:25

Eli Y

90717 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Backup not working with PHP Script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related