Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

wondering why an invalid insert (exceeds char length varchar(100)) breaks when piping mysqlbinlog output to RDS-- when pasted into a client and run separately-- it inserts, truncates, and warns instead.

share|improve this question
    
Was the column definition identical on the server that generated the binlog? – Michael - sqlbot Mar 14 '13 at 14:51
    
Come to find out that it's not the character length thats causing the problem-- its a hidden character in the mysqlbinlog output. Not sure how best to clean these out... – JShean Mar 15 '13 at 14:01

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.