Cayce CookBook - LogMeIn Setups & Protocols

Procedure for uploading a CSV into phpMyAdmin:

1: Go to ‘Choose File’ and locate your new data CSV file.

2: Select ‘CSV using LOAD DATA’ option.

3: In the ‘Fields terminated by...’ box, the default character is a semi-colon. That needs to be replaced by a comma.

4: In the ‘Lines terminated by...’ box, the default is ‘Auto’: That needs to have a backslash-r inserted (\r), as shown.

5: Click the ‘Go’ button.