Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Import existing table #2742

Closed
winkmichael opened this issue Feb 27, 2017 · 5 comments

Comments

Projects
None yet
5 participants
@winkmichael
Copy link

commented Feb 27, 2017

Trying to run this command on creating a new table

- MySQL dump 10.13  Distrib 5.7.11, for Linux (x86_64)
--
-- Host: localhost    Database: database
-- ------------------------------------------------------
-- Server version       5.7.11

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

I get this error;

cat database.sql |  mysql -h 127.0.0.1 -P 4000 -u root
ERROR 1105 (HY000) at line 26: line 6 column 15 near "" (total length 140)

Line 6 is a blank line...

@shenli

This comment has been minimized.

Copy link
Member

commented Feb 27, 2017

@winkmichael Thanks for your feedback!
Could you send me the log of tidb-server?

@coocood

This comment has been minimized.

Copy link
Member

commented Feb 27, 2017

The sets statements missing a *, should be /*! instead of /!.

@winkmichael

This comment has been minimized.

Copy link
Author

commented Feb 28, 2017

File is produced by mysqldump

@coocood

This comment has been minimized.

Copy link
Member

commented Oct 13, 2017

@winkmichael
Sorry, I misunderstood your issue because the * is eaten by Markdown format.
I clicked edit button, then got the original text.

The error message line 6 is the line of a single statement, not the file.
So the statement that failed to parse is not included, probably it's the CREATE TABLE statement.

Do you still have that dump file?

@kolbe

This comment has been minimized.

Copy link
Contributor

commented Mar 15, 2019

@winkmichael we haven't heard anything from you on this issue in a long time, and we're unable to reproduce it without some more information, so I'm going to close it now. If you run into anything like this again, please open up a new issue and we'll be happy to take a look!

@kolbe kolbe closed this Mar 15, 2019

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.