I was trying to do a database dump (non locking) from this server that was running MySQL 5.5 and I kept getting this annoying SSL error when running the dump command from some of my linux boxes. The command looked like this:
mysqldump -h'servername.com' -uroot -p --routines --lock-tables=false --quick --databases database_name > dump.sql
Error would look like this:
ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1)
I found this post which helped me finally get a dump file:
http://stackoverflow.com/questions/31413031/mysql-error-2026-hy000-ssl-connection-error-error00000001lib0func0re
I just had to add in --skip ssl to get my data:
mysqldump -h'servername.com' -uroot -p --routines --lock-tables=false --quick --skip-ssl --databases database_name > dump.sql
No comments:
Post a Comment