Hello Baron,
2007/7/17, Baron Schwartz <[EMAIL PROTECTED]>:
Are you sure the master and slave had the same data at the time you started the
slave replicating from the master? It looks to me like the slave had different
data and you need to re-initialize the slave.
I'm not so sure.The order I
Thufir wrote:
SELECT product_name, customer.name, date_of_sale
FROM `sales` , product, customer
WHERE product.product_id = sales.product_id
and customer.customer_id = sales.customer_id LIMIT 0, 30
The above SQL command links three tables and display the required
result. The tables are linked by
SELECT product_name, customer.name, date_of_sale
FROM `sales` , product, customer
WHERE product.product_id = sales.product_id
and customer.customer_id = sales.customer_id LIMIT 0, 30
The above SQL command links three tables and display the required
result. The tables are linked by their ID fields
Hi,
Jen mlists wrote:
Hello members,
One of our master dbs didn't have binlog enabled.But I need to do
replication on it.
So I add the lines,
[mysqld]
log-bin
server-id=1
in /etc/my.cnf and restart mysqld.Then I follow the general operation
to do the master/slave replication.
My question is,I
B. Keith Murphy wrote:
Hey all. I have a bit of a problem. We are upgrading from ver 4.1.x to
5.0.45. That's not the problem :). The problem is that MySQL recommends
dumping and importing your data when doing this upgrade to make sure that
things go as smoothly as possible. We have quite a bit of
Hello members,
One of our master dbs didn't have binlog enabled.But I need to do
replication on it.
So I add the lines,
[mysqld]
log-bin
server-id=1
in /etc/my.cnf and restart mysqld.Then I follow the general operation
to do the master/slave replication.
My question is,I only enable binlog befo
Hey all. I have a bit of a problem. We are upgrading from ver 4.1.x to 5.0.45.
That's not the problem :). The problem is that MySQL recommends dumping and
importing your data when doing this upgrade to make sure that things go as
smoothly as possible. We have quite a bit of data spread over mult
It is not currently possible -- a slave may have only one master -- and is one
of the most requested replication features, so you're not alone :)
Baron
Ofer Inbar wrote:
Say I have database1 on server1, database2 on server2, etc.
I'd like to set up one server where I can *look* at all of thes
Say I have database1 on server1, database2 on server2, etc.
I'd like to set up one server where I can *look* at all of these
databases, without modifying them - a read-only aggregator.
What I'd like to do is, have the aggregator have local copies of
database1, database2, database3, etc., and repl
Hi,
Ofer Inbar wrote:
We've got a couple of production databases using mostly MyISAM tables,
that can't be taken offline without bringing down our application. To
reduce downtime, we run a full mysqldump once a week and back up the
binary logs every day, so we can always use them to "catch up"
Jeff,
CTRL-Z in linux doesn't hang up mysql, it suspends it. mysqld releases
the locks because the connection was broken when you issue 'exit'.
When using ctrl-z the client process still exists and it's connections
still exist so the locks won't be released. To bring a process out of
suspension t
Hi Ofer,
I prefer to use mylvmbackup and lvm to backup mysql. It's snapshot
includes a copy of the relay-log.info file which has the
exec_master_log_pos and relay_master_log_file. These allow you to use
the snapshot to restore another slave. It's also much faster to take a
snapshot of the file sy
Message could not be delivered
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
We've got a couple of production databases using mostly MyISAM tables,
that can't be taken offline without bringing down our application. To
reduce downtime, we run a full mysqldump once a week and back up the
binary logs every day, so we can always use them to "catch up" from
the most recent full
Thanks! I didn't remember UNION - that does the trick.
On Monday 16 July 2007 15:49, Rolando Edwards wrote:
> drop table if exists test.flipdata;
> drop view if exists test.RotatedData;
> create table test.flipdata (f1 int,f2 char(1),f3 char(1));
> insert into test.flipdata values (1,'a','b'),(2,'
hello,
When saying 'exit' in mysql shell,mysqld would release the lock which was made
before.
But if I do 'ctrl+z' under linux to hang up mysql shell,would mysqld also
release the lock or not?
Thank you.
Viel oder wenig? Schnell oder langsam? Unbegrenzt surfen + telefonieren
ohne Zeit- und Vol
drop table if exists test.flipdata;
drop view if exists test.RotatedData;
create table test.flipdata (f1 int,f2 char(1),f3 char(1));
insert into test.flipdata values (1,'a','b'),(2,'c','d');
create view test.RotatedData as select f1,f2 from test.flipdata union select
f1,f3 from test.flipdata order
drop table if exists test.flipdata;
create table test.flipdata (f1 int,f2 char(1),f3 char(1));
insert into test.flipdata values (1,'a','b'),(2,'c','d');
create view test.RotatedData as select f1,f2 from test.flipdata union select
f1,f3 from test.flipdata order by 1;
select * from test.RotatedData;
Yes, I've been using phpmyadmin.
Thanks.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
> -Original Message-
> From: Jim Gi
While I was away from the Internet, it struck me that the problem has to do
with a "python egg", not, as you mention, with MySQL.
Thanks,
Pat
Baron Schwartz <[EMAIL PROTECTED]> wrote:
Hi,
> First up, the sites were working fine until the old server went buggy. I
> hadn't worked on either
Hi all,
I have to create a view. For this, a table needs to transformed like this:
So the original table is
1 a b
2 c d
I want
1 a
1 b
2 c
2 d
I can do two queries giving me this, but how do I combine them in a view? If a
new table would need to be created, I could do a select into - but in a view
Hi All,
I have a mysqldump take from machine A on 14th July,2007.
When i took the mysqldump the bin-log file name postion was
Master_Log_File: mysql-bin.34
Read_Master_Log_Pos: 155537266.
Now i have restored this dump into another machine B which already had
log_bin enabled. Its current
bi
22 matches
Mail list logo
