utf8 options under Mysql

[Martin Mueller]

MySQL has a bewildering variety of unicode collation choices. Most of them are 
language specific, but what is the difference between "utf8-general-ci", 
"utf8-unicode-ci", and "utf8-unicode-520-ci." Do they differ in the range of 
characters they can handle or is it just a matter of the cort order. I 
understand that utf8-bin is different because it is case sensitive, but the 
other differences elude me. 

Under what circumstances does it make a difference to use on or the other? I 
work with a lot of Early Modern print data and the weird symbols of various 
kinds they use. I've had trouble at times with the "utf8-general-ci" setting, 
but it may have been more a matter of settings on my front end tool than of the 
choice of this rather than unicode collation. 

Under character sets, there is just one utf8 setting.  The simplest way to make 
sense of the choices would be to say that given a character set (utf8) the 
collation only makes a difference to the sort but makes no difference to what 
can be displayed. Is that correct. 

Re: Lost Connection Upon Loading Dump

[Peter Brawley]

On 4/21/2016 10:51, Stephen R Guglielmo wrote:

Hello,

I have a empty db that I'm trying to load a .sql file (created via
mysqldump) into. The dump has 791611 lines and is 807 MB. Loading the
dump is consistently failing at line 1763. Line 1763 is an INSERT
statement. The line is 95610 characters long.

The error is:
ERROR 2013 (HY000) at line 1763: Lost connection to MySQL server during query

About 40 tables are restored correctly from the dump prior to it
failing at this line.

Based on advice from posts I've found on the internet, I've added the
follow settings to my.cnf
net_read_timeout=60
# 16 MB
max_allowed_packet=16777216

I added these to both the [mysqld] and [mysqld_safe] sections to be
sure. I restarted mysqld, but still get the same error upon loading
the dump.

I'm not seeing anything in my error log (do I need to enable more
verbose error logging?).

MySQL Ver 14.12 Distrib 5.0.95, for redhat-linux-gnu (x86_64) using readline 5.1

I would appreciate any advice on figuring this out.


Slow: change the mysqldump params to turn off multiple inserts per
statement, and run the dump again.

Faster: grow the mysqldump net_buffer_length setting, and the mysqld setting of 
the same name, to accommodate the largest multiple insert. You may also have to 
grow max_allowed_packet.

PB

-




Thanks,
Steve




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: parallel installations of mysql

[shawn l.green]

On 4/20/2016 2:04 PM, Martin Mueller wrote:


I am running MySQL 5.6.22 on an iMac as a desktop database. I would like to 
install 5.7.12. Can I install it as a parallel and independent  instance? And 
if so, are there special problems to watch out for?





Why would I want to do this? Well, I have a set of databases and tables on the 
old installations that have grown over the years. Given the way I work, the 
simplest thing would be install the new database and then work through my 
existing tables over a number of weeks and transfer stuff as I go along.   That 
may not be very professional but it works for me, and it would let me keep the 
old along the new, just in case something goes wrong/

My friends tell me to use sqlite, and they are probably right since file 
management is so much simpler. But I find the many builtin functions of MySQL 
very helpful and don't particularly want to learn a new set.

Martin Mueller



Many systems have more than one mysqld running on them at the same time. 
To make them operate safely, you have to isolate them from each other 
using the guidance in this section of the manual:


http://dev.mysql.com/doc/refman/5.7/en/multiple-servers.html


--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville, TN

Become certified in MySQL! Visit https://www.mysql.com/certification/ 
for details.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Lost Connection Upon Loading Dump

[Stephen R Guglielmo]

Hello,

I have a empty db that I'm trying to load a .sql file (created via
mysqldump) into. The dump has 791611 lines and is 807 MB. Loading the
dump is consistently failing at line 1763. Line 1763 is an INSERT
statement. The line is 95610 characters long.

The error is:
ERROR 2013 (HY000) at line 1763: Lost connection to MySQL server during query

About 40 tables are restored correctly from the dump prior to it
failing at this line.

Based on advice from posts I've found on the internet, I've added the
follow settings to my.cnf
net_read_timeout=60
# 16 MB
max_allowed_packet=16777216

I added these to both the [mysqld] and [mysqld_safe] sections to be
sure. I restarted mysqld, but still get the same error upon loading
the dump.

I'm not seeing anything in my error log (do I need to enable more
verbose error logging?).

MySQL Ver 14.12 Distrib 5.0.95, for redhat-linux-gnu (x86_64) using readline 5.1

I would appreciate any advice on figuring this out.

Thanks,
Steve

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: parallel installations of mysql

[Johan De Meersman]

That works nicely, you just need to make sure that you set up the second 
instance on a different port, with different data and log directories etc.

Do you expect many issues from the upgrade? In most cases, an in-place upgrade 
should work the same or better than the old version :-)


- Original Message -
> From: "Martin Mueller" 
> To: "MySql" 
> Sent: Wednesday, 20 April, 2016 20:04:57
> Subject: parallel installations of mysql

> I am running MySQL 5.6.22 on an iMac as a desktop database. I would like to
> install 5.7.12. Can I install it as a parallel and independent  instance? And
> if so, are there special problems to watch out for?
> 
> 
> 
> 
> 
> Why would I want to do this? Well, I have a set of databases and tables on the
> old installations that have grown over the years. Given the way I work, the
> simplest thing would be install the new database and then work through my
> existing tables over a number of weeks and transfer stuff as I go along.   
> That
> may not be very professional but it works for me, and it would let me keep the
> old along the new, just in case something goes wrong/
> 
> My friends tell me to use sqlite, and they are probably right since file
> management is so much simpler. But I find the many builtin functions of MySQL
> very helpful and don't particularly want to learn a new set.
> 
> Martin Mueller
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql

-- 
Unhappiness is discouraged and will be corrected with kitten pictures.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql