October 9, 2011

MySQL

MySQL Community Server
mysql.com

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
heidisql.com

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

References:
builderau.com.au/program/php/soa/Install-configure-and-integrate-PHP-and-MySQL-on-Windows/0,339028448,339271632-2,00.htm

No comments:

Post a Comment