Assume you’ve already verified your certificates and keys on the sever side (checksum should be the same): openssl x509 -noout -modulus -in mycert.pem openssl rsa -noout -modulus -in mykey.pem mysql> show variables like...
Read MoreWhen given a comma or tab-delimited file, we usually want to import this into some kind of database. The first you need to find out is what type of file this is as it could make or break your import. g _ – goes to the...
Read MoreWhile creating a schema for SNOMED to ICD-10 mapping, I came across the requirement of storing a UUID (128-bit unsigned integer) as the ‘id’ field. 128-bits = 16 bytes so we’ll use BINARY(16). drop table if...
Read MoreLet me guess, you’re trying to setup MySQL replication and you end up with errors like the following: ERROR 2026 (HY000): SSL connection error: protocol version mismatch ERROR 2026 (HY000): SSL connection error: ASN: bad...
Read MoreGetting the following error on your mac v10.10? Run the following command in the Terminal / command line to fix the issue. This allows your program to find the library dependencies in the lib path. sudo ln -s...
Read MoreGetting Date Exception when data has null or zero values in record? Modify your connection database url as follows to fix the error jdbc:mysql://yourserver:3306/yourdatabase?zeroDateTimeBehavior=convertToNull
Read MoreIf you get an error that says the auto-generated index name is too long (limited to 64 characters) during a rails migration, add a name to it in the last argument to overwrite the generated name with your custom shorter name....
Read MoreI’ve gotten this error on both ubuntu and mac osx. Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2) Simple quick fix solution is to create a symbolic link to it. The...
Read MoreSo I’ve ran into an emergency case where I had to restore a single table from a 40GB backup created with mysqldump (A logical backup). Restoring the whole thing would take more than two hours! Let’s use...
Read MoreMethod DROP Default Change Default Rename Column Change Datatype Column Order ALTER CHANGE MODIFY ...
Read MoreHow do you dump data from a mysql database table without the drop and create tables showing up before the inserts? The following solution will just give you a list of insert statements. Simply use the options...
Read MoreInnoDB vs MyISAM This pertains to MySQL 5.5 InnoDB stores data in a file(s) called a tablespace. In newer versions of MySQL, you can store the data and indexes in separate files. MyISAM stores the data and indexes in two files...
Read More
Recent Comments