Bug #62494 mysqldbimport fails to import Sakila database
Submitted: 21 Sep 2011 19:42 Modified: 6 Aug 2013 5:47
Reporter: Sergio Andres De La Cruz Rodriguez Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Utilities Severity:S3 (Non-critical)
Version:trunk OS:Linux (Ubuntu 11.04)
Assigned to: CPU Architecture:Any

[21 Sep 2011 19:42] Sergio Andres De La Cruz Rodriguez
Description:
mysqldbimport fails to import Sakila database.

The following error is displayed:

ERROR: Invalid statement:
CREATE DATABASE `None`;

How to repeat:
- cd to the sakila uncompressed dir
- run mysqldbimport --server=root:password@localhost:3306:/tmp/mysql.sock sakila-schema.sql
[17 Oct 2011 18:19] Armando Lopez Valencia
Reproduced:
OS: Ubuntu 11.04x64
WB: 5.2.35 pre 22 rev 7907

Terminal:
armando@Ubuntu11:/media/sf_WorkBench/Packages/sakila-db$ mysqldbimport --server=armando:199112522@localhost:3306 sakila-schema.sql
# Source on localhost: ... connected.
# Importing definitions from sakila-schema.sql.
ERROR: Invalid statement:
CREATE DATABASE `None`;
[17 Oct 2011 18:20] Armando Lopez Valencia
File used.

Attachment: sakila-schema.sql (application/octet-stream, text), 22.53 KiB.

[6 Aug 2013 5:47] Philip Olson
Fixed as of MySQL Utilities 1.2.5/1.3.4, and here's the changelog entry:

For the "mysqldbimport" utility, delimiters and multi-line query
handling was fixed, which allows the Sakila sample database to be
imported.

Thank you for the bug report.