I wonder if you are doing the import with phpMySQL. It does not seem possible to import a large database with phpMySQL (or perhaps any php based utility?) on a local PC running windows without hitting various timeouts.
I am dealing with large import by doing them directly using mysql at the command line level -- Jacques Brignon > -----Message d'origine----- > De : mik...@qualityadvantages.com [mailto:mik...@qualityadvantages.com] > Envoyé : samedi 13 décembre 2008 15:13 > À : mysql@lists.mysql.com > Objet : MediumBlob / phpMyAdmin / hex dumps Questions > > Hello and Greetings mysql list, > > A few weeks ago, I posted a question here about importing a database > to my local XP pro system and getting loads of MySQL server went away > errors during the import. I got suggestions about increasing max > packet size and a few other parameters which I followed but still > could not get a clean import with out the server going away error. > > I have since some more troubleshooting to try to narrow in on the > source of the problem. The table that is getting the error I have > isolated and know that it is a PhotoPlog data table that contains all > the binary images that it is storing. The Table has two fields defined > with mediumblob, one for the picture and the second one for the > thumbnail. > > I have used phpMySQL to export this table and noticed that it is > dumping these fields as HEX and not binary and think that this may be > the source of the problem with importing to another system. > > Anyone have any thoughts on MediumBlog being dumped out as HEX? > > The other troublesome part of this problem is that only some of the > records have problems and no clue what the distinction is between the > ones that work and the ones that fail? > > Any pointer greatly appreciated as always. > > TIA > > > > -- > Best regards, > mikesz mailto:mik...@qualityadvantages.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=jacbrig...@online.fr -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
