Re: characters oddity

If you insert new records (or update existing) containing correct UTF-8 data to the production database using a mysql client, does the data save correctly? Could it be your data source for the production database has/is incorrectly handling the charset prior to the data being stored in the

Re: dump, drop database then merge/aggregate

or whatever ingest it, allowing for your business logic for data validate/etc to be done in code (IMO where it belongs). S On Mon, Feb 29, 2016 at 12:12 PM, lejeczek <pelj...@yahoo.co.uk> wrote: > On 29/02/16 16:32, Steven Siebert wrote: > >> What level of control do you have

Re: dump, drop database then merge/aggregate

Totally with you, I had to get up and wash my hands after writing such filth =) On Mon, Feb 29, 2016 at 12:14 PM, Gary Smith <li...@l33t-d00d.co.uk> wrote: > On 29/02/2016 16:32, Steven Siebert wrote: > >> >> At risk of giving you too much rope to hang yourself: if you

Re: dump, drop database then merge/aggregate

What level of control do you have on the remote end that is collecting/dumping the data? Can you specify the command/arguments on how to dump? Is it possible to turn on binary logging and manually ship the logs rather than shipping the dump, effectively manually doing replication? I agree with

Re: can I just encrypt tables? what about the app?

Simple answer is no. What are you trying to accomplish? S On Mon, Feb 29, 2016 at 8:31 AM, lejeczek wrote: > hi everybody > > a novice type of question - having a php + mysql, can one just encrypt > (internally in mysql) tables and php will be fine? > If not, would it be

Re: mysql\innodb_table_stats.ibd. Cannot open tablespace

The error is stating that your innodb log sequence is higher that that of the actual data files...any chance your data partition is full after your restore? On Fri, Jan 22, 2016 at 3:23 PM, Neil Tompkins wrote: > Hi, > > Hoping someone can help me identify why I

Re: XML to RDB

: Larry Martell larry.mart...@gmail.com To: Steven Siebert smsi...@gmail.com Cc: mysql mailing list mysql@lists.mysql.com Sent: Friday, 22 November, 2013 3:17:44 PM Subject: Re: XML to RDB Yes, I will need to query the data, and yes, it's app specific to the data. The parent-node

Re: XML to RDB

Hi Larry, I'm trying to figure out what your wanting to do with the data once its in mysql? At first it seemed you didn't want to put it in as a lob because you might want to query on the data in different ways (kind of an assumption on my part, but a common reason to do this). Then, you

Re: Session ID Generation

12:48, Steven Siebert wrote: You stated these IDs are sequential...do you know if there is any way to modify this to utilize a random generation? Sequential session IDs are an avenue to session hijacking. as a MySQL client session is bound to a specific TCP connection ... how would being

Re: Session ID Generation

On Fri, Jun 21, 2013 at 7:58 AM, Denis Jedig d...@syneticon.net wrote: Steven, Am 21.06.2013 13:35, schrieb Steven Siebert: If the TCP connection is lost...is the effectively session over and can not be re-established on another socket? Yes. In a mysql client sense, I would need

Re: Session ID Generation

suspect, however, that you're looking for session IDs as used by websites -generation of those is entirely not a mysql issue, it is only a potential store for them. Steven Siebert smsi...@gmail.com wrote: Hello all, I've looked though, what I believe to be, the relevant areas in the MySQL

Session ID Generation

Hello all, I've looked though, what I believe to be, the relevant areas in the MySQL docs as well as standard search engine searches without luck. I was hoping to find some documentation that would tell me: - how MySQL session Ids are generated (specifically, are they considered random) -