Hi all,
We have some problem with IB when using select outfile into mount folder, look like:
From Data warehouse server:
SET @bh_dataformat = 'txt_variable';
SELECT campaign, domain, B.locationID, COUNT(*)`click`
FROM clicks0410 AS A LEFT JOIN `ip2location_bh` AS B ON A.`ip` = B.`ip`
WHERE timecreate BETWEEN '2010-07-21 12:00:00' AND '2010-07-21 12:09:59'
GROUP BY campaign, domain, B.locationID
ORDER BY campaign, domain, B.locationID
INTO OUTFILE '/vnfs/share129/mysqldata/103_click.out'
FIELDS TERMINATED BY ',' ENCLOSED BY 'NULL';
From MySQL client:
LOAD DATA INFILE '/data/share/mysqldata/103_click.out'
INTO TABLE 102_temp_click_cam_ban_location FIELDS TERMINATED BY ',';
and when i ran the script load into table, the error occurred :
The file ‘/data/share/mysqldata/103_click.out’ must be in the database directory or be readable by all
while i set full permission for my MySQL account. And the local folder on MySQL client: ‘/data/share/mysqldata/’ was map with the share name: ’/vnfs/share129/mysqldata/’ on the remote Data warehouse.
Can anybody help me?
Thanks,
Thanh Nguyen.
