<[EMAIL PROTECTED]> skrev i meddelandet news:[EMAIL PROTECTED]... Addressed to: "Michael Andersson" <[EMAIL PROTECTED]> [EMAIL PROTECTED]
** Reply to note from "Michael Andersson" <[EMAIL PROTECTED]> Fri, 12 Apr 2002 11:58:31 +0200 > > > "Jason Wong" <[EMAIL PROTECTED]> skrev i meddelandet > news:[EMAIL PROTECTED]... > > On Monday 08 April 2002 19:15, Michael Andersson wrote: > > > > > What happens to a blob field with lets say a image when dumping a mysql > > > table to a file? > > > > I don't use BLOB fields. You try it and let me know ;-) > > Well now i tried, and it doesnt work at all, just so you know :) > > So now i have to fugure out a way to dump the table with blob:s in it to a > file cause my isp dont allow me to dump to another mysql dbase over the net > or any other way exept for a file... The FROM ISP doesn't allow it. What about the TO ISP? If you can get them to allow access from the old server: $Con1 = mysql_connect( 'oldhost', 'olduser', 'oldpassword' ); mysql_select_db( 'olddbname', $Con1 ); $Con2 = mysql_connect( 'newhost', 'newuser', 'newpassword' ); mysql_select_db( 'newdbname', $Con2 ); $R1 = mysql_query( "SELECT * FROM tablename", $Con1 ); while( $Data = mysql_fetch_array( $R1 ); mysql_query( "INSERT INTO tablename ~data~", $Con2 ); } Of course you will need to translate '~data~' into a valid SET or VALUES() block for each table, but this may allow you to get your data out of the old ISP's server without their help. Rick Rick Widmer Internet Marketing Specialists http://www.developersdesk.com Well, that could maybe work since i am running one of the sites on my on comp so... will try as soon as i get home... //Micke -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
