October 9, 2011


MySQL Community Server

Get 64-bit MSI

2. Install
Setup Type = Custom
choose only MySQL Server > Client Programs
Launch the MySQL Instance Configuration Wizard = Yes

MySQL Server Instance Configuration
Standard Configuration
Install As Windows Service = Yes
Launch the MySQL Server automatically = No
Include Bin Directory in Windows PATH = No
Modify Security Settings = No

3. Install HeidiSQL

4. Create new session MySQL
User = root
Compressed client/server protocol = no

5. Export CSV
First row contains column names = no
Fields separated by = Pipe
Fields enclosed by = None

6. Import CSV
Ignore first lines = 0
Fields terminated by = (Pipe)
Fields enclosed by = (nothing)
optionally = no
Fields escaped by = (nothing)
Lines terminated by = \n


No comments:

Post a Comment