Binary problem with db table duplication script

[Anon]

Hi,

I wrote this script that queries one database and then inserts the data into another one.

Basically it loops trough the record set and builds a query that goes to the other db.

this is the query for the data in the table
$query_get_data = "SELECT * FROM $table_from";

Then it gets the field names and such to build a query and loops over the result and does one query per row.

This all works fine when it is normal ASCII data in the table, but I wrote the script to be able to backup a table with binary data to another database.

This is where the script fails. It won't insert the binary data!

I'm using PHP4 and MySQL on a set of different OSes and machines.

Anyone that might have a clue why this f**ks up?

/Jocke

[Anon]

How bout using an insert & select to do this?

mysql_db_query($db,"INSERT INTO backup (col1, col2, col3) SELECT col1, col2, col3 FROM back_me_up");

The problem with doing everything in PHP is that it takes a while to move the data into PHP then back to the database but more importantly bin data needs to be at least quoted.

try this:
$query_get_data = mysql_db_query("db","SELECT * FROM $table_from");
while($query_get_data_row = mysql_fetch_array($query_get_data))
{
$bin_data = $query_get_data_row["bin_data"];
mysql_db_query("db","INSERT INTO $table_to SET bin_data='$bin_data'");
}

I use something similiar with images and it works great, but using the "INSERT INTO values SELECT data" is your best bet.

If it still fails post the code you're using to move the data.

[Anon]

Thanks a lot Brandon!

However, it was a very small and stupid error.

I just added "addslashes()" around the fields and now it works fine.

Thanks a lot for your effort!

/Jocke