/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: 270
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