{"id":1216,"date":"2022-08-30T15:14:19","date_gmt":"2022-08-30T15:14:19","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2013\/11\/10\/error-1115-42000-at-line-29-unknown-character-set-utf32-collection-of-common-programming-errors\/"},"modified":"2022-08-30T15:14:19","modified_gmt":"2022-08-30T15:14:19","slug":"error-1115-42000-at-line-29-unknown-character-set-utf32-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2022\/08\/30\/error-1115-42000-at-line-29-unknown-character-set-utf32-collection-of-common-programming-errors\/","title":{"rendered":"ERROR 1115 (42000) at line 29: Unknown character set: &#39;utf32&#39;-Collection of common programming errors"},"content":{"rendered":"<p>I am trying to import a mysqldump file into my local database. I am using the following command<\/p>\n<pre><code>mysql5 -u root -p fbpj &lt; anthonyl_fbpj.sql\n<\/code><\/pre>\n<p>and the following error appears<\/p>\n<pre><code>ERROR 1115 (42000) at line 29: Unknown character set: 'utf32'\n<\/code><\/pre>\n<p>__ Below is the part of the dump where the error is being thrown, at the very bottom. I am confused on what could be going on.<\/p>\n<pre><code>-- phpMyAdmin SQL Dump\n-- version 3.4.11.1\n-- http:\/\/www.phpmyadmin.net\n--\n-- Host: localhost\n-- Generation Time: Mar 02, 2013 at 03:49 PM\n-- Server version: 5.5.23\n-- PHP Version: 5.2.17\n\nSET SQL_MODE=\"NO_AUTO_VALUE_ON_ZERO\";\nSET time_zone = \"+00:00\";\n\n\n\/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *\/;\n\/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS *\/;\n\/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION *\/;\n\/*!40101 SET NAMES utf8 *\/;\n\n--\n-- Database: `anthonyl_fbpj`\n--\n\n-- --------------------------------------------------------\n\n--\n-- Table structure for table `comments`\n--\n\nCREATE TABLE IF NOT EXISTS `comments` (\n  `id` varchar(36) NOT NULL,\n  `project_id` varchar(36) NOT NULL,\n  `user_id` varchar(36) NOT NULL,\n  `task_id` varchar(36) NOT NULL,\n  `data_type_id` varchar(36) NOT NULL,\n  `data_path` varchar(255) DEFAULT NULL,\n  `message` longtext,\n  `created` datetime DEFAULT NULL,\n  `modified` datetime DEFAULT NULL,\n  PRIMARY KEY (`id`),\n  KEY `fk_comments_users` (`user_id`),\n  KEY `fk_comments_projects1` (`project_id`),\n  KEY `fk_comments_data_types1` (`data_type_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf32;\n<\/code><\/pre>\n<ol>\n<li>\n<p>Your table <code>comments<\/code> is set to use the <code>UTF32<\/code> character set, which was not supported by MySQL before v5.5.3.<\/p>\n<p>You are probably attempting to import this dump into an earlier version of MySQL.<\/p>\n<p>You might be able to get away with it just by changing <code>utf32<\/code> to <code>utf8<\/code> in your dump, before loading it.<\/p>\n<\/li>\n<\/ol>\n<p id=\"rop\"><small>Originally posted 2013-11-10 00:10:28. <\/small><\/p>","protected":false},"excerpt":{"rendered":"<p>I am trying to import a mysqldump file into my local database. I am using the following command mysql5 -u root -p fbpj &lt; anthonyl_fbpj.sql and the following error appears ERROR 1115 (42000) at line 29: Unknown character set: &#8216;utf32&#8217; __ Below is the part of the dump where the error is being thrown, at [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1216","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1216","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=1216"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1216\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=1216"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=1216"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=1216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}