mysql2postgres: packet is not EOF
I’ve got an error:
/usr/local/rvm/gems/ruby-1.9.3-p551/gems/mysqltopostgres-0.2.20/bin/mysqltopostgres mysql2pg.yml
Mysql2psql: Conversion failed: packet is not EOF
packet is not EOF
/usr/local/rvm/gems/ruby-2.2.0/gems/mysql-pr-2.9.11/lib/mysql-pr/protocol.rb:562:in `read_eof_packet'
/usr/local/rvm/gems/ruby-2.2.0/gems/mysql-pr-2.9.11/lib/mysql-pr/protocol.rb:274:in `retr_fields'
/usr/local/rvm/gems/ruby-2.2.0/gems/mysql-pr-2.9.11/lib/mysql-pr.rb:322:in `query'
the very short dump is appeared:
-- MySQL 2 PostgreSQL dump
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
About this issue
- Original URL
- State: open
- Created 9 years ago
- Comments: 15 (4 by maintainers)
@jvkiran - I just made sure that the suggested line is inserted at the beginning of the suggested file:
The inserted line is:
#encoding: ascii-8bit
then things worked.
@bhfailor :
Add
#encoding: ascii-8bit
at the top of the file.n-rodriguez’s patch worked for me (OSX 10.11), thanks