Import from textfile

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
ordnance1
Posts: 7
Joined: Tue 18 Nov 2014 19:11

Import from textfile

Post by ordnance1 » Fri 05 Dec 2014 18:42

I have a text file that currently has about 500,000 lines of data. Is it possible to limit my import to the last 10,000 rows of data?

alexa

Re: Import from textfile

Post by alexa » Mon 08 Dec 2014 11:27

Please perform the following:

1. Invoke the data import wizard.
2. On the 'Source file' page of the wizard, select the 'Text' import format.
3. On the 'Options' page, specify 490,000 in the 'Skip lines:' field.

ordnance1
Posts: 7
Joined: Tue 18 Nov 2014 19:11

Re: Import from textfile

Post by ordnance1 » Thu 11 Dec 2014 22:54

Thanks for the answer

Post Reply