> >Isn't this what the --hex-blob option to mysqldump is for?
>
> There is no such option to mysqldump in version 4.1.11.
>
>From the manual:
--hex-blob
Dump binary string columns using hexadecimal notation (for example,
'abc' becomes 0x616263). The affected columns are BINARY, VARBINARY,
and B
>> We did a mysqldump to produce a transport file
>> from version 3 of mysql to insert the data into version 4 of mysql.
>> The encoded numbers were munged, presumably because they were
>> binary data in the dump.
>Isn't this what the --hex-blob option to mysqldump is for?
There is no such opti
> We did a mysqldump to produce a transport file
> from version 3 of mysql to insert the data into version 4 of mysql.
> The encoded numbers were munged, presumably because they were
> binary data in the dump.
Isn't this what the --hex-blob option to mysqldump is for?
--
MySQL General Mailing L
We found, to our chagrin, that a dump of an encoded field does not
restore properly in all cases.
Specifically, we use encode() to code credit card numbers before inserting
them in the database. We did a mysqldump to produce a transport file
from version 3 of mysql to insert the data into version
Hello.
> I've run a safe recover on a table after I had to recreate the index file:
If you had to recreate the index file after upgrading, this could be a
character set issue. I mean that data is ok, but you see it after converting
to another character set. myisamchk in this case doesn't ha
08 4259 - Fax
-Original Message-
From: J S [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 18 January 2005 6:32 AM
To: mysql@lists.mysql.com
Subject: RE: lost data
Just reposting in case anyone missed it! Or have I asked a dumb
question?!
>Hi,
>
>I've run a safe recover on a tab
Just reposting in case anyone missed it! Or have I asked a dumb question?!
Hi,
I've run a safe recover on a table after I had to recreate the index file:
# myisamchk --tmpdir=/proxydb/mysql/tmp --safe-recover internet_usage
- recovering (with keycache) MyISAM-table 'internet_usage'
Data records: 29
Hi,
I've run a safe recover on a table after I had to recreate the index file:
# myisamchk --tmpdir=/proxydb/mysql/tmp --safe-recover internet_usage
- recovering (with keycache) MyISAM-table 'internet_usage'
Data records: 290804216
Data records: 519541696
#
After that I ran a query on the table, bu
>Description:
mysqlhotcopy (but possible any other software) can cause delayed
handlers to terminate with "Delayed insert thread couldn't get requested
lock for "
I havent worked out the exact conditions under wich mysqlhotcopy
fails, but it seems that if mysqlhotcopy tries to get a lock
We used your MYSQl graphical utility, selected a few lines for
deletion and it emptied our table completely. Tried to restore, tried
using myisamchk to no avail. Can see data in the .MYD file, but
records must be marked for deletion because cannot recover the data.
Need help to get this data bac
I am assuming that you do not have logging turned on.
-Original Message-
From: Jude DaShiell [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 03, 2003 7:04 AM
To: peter a
Cc: [EMAIL PROTECTED]
Subject: Re: restoring lost data
If it's lost, it's lost. But that's not
Peter,
MySQL stores all updates that modify, insert or delete the database in a
transaction log file, as long as the option is turned on, it is by
default in some cases. The newer versions of MySQL use a binary log,
often stored in the the data directory and named like "hostname".001,
.002, e
Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "peter a" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 03, 2003 9:28 AM
Subject: restoring lost data
>
>
> this may seem as a desperate questions, but is
uch an approach necessary in that application which is why I know
about it. Live and learn.On Mon, 3 Feb 2003, peter a wrote:
> Date: Mon, 3 Feb 2003 09:28:11 +0100 (CET)
> From: peter a <[EMAIL PROTECTED]>
> Reply-To: peter a <[EMAIL PROTECTED]>
> To: [EMAIL PR
this may seem as a desperate questions, but is there anway to restore
deleted data from a table? Is there any logs of the database commmands
that for example sql-servere has, that can be used to rollback to the a
specific time and in that way restore the old content of a database.
I was pretty s
mysql,query
Hello, I am posting it again.
I have installed mysql4.0.8 replacing mysql4.0.3
I just copied all the database files in the *data* folder of mysql4.0.3 &
then copied the same to the *data* folder of mysql408.
I suppose something happened and have got only the
Hi all,
Some days ago (March 11) permissions were broken in catalogue of the
mySQL database. Even though the permissions were not correct any more,
MySQL continued to work. We think MySQL started to work with cache (with
image of tables in RAM...) instead and all this time our backup system
made
>Description:
Users enter data from a php based web site and receive no errors
or warnings of any kind that something is amiss, but the data isn't
entered into the tables. When I go to the mysql command line and run
commands i get a table handler error.
>How-To-Repeat:
this happen
29, 2002 5:45 PM
To: Matthew Walker; Scott Wang; [EMAIL PROTECTED]
Subject: Re: Lost Data #2
If I run optimize on the table once - will I have to come back and so it
again?
If so - how often?
Thanks
Mark
-Original Message-
From: Matthew Walker <[EMAIL PROTECTED]>
To: Mark Str
MAIL PROTECTED]>
Date: Tuesday, January 29, 2002 4:18 PM
Subject: RE: Lost Data #2
>To get rid of overhead, run an OPTIMIZE TABLE on the table.
>
>Matthew Walker
>Ecommerce Project Manager
>Mountain Top Herbs
>
>
>-Original Message-
>From: Mark Stringham [m
To get rid of overhead, run an OPTIMIZE TABLE on the table.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Mark Stringham [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 11:02 AM
To: Scott Wang; [EMAIL PROTECTED]
Subject: Re: Lost Data
Mark
-Original Message-
From: Scott Wang <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Tuesday, January 29, 2002 10:35 AM
Subject: Lost Data #2
>
>{ Am I to assume there is no solution to my problem? }
>
>Greetings,
>
>I have two lar
{ Am I to assume there is no solution to my problem? }
Greetings,
I have two large tables in a database with a few million entries. There is only one
column in each table.
Everything was working okay until today. The size of the table files is 1gb+ but
PHPMyAdmin says it has no records.
Greetings,
Forgive me for butting in but I'm having a tragic problem with MySQL and could really
use some help.
I have two large tables in a database with a few million entries. There is only one
column in each table.
Everything was working okay until today. The size of the table files is
24 matches
Mail list logo