Hi,
i have a table which contains 10 millions records and i want to have full dump in outfile in CSV format. But there is error regarding disk full.
I am getting the following error
100206 4:13:13 [ERROR] /usr/libexec/mysqld: Incorrect key file for table ‘#sql_64e8_0.MYI’; try to repair it
100206 4:13:13 [ERROR] /usr/libexec/mysqld: Disk is full writing ‘/var/log/mysql/slonj157.016913’ (Errcode: 28). Waiting for someone to free space… Retry in 60 secs
100206 4:23:23 [ERROR] /usr/libexec/mysqld: Incorrect key file for table ‘#sql_64e8_0.MYI’; try to repair it
100206 4:23:23 [ERROR] /usr/libexec/mysqld: Disk is full writing ‘/var/log/mysql/slonj157.016916’ (Errcode: 28). Waiting for someone to free space… Retry in 60 secs
I have used the below query to generate outfile
${MYSQL} -u$db_user -p$db_pass ${DATABASE} -Bse “set max_heap_table_size= 1073741824; set tmp_table_size= 1073741824;select
‘id’,‘asin’,‘title’,‘artist’,‘modified’,‘created’ union
select id,asin,title,artist,modified,created from table_name INTO OUTFILE "/tmp/table_name.csv" FIELDS TERMINATED BY "^~"
OPTIONALLY ENCLOSED BY ‘"’ LINES TERMINATED BY ‘\n’;”
As tmp size is only 512MB i have set 1Gb in session.So why i am getting this error? There is more than 24 GB space in / folder.
Thanks In advance.
Fedora