Got a very strange situation, where I receive two similar DELETE
statement in the same binary log position, due to which replication slave
is stopped due to following error:
Could not execute DELETE rows event on table db1.xyz.; Can't find record in
'xyz' , error code:1032.
Hi,
I want to install MySQL ODBC Connector 5.2.5 on AIX 7.1 platform. But I cannot
find any binary for installation on AIX platform. In addition, I also tried to
build my own installation binary from source code , but found no source code
for AIX platform.
http://downloads.mysql.com/archives/c
5 instance)?
2013/7/4 Machiel Richards - Gmail
> Hi,
>
> in short what we did was the following:
>
> - binary logs was written to a 20GB filesystem and due to company
> policies we kept expire logs at 7 days.
> - system got quite busy over the years so the space was b
pire_logs_days.
5.0 -- I don't think anything relevant has changed during 4.0 thru 5.6.
> -Original Message-
> From: Machiel Richards - Gmail [mailto:machiel.richa...@gmail.com]
> Sent: Wednesday, July 03, 2013 3:20 AM
> To: mysql list
> Subject: Master not creating n
Hi,
in short what we did was the following:
- binary logs was written to a 20GB filesystem and due to company
policies we kept expire logs at 7 days.
- system got quite busy over the years so the space was becoming a
problem and thus we had to move to another directory
be done the replication needs
to be up and running.
The problem we have currently however is that the binary logs on
the master was moved to a seperate partition due to disc space restrictions.
A new binlog file called mysql-bin.1 was created and everything
seemed to work fine
may indicate a
brief delay.
> -Original Message-
> From: Mihamina Rakotomandimby [mailto:miham...@rktmb.org]
> Sent: Monday, June 17, 2013 5:35 AM
> To: mysql@lists.mysql.com
> Subject: Re: SLAVE aware of binary log file switch?
>
> On 2013-06-17 14:43, Denis Jedig w
On 2013-06-17 14:43, Denis Jedig wrote:
Say the binary log file (on the master) has reached its maximum
size, so that it has to switch to a "+1" binary log file: does he
inform the SLAVE of that switch so that the SLAVE updates its
information about the MASTER status?
The master does n
Hi all,
Given a MASTER and a SLAVE.
When launching the SLAVE, it knows about the binary log file used by the
MASTER and the position in that log file.
Say the binary log file (on the master) has reached its maximum size, so
that it has to switch to a "+1" binary log file: does he
Am 17.06.2013 13:11, schrieb Mihamina Rakotomandimby:
Say the binary log file (on the master) has reached its maximum
size, so that it has to switch to a "+1" binary log file: does he
inform the SLAVE of that switch so that the SLAVE updates its
information about the MASTER status?
present any problem.
Cheers
Claudio
2012/4/17 Halász Sándor
> In the command "show binary logs" one may indifferently write "binary" or
> "master", and it is so for some other commands associated with this
> function--but for the command "sho
In the command "show binary logs" one may indifferently write "binary" or
"master", and it is so for some other commands associated with this
function--but for the command "show master status" there is no such variant.
Why? Is it considered obsolescent?
:
I noticed that there is no binary builds for AIX any more.
What would be the best way to install a current version of MySQL
(5.5) on AIX?
Specifically I am looking for instructions for AIX 6.1 and/or 7.1
Thanks,
Peter
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
AIX since 4.1.
re,
wh
Am 09.09.2011 17:22, schrieb Peter Gershkovich:
> I noticed that there is no binary builds for AIX any more.
> What would be the best way to install a current version of MySQL (5.5) on
> AIX?
> Specifically I am looking for instructions for AIX 6.1 and/or 7
I noticed that there is no binary builds for AIX any more.
What would be the best way to install a current version of MySQL (5.5) on AIX?
Specifically I am looking for instructions for AIX 6.1 and/or 7.1
Thanks,
Peter
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
On Sep 17, 2010, at 7:08 AM, Tompkins Neil wrote:
> Hi
>
> Why when I run the command (MySQL 5.1) SELECT SHA1('abc'); is it returned as
> a binary value and not a string value ?
If you mean, why is it a binary rather than a nonbinary (character) string,
that's tru
Use UNHEX(SHA1('abc')) to get the string value
On Sep 17, 2010, at 5:38 PM, Tompkins Neil wrote:
> Hi
>
> Why when I run the command (MySQL 5.1) SELECT SHA1('abc'); is it returned as
> a binary value and not a string value ?
>
> Cheers
> Neil
--
MyS
Hi
Why when I run the command (MySQL 5.1) SELECT SHA1('abc'); is it returned as
a binary value and not a string value ?
Cheers
Neil
Hi,
I'm finding the description of character_set_connection unclear. Does
this influence the encoding of queries, but not of results? I'm
wondering about the effect of connection encoding.
Is there documentation on how exactly character set settings affect
BLOBs? For example, "this is what
I tried to look at the binary logs by using phpMyAdmin, but got an error:
SQL error:
SHOW BINLOG EVENTS LIMIT 0, 30;
MySQL said:
#1220 - Error when executing command SHOW BINLOG EVENTS: Wrong offset or I/O
error.
From the error-file:
100111 16:15:40 [ERROR] Error in Log_event::read_log_event
Binary logs are pretty important for backups as well. Most often people take a
full backup using mysqldump or filesystem snapshots, and then back up their
binlogs. With the full backup + all the binlogs since then, you can recover to
any point in time you choose.
If you're not curr
Yes, your settings will be fine. If you were already supporting
slaves which might remain dis-connected for extended periods of time,
you would have to take that into account when setting the purge
interval.
You don't need current binary logs for future slaves. You new slave
will start w
Silly me sees that there is an 'expire_log_days' in the my.cnf
But again, if i was to purge everything but the last day or 2... running
this command i found:
PURGE BINARY LOGS BEFORE DATE_SUB(NOW(), INTERVAL 2 DAY);
>From the MySQL command line, will this be ok?
Steve.
-Ori
Good afternoon.
I am having a weird problem with the Binary Logging of my MySQL.
For some reason, we have it on (still not sure why) but when i look in the
/var/log/mysql/ folder, the oldest file is from the 2009-12-27. The MySQL
service has not been restarted since the server came back up 150
` =
0x41A161E6CEAC902311B2357792F6076A3CEA85FA9B0B071A77289FC450D7092E LIMIT 1
token_id is defines as: binary(32)
I also tried it a char(32) with the same results
Any insight on why this is happening?
/* Connect to database */
if (!mysql_real_connect(conn, db_host,
db_user, db_password, db_name, 0, NULL, 0)) {
/* log
Hi Sagar,
You must use Intel EM64T
Thanks,
Krishna
On Sat, Oct 31, 2009 at 5:45 AM, Sanjeev Sagar <
sanjeev.sa...@mypointscorp.com> wrote:
> Hello Everyone,
>
> I would like to verify that which mysql 64 bit binary i need to use for
> PowerEdge 1950 ?
>
>
bit binary i need to use
for PowerEdge 1950 ?
Will it be *IntelEM64T* ?
Following is the cpu info
Processor 1
Processor Brand: Intel(R) Xeon(R) CPU E5310 @
1.60GHz
Processor Version : Model 15 Stepping 11
Voltage: 1400 mV
Processor 2
Is there anyone, who is using the mysql 64 bit on Intel(R) Xeon(R) CPU
processors? Will it be *IntelEM64T* ?
Regards,
Sanjeev Sagar wrote:
Hello Everyone,
I would like to verify that which mysql 64 bit binary i need to use
for PowerEdge 1950 ?
Will it be *IntelEM64T* ?
Following is the
Hello Everyone,
I would like to verify that which mysql 64 bit binary i need to use for
PowerEdge 1950 ?
Will it be *IntelEM64T* ?
Following is the cpu info
Processor 1
Processor Brand: Intel(R) Xeon(R) CPU E5310 @ 1.60GHz
Processor Version : Model 15
Hi,
First off, you have to forgive my ignorance, I'm not very savvy with
DBs so I hope that I explain myself correctly.
I have an anomaly on a development system. There are several fields
with the type set as bigint(20) that are meant to store a bit pattern.
The pattern is used to determine count
All
Lately I am struggling with big tables maintenance,
I've just made a very quick and dirty tool for having summaries from the
binary log files,
like how many times a table was updated, or inserted or deleted.
Before going any further I would really appreciate your opinion to know if
All
Lately I am struggling with big tables maintenance,
I've just made a very quick and dirty tool for having summaries from the
binary log files,
like how many times a table was updated, or inserted or deleted.
Before going any further I would really appreciate your opinion to know if
ase.utf8.sql $ iconv
>> -f latin1 -t utf8 mydatabase.utf8.sql > mydatabase.utf8.sql $ echo "SET
>> NAMES utf8;" > tmp.sql
>> $ cat mydatabase.utf8.sql >> tmp.sql
>> $ mv tmp.sql mydatabase.utf8.sql
>>
>> I've one question :
&
"SET NAMES utf8;" > tmp.sql
> $ cat mydatabase.utf8.sql >> tmp.sql
> $ mv tmp.sql mydatabase.utf8.sql
>
> I've one question :
>
> * if my database have some blob field with binary data (like image...),
> iconv convert also this data then this data will be
I've break line misteak in my previous message, this is the fix :
$ mysqldump --user=root --password=password --host=mybox mydatabase --
default-character-set=latin1 > mydatabase.latin1.sql$ mysqldump --
user=root --password=password --host=mybox mydatabase
--default-character- set=latin1 > mydata
#x27;ve one question :
* if my database have some blob field with binary data (like image...),
iconv convert also this data then this data will be corrupted ?
Thanks for your information,
Stephane
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
Shaun,
Purge master logs is available in 4.0 it just doesn't have the
"before" key word. It should be trivial to write a script that decides
which log file to purge based on the mtime.
-Eric
On Thu, Jul 10, 2008 at 12:15 PM, Shaun Adams <[EMAIL PROTECTED]> wrote:
> I'm running a RHEL 4.1 and MyS
I'm running a RHEL 4.1 and MySQL 4.0.26
so a lot or the more recent commands available in 5.0.x aren't available to
me. Does anyone know of any scripts or anything I can use to delete files
that arent being used or run by my slave servers? It's pretty safe to say
that I can delete log files o
You can add this condition in the configuration file if you didn't find
other way to solve this.
expire_logs_per_day = 4
On Tue, May 20, 2008 at 12:14 AM, Todd Lyons <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Sun, May 18, 2008 at 01:02:32PM +0530, Ananda K
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sun, May 18, 2008 at 01:02:32PM +0530, Ananda Kumar wrote:
>I want to purge bin logs which are older than 4 days. I want to keep 4 days
>of bin logs so that in the event of any data issue, i can restore it from
>bin logs. So, i tired to use
>
>PURG
s
regards
anandkl
On 5/17/08, Juan Eduardo Moreno <[EMAIL PROTECTED]> wrote:
>
> Ananda,
>
> Use, PURGE MASTER LOGS TO 'name of the last binary that you want leave in
> your disk';
>
> Regards
>
> On Sat, May 17, 2008 at 8:56 AM, Ananda Kumar <[EMAIL
Ananda,
Use, PURGE MASTER LOGS TO 'name of the last binary that you want leave in
your disk';
Regards
On Sat, May 17, 2008 at 8:56 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> Hi All,
> I using this command to purge binary logs on master, but i dont see the
> bi
Hi All,
I using this command to purge binary logs on master, but i dont see the
binary logs getting deleted. These binary logs are listed in index file.
I am using mysql version 5.0.41 community version. Can you please let me
know if any thing else need to be done for this to work.
log-bin is
On 06.03.2008 15:15 CE(S)T, Paul DuBois wrote:
Here's some advice from Alexander Barkov:
You might be able to use a particular collation to achieve what you want.
For example, latin1_general_ci.
You can take a look at its collation chart here:
http://www.collation-charts.org/mysql60/mysql604.lat
On 03.03.2008 23:17 CE(S)T, Anders Karlsson wrote:
And you are right of course, you may use the COLLATE keyword also,
to enforce a certain collation, although if you want BINARY, I think
using BINARY might be slightly more effective.
I was also considering compatibility with other DBMS
Yves!
OK. I agree I don't like this much myself, but we have to live with
the multi-lingual aspect of UNICODE. Or rather, we have to agree to be
either multi-lingual, and have the cons and pros of that (using
UNICODE), or ignore UNICODE and have binary collations etc. And
collation
yves
when creating a varchar field in table creation, use the binary.
that way, selection is exact. always.
david
-Original Message-
From: Yves Goergen [mailto:[EMAIL PROTECTED]
Sent: Monday, March 03, 2008 1:44 PM
To: Anders Karlsson
Cc: MySQL
Subject: Re: Unicode sorting and binary
On 03.03.2008 10:27 CE(S)T, Anders Karlsson wrote:
> [a lot about why sorting unicode is complicated]
If you want to
accknowledge exact matching, and say any character, accented / unlauted
etc, is different from any other character, specifiy a binary comparison:
SELECT * FROM phonebook WH
onebook for
non-swedish people.
As for comparisons, the issue is the same. You don't know, assuming
the phonebook problem above, if someone looking for a person in the book
is French, when accented characters should be properly compared, or
swedish, when they are to be ignored. The solutio
Hello,
I've just read through the MySQL documentation about Unicode support,
collations and how it affects sorting and comparison of strings. And I
find it horrible, at least. I feel like I'm back in the MySQL 3.x days
where I used UTF-8 in my application and MySQL treated it b
Hi,
Do you know an approximate date ?
Thanks,
Mariella
--- Sergei Golubchik <[EMAIL PROTECTED]> wrote:
> Hi!
>
> On Feb 14, Mariella Petrini wrote:
> > Hi All,
> >
> > Is there any plan to release a binary version for
> > mysql-5.1.23-mari
Hi!
On Feb 14, Mariella Petrini wrote:
> Hi All,
>
> Is there any plan to release a binary version for
> mysql-5.1.23-maria-alpha for Linux 64 for AMD ?
Yes.
Regards / Mit vielen Grüssen,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[
Hi All,
Is there any plan to release a binary version for
mysql-5.1.23-maria-alpha for Linux 64 for AMD ?
Thanks in advance for your help,
Mariella
Looking for last minute shopping deals?
Find them
All,
InnoDB and MyISAM tables are platform independent, is there a reason
why transferring the actual binary files from one system (or mount
point) is not advised? From like OS to like OS, this seems like it
should be okay and you'll only get into trouble with Float/Double.
Looking for the OS X 4.1 binary package installer, I can not seem to locate
this on the site, I just find a source style, and a tar style. I am pretty
sure in the past, I was able to have a double clickable installer, and it
had a preference pane for starting and stopping the service
I'm running mysql-5.0.46 on a linux system on a VPS. As such, the yum package
manager is being used to install a standardized mysql installation, and I due to
other system dependencies, I can't change this.
I need a second mysql installation on that machine that runs under a completely
different
We have had some cases where we wanted to recover data using the binlogs
from some days ago. The database has a lot of binary objects (blobs).
The normal way to recover are to restore database files from a
consistant point, and then use mysqlbinlog to spool from that point till
where we want to
database
while dumping, is it strictly neccessary (see [Confusion] block)?
I am trying to devise a backup plan for MySQL ISAM Databases, I have chosen
to use binary logs to enable incremental an incremental backup plan.
I need to eliminate possibility of data being lost, and assure integrity of
data, I
Hi,
As my mysql command line utility aborts when searching for certain
characters in a binary field (it affects bash as well), I decided to
convert these characters via CHAR(character) instead, like this:
select binary_column from my_table where binary_column like CONCAT
(CHAR(3),&#x
Guys,
I would like to know if there is a way to have individual databases
under the same instance or server write to separate binary log
files. The idea is to have multiple binary log file for each
database on the same server. The problem that I experiencing is
sorting through the binary
For disaster recovery, it's good to have copies of your database dumps
that you can easily & conveniently access, that are outside the data
center where the database lives. Since we do a weekly full dump and
use binary logs for "incrementals", I also wanted copies of our bina
a full mysqldump with --flush-logs --master-data=2
>>> - do a bunch of stuff that writes data
>>> - drop the database, and recreate it, flushing the log
>>> - make a copy of the binary log made since the mysqldump
>>> - import the mysqldump I made locally
>
data=2
> > - do a bunch of stuff that writes data
> > - drop the database, and recreate it, flushing the log
> > - make a copy of the binary log made since the mysqldump
> > - import the mysqldump I made locally
> > => now I have all data correctly restored up t
Ofer Inbar a écrit :
> I'm trying to set up MySQL backup & restore using mysqldump and binary
> logs, so we can run mysqldump infrequently and use binary logs for the
> daily backups (because mysqldump makes the production database unusable
> for too long a time to run every
I'm trying to set up MySQL backup & restore using mysqldump and binary
logs, so we can run mysqldump infrequently and use binary logs for the
daily backups (because mysqldump makes the production database unusable
for too long a time to run every night).
- I can make full dumps using
> hehe, well said and sorry for the top-posting.
> I can only agree, both methods have their merits! :)
>
> Alec
Seems I started quite a debate ;)
I wanted to thank you all again for your opinion and for planting a new seed
of doubt on which direction I'll go ;)
I setup the db as proposed earlier
Kevin Hunter wrote:
Grrr. All you lazy top-posters! ;) It seems to me that a case can
be legitimately made for both methods of handling BLOBs. On the one
hand, where speed and/or efficiency (on many different levels) are the
top priorities, it'd be good to keep the DB as trim as possible.
orks great.
On Wed, 7 Mar 2007, Ed wrote:
On Wednesday 07 March 2007 21:26, Alexander Lind wrote:
I would put the pdf as a regular file on the hd, and store the path to
it in the db.
Meta data could be things like the size of the pdf, author, owner,
number of pages etc.
Storing binar
gt; On Wed, 7 Mar 2007, Ed wrote:
> >
> >
> >> On Wednesday 07 March 2007 21:26, Alexander Lind wrote:
> >>
> >>> I would put the pdf as a regular file on the hd, and store the path to
> >>> it in the db.
> >>> Meta data cou
n Wednesday 07 March 2007 21:26, Alexander Lind wrote:
I would put the pdf as a regular file on the hd, and store the path to
it in the db.
Meta data could be things like the size of the pdf, author, owner,
number of pages etc.
Storing binary data from pdf:s or images or any other common binary
f, author, owner,
> > number of pages etc.
> >
> > Storing binary data from pdf:s or images or any other common binary
> > format is generally not a good idea.
> >
> > Alec
>
> Thank you all for your help. I get the gist of things... don't store the
>
Here's a great article on how to store pdf/whatever binary as blob chunks:
http://www.dreamwerx.net/phpforum/?id=1
On Wed, 7 Mar 2007, Jay Pipes wrote:
> Ed wrote:
> > Hi All,
> > I'm trying to figure out how to put a pdf file into a blob field.
> >
> >
On Wednesday 07 March 2007 21:26, Alexander Lind wrote:
> I would put the pdf as a regular file on the hd, and store the path to
> it in the db.
> Meta data could be things like the size of the pdf, author, owner,
> number of pages etc.
>
> Storing binary data from pdf:s or i
Ed wrote:
> On Wednesday 07 March 2007 19:28, Jay Pipes wrote:
>> Is there a specific reason you want to store this in a database? Why
>> not use the local (or networked) file system and simply store the
>> metadata about the PDF in the database?
>>
>> Cheers,
>>
>> Jay
>
> Hi Jay,
> Could you ex
i think he means you store only the name of the document
and the directory location of where it is located.
-Original Message-
>From: Ed <[EMAIL PROTECTED]>
>Sent: Mar 7, 2007 3:15 PM
>To: mysql@lists.mysql.com
>Subject: Re: binary into blob
>
>On Wednesday
I would put the pdf as a regular file on the hd, and store the path to
it in the db.
Meta data could be things like the size of the pdf, author, owner,
number of pages etc.
Storing binary data from pdf:s or images or any other common binary
format is generally not a good idea.
Alec
Ed
On Wednesday 07 March 2007 19:28, Jay Pipes wrote:
> Is there a specific reason you want to store this in a database? Why
> not use the local (or networked) file system and simply store the
> metadata about the PDF in the database?
>
> Cheers,
>
> Jay
Hi Jay,
Could you explain what you mean by me
On Wednesday 07 March 2007 19:28, Jay Pipes wrote:
> Ed wrote:
> > I guess a pdf file is a binnary file and it will contain characters that
> > will mess things up, so my question is:
> >
Hi, sorry for the late answer. The reason, until I come up with a better one,
is that I'm doing my own basic
Ed wrote:
Hi All,
I'm trying to figure out how to put a pdf file into a blob field.
I guess a pdf file is a binnary file and it will contain characters that will
mess things up, so my question is:
can it be done? Or better, how can it be done? ;)
Any pointers to documentation are a bonus!
Hi All,
I'm trying to figure out how to put a pdf file into a blob field.
I guess a pdf file is a binnary file and it will contain characters that will
mess things up, so my question is:
can it be done? Or better, how can it be done? ;)
Any pointers to documentation are a bonus!
Thanks all,
Hi All,
I have just posted the first binary distribution of the PrimeBase XT
storage engine for MySQL.
You can download the package from: http://www.primebase.com/xt
To install:
1. Unpack the .tar.gz package.
2. Start your MySQL server.
3. Execute: sudo ./install
The installer
27;ll see any better performance by making
your PK be this BINARY column, instead of just using an
auto_increment PK column and having a UNIQUE constraint on your
BINARY column. I doubt you'll see significantly worse performance by
doing it either.
-JF
On Nov 8, 2006, at 6:02 PM, Michae
On Wed, Nov 08, Jon Frisby wrote:
> On Nov 7, 2006, at 6:47 PM, Michael Fischer wrote:
>
> >
> > Any thoughts on using BINARY(N) or CHAR(N) as a primary key?
> >
> > Performance issues? In mysql, in general?
> >
> > Yes, in the context of the applic
I'm curious to know why simply having a UNIQUE constraint on the
column is inadequate...
-JF
On Nov 7, 2006, at 6:47 PM, Michael Fischer wrote:
Any thoughts on using BINARY(N) or CHAR(N) as a primary key?
Performance issues? In mysql, in general?
Yes, in the context of the applic
I suspect, from experimentation, that substr() is not binary safe,
in that if some part of the field contains an all-bits-zero byte,
it will "stop short".
What I wish to do is to pick out byte ranges of arbitrary length,
at an arbitary offset into a BINARY(N) column.
Perhaps LEFT()
Any thoughts on using BINARY(N) or CHAR(N) as a primary key?
Performance issues? In mysql, in general?
Yes, in the context of the application, there is a very good
reason for doing this, and not using an auto increment integer.
Michael
--
Michael Fischer Happiness is
Hi Guys,
Need some pointers. I've got a MySQL server (5.0.22) which is basically
pulling data from SQL Server into a file and then I'm using mysqlimport
to load the data into the DB.
The updates are being generated like every 2 to 5 seconds.
Due to this, my Binary Log files are huge!
version I only have to change the symbolic link mysql in
/usr/local/mysql to the directory of the previous version if I use binary
instead of rpm releases. That works because I use another director for data
thant /usr/local/mysql/data. Could I do these with rpm?
-Mensaje original-
De: Chr
sage -
From: <[EMAIL PROTECTED]>
To: "MySql Mail List"
Sent: Thursday, September 21, 2006 9:27 PM
Subject: What mysql 5.0 binary relase use for CentOS 4.4 Pentium?
> Hi.
>
>
>
> What binary relase use for CentOS 4.4:
>
>
>
> * Linux (x86, glibc-2.
[EMAIL PROTECTED] wrote:
Hi.
What binary relase use for CentOS 4.4:
* Linux (x86, glibc-2.2, "standard" is static, gcc):
mysql-standard-5.0.24a-linux-i686.tar.gz
* Linux (x86): mysql-standard-5.0.24a-linux-i686-glibc23.tar.gz
In http://dev.mysql.com/doc/ref
Hi.
What binary relase use for CentOS 4.4:
* Linux (x86, glibc-2.2, "standard" is static, gcc):
mysql-standard-5.0.24a-linux-i686.tar.gz
* Linux (x86): mysql-standard-5.0.24a-linux-i686-glibc23.tar.gz
In http://dev.mysql.com/doc/refman/5.0/en/binary-notes-linux
--On September 5, 2006 1:41:43 PM +0530 Arvind Kumar
<[EMAIL PROTECTED]> wrote:
Hi!
Any help would be appriciated.
I found MySQL binaries for embedded system (Processor: Power PC,
OS:Linux)
There is not much space available in the hard disk. It is around 20 MB.
The binary size is
Hi!
Any help would be appriciated.
I found MySQL binaries for embedded system (Processor: Power PC, OS:Linux)
There is not much space available in the hard disk. It is around 20 MB.
The binary size is large enough, could you please tell me how can i reduce
binary size. Stripping, I already did
inlog_do_db | Binlog_ignore_db |
> +--+---+--+--+
> | repl.024 | 110962544 | | |
> +--+---+--+------+
> 1 row in set (0.00 sec)
That File column looks wrong, the name should match your setting for the
name of the binary log
> Note that you should not just delete the bin logs. Instead
> use PURGE MASTER LOGS. See
> http://dev.mysql.com/doc/refman/4.1/en/purge-master-logs.html
>
> hth,
> mark
Sorry, accidently hit Ctrl/Enter :(
Anyway, I can't purge with that command:
mysql> PURGE MASTER LOGS TO 'mysql-bin.023';
On Thu, 2006-08-10 at 14:47 +1000, Logan, David (SST - Adelaide) wrote:
> Hi Warren,
>
> I would generally keep the binary log until you have done a full backup.
> Once that is done, all the transactions that are contained in those logs
> are now committed and saved in your databas
Hi Warren,
I would generally keep the binary log until you have done a full backup.
Once that is done, all the transactions that are contained in those logs
are now committed and saved in your database backup.
All binary logs may be deleted that were created before that backup took
place. The
I've just recently set up MySQL replication amongst two servers so I'm not
too familiar with it. I was cleaning up my /var filesystem and found the
binary data below being stored in /var/lib/mysql, taking up 1.5gb.
I did a little reading on mysql.org docs. My interpretation was th
aster A
are replicated to slave A, and inserts on master B are replicated to slave
B). However, queries that are run on master A, do *not* make it all the
way to slave B. The queries execute on master B but I have verified that
they are not being written to master B's binary log. Hence, slave
>
> http://dev.mysql.com/doc/refman/5.1/en/charset-binary-op.html
>
> It has some good examples.
got it thanks...
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 - 100 of 815 matches
Mail list logo
