Re: Data truncated during character set conversion

2006-07-04 Thread Timur Izhbulatov
On Tue, Jul 04, 2006 at 01:55:30PM +0400, Timur Izhbulatov wrote: > After some additional investigations I found the cause. It was some "exotic" > non-ASCII characters like '–' (long dash). At the same time Russian letters > don't cause any problems. Sorry, I wa

Re: Data truncated during character set conversion

2006-07-04 Thread Timur Izhbulatov
On Mon, Jul 03, 2006 at 01:55:26PM +0400, Timur Izhbulatov wrote: > I'm following the instructions [1] to convert character set. Unfortunately I > get > warnings about truncated data for some rows in several columns. All the > truncated columns are text type. > > Assum

Data truncated during character set conversion

2006-07-03 Thread Timur Izhbulatov
data types (LONGBLOB/LONGTEXT) but wasn't successful. So my question is what can be the cause of the data loss and how to avoid it? Thanks in advance. [1] http://dev.mysql.com/doc/refman/4.1/en/charset-conversion.html Cheers, -- Timur Izhbulatov OILspace, 26 Leninskaya sloboda, bld. 2, 2nd floor

Re: Recommended backup scripts for mysql databases

2006-06-27 Thread Timur Izhbulatov
R} -type f -mtime +64 | xargs rm -f # Create new archives cd ${ARCHDIR} && mysqldump ${MYSQL} ${MYSQL_ARGS} > ${NAME}.`date +%Y%m%d` Cheers, -- Timur Izhbulatov OILspace, 26 Leninskaya sloboda, bld. 2, 2nd floor, 115280 Moscow, Russia P:+7 495 105 7245 + ext.205 F:+7 495 105 7246