/data/tmp on database server?

Posted by Mellon on Server Fault See other posts from Server Fault or by Mellon
Published on 2011-11-30T16:58:55Z Indexed on 2011/11/30 17:58 UTC
Read the original article Hit count: 244

Filed under:
|
|
|
|

I am on a Linux ubuntu machine with MySQL installed.

My teacher gave out an assignment which mentioned "copy cars.dat to /data/tmp on the MySQL database server" without any explanations, I do not know what is the "/data/tmp on database server" means exactly?

Basically after that I need to execute SQL statement like

LOAD DATA INFILE '/data/tmp/cars.dat' INTO TABLE cars

So, what does copy cars.dat to /data/tmp on the database server means as there is no /data/tmp directory even?

Personally, I checked /etc/mysql/my.cnf file, inside which there are definitions of :

...
basedir     = /usr
datadir     = /var/lib/mysql
tmpdir      = /tmp
...

Does it mean to copy cars.dat to the tmpdir which is just /tmp under root directory??

© Server Fault or respective owner

Related posts about linux

Related posts about ubuntu