I wish I would have discovered this long ago. Loading data into R or MySQL requires you to specify the full path to the file. If you do this on a Windows machine there are two annoyances. First, if you save something to your desktop the path to your desktop is really long. Second, windows by default uses backslashes “\” in the file path, while R or other software requires forward slashes “/”.