Mysql with 10.2 dump
 

Anyone help me loading the mysqldump on Man10.2 on amd64?

I run the mysqldump from a 10.1 based machine, on a new machine with the latest mysql shipped with 10.2.

when I run the mysqldump to load the last dump I get the undermentioned output on the monitor

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

No tables are loaded and the database says empty set.

Does anyone know what is the problem or have I to load an older mysql?

:Pengy: :Pengy: :Pengy: :Pengy:

Are you running a 64bit or 32bit distro? It could be an issue with the size used to store the characters. Other than that I dunno too much about the different modes and character sets you can use with MySQL, but that might be causing those errors from the looks of them.

Btw ditch that no. from your sig.

It is a 64 bit distro and the mysqldump was taken from a 10.1 MDK 32 bit machine.

Anyway, to modify it to work on the 64 bit machine?

:Pengy: :Pengy: :Pengy: