Hi, we are having trouble exporting and importing databases with blobs in mysql. We have a development environment and a production environment both running mysql-5.0.45 and want to dump databases with blobs from one to the other. We have tried with many options but nothing works. When importing the databases mysql partially imports data and suddenly stops and reports errors such as:
Error: Unknown Command '''
Unknown Mysql server host: '[random text from the mysql dump file]'We did a lot on googling and found many suggestions that didn't work. Some suggestions included increasing the max_allowed_packet to 1GB and increasing the read_buffer_size but none works.
We also tried exporting using --hex-blob to no avail.
Our last dump statement:
mysqldump -uroot -ppword --skip-extended-insert --max_allowed_packet=1G --read_buffer_size=16M --hex-blob databasename> /dir/databasename.sql
Our last restore statement:
mysql -uroot --max_allowed_packet=1G --read_buffer_size=16M databasename < /dir/databasename.sql