Skip to main content

MySQL - Issues - solutions


Issue 1 - 1273 (HY000) at line 25: Unknown collation: 'utf8mb4_0900_ai_ci'

ERROR  

 Running: mysql.exe --defaults-file="c:\users\ishma\appdata\local\temp\tmpdj9_y0.cnf"  --protocol=tcp --host=localhost --user=root --port=3307 --default-character-set=utf8 --comments --database=sakila < "C:\\Users\\ishma\\Documents\\dumps\\Dump20201229\\sakila_address.sql"


Solution

  1. Open the sql file in your text editor
  2. Find and replace all utf8mb4_unicode_520_ci with utf8mb4_unicode_ci
  3. Save and upload to a fresh mySql db

Labels

Labels:

Comments

Post a Comment

Popular posts from this blog

Reading (IBM) MQ messages and sending messages to backout queue Using Java in client binding

Hi, I try to share my experience/knowledge on reading the messages from (IBM) MQ in client mode, while I was working I try to gather the details through different sources but get very less information in order to finish my task on MQ part. Initially I struggle a lot it made me to write this blog, if you want read the IBM MQ messages using java client you can use this following code... Reading the MQ Messages in Client mode:   import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.IOException; import java.io.InputStream; import java.util.Properties; import org.apache.log4j.Logger; import org.apache.log4j.PropertyConfigurator; import com.ibm.mq.MQException; import com.ibm.mq.MQGetMessageOptions; import com.ibm.mq.MQManagedObject; import com.ibm.mq.MQMessage; import com.ibm.mq.MQPutMessageOptions; import com.ibm.mq.MQQueue; import com.ibm.mq.MQQueueManager; import com.ibm.mq.constants.CMQC; public class QueueReader{ private M...
Post a Comment
Read more

Reading IBM MQ messages and sending messages to backout queue using Java in server binding

When you are running your java client in server binding to read the messages from MQ you make sure that  your java client is running on your MQ Serever. When you are running the java client in server binding  you will get the very good performance with compare to client binding. I am able to read 500 messages in 2.2 seconds each message size is around 30KB. import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.IOException; import java.io.InputStream; import java.util.Properties; import org.apache.log4j.Logger; import org.apache.log4j.PropertyConfigurator; import com.ibm.mq.MQException; import com.ibm.mq.MQGetMessageOptions; import com.ibm.mq.MQManagedObject; import com.ibm.mq.MQMessage; import com.ibm.mq.MQPutMessageOptions; import com.ibm.mq.MQQueue; import com.ibm.mq.MQQueueManager; import com.ibm.mq.constants.CMQC; public class QueueReader{ private MQQueueManager _queueManager = null; public String qManager = null; ...
Post a Comment
Read more