I was tried to restore the CSV file into one of my table, however i face the following error
ERROR 13 (HY000): Can't get stat of '/mnt/sharing/<file>.csv' (Errcode: 13)
Follow the following solution to solve your issue,
1. move the file into a location where your "mysql" user have the permission to read and write
2. in your mysql shell ( after you had login MySQL server via mysql client )
e.g:
mysql > load data local infile '/tmp/success_20111201.csv' into table `nplay_temp`.`sms_out_message` fields terminated by '\t' optionally enclosed by '"' lines terminated by '\n' (`id`, `nplay_user_id`, `price`, `is_ucs`, `creation_date`, `last_modified`, `wappush_link`, `retry_count`, `msisdn`, `message`, `delivered_time`, `state`, `mcc`, `operator_code`, `service_name`, `action`, `ticket_id`, `scheduled_time`, `short_code`, `charge_msisdn`, `meta_data`)
No comments:
Post a Comment