Hi,
In your my.cnf put this :
[mysqldump]
quick
max_allowed_packet = 32M
Regards,
Juan
On Fri, May 16, 2008 at 6:55 PM, Sigfrid <[EMAIL PROTECTED]> wrote:
>
> Hello, I have a simple question: how can I change the value of
> max_allowed_packet ? (I use server version: 5.0.51a MySQL Community Se
Hello, I have a simple question: how can I change the value of
max_allowed_packet ? (I use server version: 5.0.51a MySQL Community Server
on MacOS 10.5)
In my application I upload file but sometime I get this error
Mysql::Error: #08S01Got a packet bigger than 'max_allowed_packet' bytes:
Thanj
On Fri, May 16, 2008 at 6:44 AM, Ben Clewett <[EMAIL PROTECTED]> wrote:
> Looking at EXPLAIN PARTITIONS I have noticed that these SQL statement
> correctly select the partition:
>
> SELECT WHERE t =
> SELECT WHERE t IN
>
> But these select all partition tables:
>
> SELECT WHERE t >
> SELECT WHE
Hi, im working with google maps and im and trying to do this, but i cant
make a good query of it.
I want to select elements between a given latitude and longitude from this
table:
*CREATE TABLE `images` (*
*`id_img` bigint(20) unsigned NOT NULL auto_increment,**
**`filename` char(50) NOT NULL,**
1. have one (or more) slave readonly and don't give the developer the
root pwd.
2. have another slave for him to play with.
3. when you need to clean up his mess, stop the readonly slave, take a
dump, copy to playpen, start up both.
Rick James
MySQL Geeks - Consulting & Review
> -Origina
At 5:32a -0400 on Fri, 16 May 2008, Ananda Kumar wrote:
>>> 2 Index would do range scan, which would be comparitivly slower.
>>
>> Not exactly. This, again, depends on implementation and the
>> data against which queries are run. An index is an index.
>> Remember, a primary key is implemented by
Hi Tom,
Your master binary log start with mysql-bin.03, then, your insert ( or
update) in the master could be in mysql-bin.02 or 1.
Please, reload your binary logs again from the beginning ( put
mysql-bin.02 or 1, ). Your insert or update could be in one of this
files.
Regards,
Juan
>-Original Message-
>From: Shanmugam, Dhandapani [mailto:[EMAIL PROTECTED]
>Sent: Friday, May 16, 2008 4:01 AM
>To: Phani; Ananda Kumar
>Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com
>Subject: RE: Slave Server
>
>
>Ok..But if I do any changes on slave databases for testing it will
>affect Ma
Dear MySql,
Hope somebody might give some advise about replication!
On 5.1.24, I have something simple like:
CREATE TABLE big_f_er (
id BIGINT UNSINGED NOT NULL AUTO_INCREMENT,
t TIMESTAMP NULL NOT NULL,
PRIMARY KEY (id, t),
KEY (t)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
PARTITION BY RA
Yes thanks - i have done that and restarted the slave and _some_
tables now appear to update but others dont
eg
master:
mysql> select count(*) from tbl_checkcommand;
+--+
| count(*) |
+--+
| 30 |
+--+
1 row in set (0.00 sec)
slave:
mysql> select count(*) from
The error 1062 you could skipped in the slave modifying your my.cnf ( slave
side) using :
slave-skip-errors=1062
This error on duplicated records, normally is problem in binarylogs transfer
data. But, anyway, please confer that the data exist in the slave.
Yes thanks - i have done tha
Hi Tom,
The error 1062 you could skipped in the slave modifying your my.cnf ( slave
side) using :
slave-skip-errors=1062
This error on duplicated records, normally is problem in binarylogs transfer
data. But, anyway, please confer that the data exist in the slave.
Regards,
Juan
On Fri, May
Hi
I am running 4.1.20 as this is the stock version in RHEL4 u5 and i have
setup a master/slave combination. Updates at first appeared to work as
creating and inserting into the master created the db's on the slave
etc. I have noticed however that data in the master is not making its
way to t
or what u can do is
create a new set of databases on slave and dump all the data from the master
into it and ask your developers to test there, in this case, you can have
both your master and slave in sync.
The new set of databases u create on slave will not be replicated to master.
On 5/16/08,
Hi Shanmugam,
If its a simple master, slave replication, any changes on SLAVE will not be
replicated to master. If its a circular replication any change on master
will be done on slave and any changes on slave will be done on master. So
you need to pick what u want.
regards
anandkl
On 5/16/08, P
Hi Kevin,
> 2 Index would do range scan, which would be comparitivly slower.
Not exactly. This, again, depends on implementation and the data
against which queries are run. An index is an index. Remember, a
primary key is implemented by the MySQL engine as a unique not null
b-tree index. In f
At 2:49a -0400 on Fri, 16 May 2008, Ananda Kumar wrote:
> it goes without saying
Eh, not to those who don't know. Hence the list and question. :-D
Krishna, the short answer is that it depends on your data, and the
queries against it that you run. Test/benchmark on your own DB and data
to see w
Found partial sollution! Need to specify mysql_query("SET NAMES
'latin1'"); for connection charset.
MarisRuskulis wrote:
> Hello!
> I'm trying to migrate database from mysql 4.0 to 5.0 (latin1). So I
> maked dump from 4.0 and then restored it to 5.0, but without success
> because inside the web sy
Ok..But if I do any changes on slave databases for testing it will
affect Master server also right...I don't want that to happen.. After my
testing on the slave database I need to revert back the databases as of
master
Thanks and Regards,
DD
-Original Message-
From: Phani [mailto:[EMAI
You can try circular replication between server. So each server will act as
both Master and Slave.
Regards,
Phani | Business Analyst
zetainteractive
Road No 12, Banjara Hills, Hyderabad, AP 500034
T +91 40 23390080 | Ext: 337 | F +91 40 23390934 |
Vongage +1 714 209 7484
-Original Message
Hello!
I'm trying to migrate database from mysql 4.0 to 5.0 (latin1). So I
maked dump from 4.0 and then restored it to 5.0, but without success
because inside the web symbols isnt correct. On mysql 5.0 database
charset is latin1 and "SHOW TABLE STATUS" shows that table is latin1.
When I maked dump
Thanks for your responses, i thought it was a float problem so i was
trying to CAST as a DECIMAL to fix it. It turns out (and the manual does
not document this) that casting as decimals doesn't actually work in
mysql 4.1.20. ROUND() is needed instead.
mysql> select ROUND(11.11-FLOOR(11.11),2)>
No Anand..My question is ..If the developer do any changes on the slave
server, it will not get reflected to the Master server right? So there
will be data inconsistency. My requirement is When the developer do any
testing on slave databases. I need to revert back as of Master server
data...In orde
Hi Shanmugam,
Your question quite confusing.
Do you mean to say, if any changes happen to slave it should get refeleted
in the master, if yes, then u can setup two masters which are slave to each
other.
regards
anandkl
On 5/16/08, Shanmugam, Dhandapani <[EMAIL PROTECTED]> wrote:
>
>
> Hi There,
Hi There,
I am setting up a replication with one master and one slave.
I have created two databases in Master Server and it gets replicated to
the slave. When developer do changes on the slave database, It will not
be sync with the Master server. My requirement is when ever developer do
changes
25 matches
Mail list logo
