After much trial and error I've found that there is a record in the biblioitems table that is keeping me from backing up this table. The offending record is 35429. If I "split" the table using the limit function and mysqldump, I can backup records 1 to 35428 and records 35430 to the end of the database. Using mysqldump, I want to backup these two parts of the biblotable to a csv file then create a new table and import the 2 files back into new table. Then I can rename the old biblioitems table and rename the new table to biblioitems. Dump partial table to csv file: mysqldump -uroot -pxxxxxxx koha biblioitems --where=”1 limit 35428” --tab=”.” -- fields-enclosed-by=“” --fields-terminated-by=”,” --line terminnated by="/n" What should I set the cvs parameters to? -- fields-enclosed-by=--fields-terminated-by=--lines-terminnated by= --fields-escaped-by= Should I use this: --fields-optionally-enclosed-by=char instead of --fields-enclosed-by=char Any information would be appreciated. I've tried Thanks, Phillip