Hi!
Ananda Kumar said the following, On 28-Mar-07 06:15:
Hi All,
What are all the mysql services i need to monitor to make sure mysql db is
running and send a pager when any one of these services go down.
To check if a database is still running is diffrent then the actuall
process.
Do you
Hi
when I execute
mysql show slave status\G
I see this:
...
Last_Errno: 1175
Last_Error: Error 'You are using safe update mode and
you tried to update a table without a WHERE that uses a KEY column' on
query. Default database: 'xxx'. Query: 'delete from
Hi,
I tried to set a replication as below.
S1(master) --- S2 (slave), (master) -- S3 (slave)
I have set S1 and S2 (slave) without problem. However, there is a
problem in S2 as a master.
I found the the position in show master status also keep as 98 but I
am sure the replication from S2 to S1
This helped:
http://forums.mysql.com/read.php?26,133157,136626
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi folks,
CentOS 4.4 amd64
I have been stuck on creating root password;
# mysqladmin -u root password yourrootsqlpassword[code]
Access denied for user ‘root’@'localhost’ (using password: NO)
[/code]
# su -
did not help.
Pls advise how to locate mysql’s hostname.pid file?
Then to run;
# kill
Hi,
in /etc/my.cnf I set innodb_file_per_table in order to avoid a
centralized set of ibdata* files,
but that file (8 MB) is still present and continually updated.
What can I do to make it vanish for good? I'd like to have only
per-table ibd files.
The version of Mysql that I'm using is
Hi,
As I know, master will replicate all database to the slave in
default. If I want to replicate only specified database, we can use
parameter in master.
binlog-do-db=databasename
I found that we can also use parameters to replicate database even
table in slave.
replicate-do-db=db_name
In news:[EMAIL PROTECTED],
Nico Sabbi [EMAIL PROTECTED] wrote:
in /etc/my.cnf I set innodb_file_per_table in order to avoid a
centralized set of ibdata* files,
but that file (8 MB) is still present and continually updated.
What can I do to make it vanish for good?
As it is stated in the
Hi Friends,
I have set innodb_file_per_table option in my.cnf file for one database.
Now there is huge load on this servers.
Is it possible for me to move all these files to a new db on a new machine.
If you can you please let know how it can be done or guide to any url, it
would be of great
Hi Friends,
This iddata datafile will be used by mysql to store internal data dictionary
information. You cannot have a mysql db with only without these files.
regards
anandkl
On 3/28/07, Maciej Dobrzanski [EMAIL PROTECTED] wrote:
In news:[EMAIL PROTECTED],
Nico Sabbi [EMAIL PROTECTED]
In news:[EMAIL PROTECTED],
satimis [EMAIL PROTECTED] wrote:
Pls advise how to locate mysql=E2=80=99s hostname.pid file?
Try looking in standard directories such as:
/var/run/mysqld or /var/run/mysql or /var/run
The filename can be in form of 'hostname.pid', but it will rather be named
In news:[EMAIL PROTECTED],
Ananda Kumar [EMAIL PROTECTED] wrote:
Is it possible for me to move all these files to a new db on a new
machine. If you can you please let know how it can be done or guide
to any url, it would be of great help.
You cannot do this with copying .ibd files alone, but
Hi Maciej,
Thanks a lot for this info, so the best may to move tables from one db to
another db on a different machine is to use mysqldump, right?
regards
anandkl
On 3/28/07, Maciej Dobrzanski [EMAIL PROTECTED] wrote:
In news:[EMAIL PROTECTED],
Ananda Kumar [EMAIL PROTECTED] wrote:
Is it
Hi Maciej Dobrzanski,
This is a new installation. I'm now tuning MySQL.
[quote]
Try looking in standard directories such as:
/var/run/mysqld or /var/run/mysql or /var/run
The filename can be in form of 'hostname.pid', but it will rather be named
'mysqld.pid'.
[/quote]
[EMAIL PROTECTED] /]#
In news:[EMAIL PROTECTED],
satimis [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] /]# mysqld_safe =E2=80=93skip-grant-tables
[1] 5119
[EMAIL PROTECTED] /]# Starting mysqld daemon with databases from
/var/lib/mysql STOPPING server from pid file
/var/run/mysqld/mysqld.pid 070328 19:39:12 mysqld
On Wed, 28 Mar 2007, Ananda Kumar wrote:
Hi Maciej,
Thanks a lot for this info, so the best may to move tables from one db to
another db on a different machine is to use mysqldump, right?
Not necessarily, especially if you are moving to a fresh, empty server.
Each solution has its
Hi Maciej,
[quote]
See the error log for details of why the server stopped. It is usually
located either in /var/log (or its subdirectories, such us /var/log/mysql)
or in mysql data directory, which in your case is /var/lib/mysql. The error
log filename pattern is 'something.err'
Hi Maciej,
When you say copying binary Innodb data.
Can you please elobrate on this.
regards
anandkl
On 3/28/07, Maciej Dobrzanski [EMAIL PROTECTED] wrote:
On Wed, 28 Mar 2007, Ananda Kumar wrote:
Hi Maciej,
Thanks a lot for this info, so the best may to move tables from one db
to
Depending on the version you use MySQL will see a definition of
varchar(25) as 25 bytes or 25 characters. I believe this changed from
4.1 to 5.0 respectively but I am not sure.
THis could be the root of the problem
Boyd
CONFIDENTIALITY NOTICE: This email attached documents may
On Wed, 28 Mar 2007, Ananda Kumar wrote:
Hi Maciej,
When you say copying binary Innodb data.
Can you please elobrate on this.
I meant the .ibd files, shared tablespace files, and so on.
Maciek
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Okie, but in this case, if the shared tablespace has other database, then i
will be moving that also, which i may not require.
regards
anandkl
On 3/28/07, Maciej Dobrzanski [EMAIL PROTECTED] wrote:
On Wed, 28 Mar 2007, Ananda Kumar wrote:
Hi Maciej,
When you say copying binary Innodb
Hi Maciej,
What i meant to say was. Say if i have two database A B, and if i want to
move only database A, then the shared tablespace will also have info about
database B, and when i try to open the database A in the new machine, will
it not throw any error, saying that database B is not
In news:[EMAIL PROTECTED],
Ananda Kumar [EMAIL PROTECTED] wrote:
What i meant to say was. Say if i have two database A B, and if i
want to move only database A, then the shared tablespace will also
have info about database B, and when i try to open the database A in
the new machine, will it
In news:[EMAIL PROTECTED],
satimis [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] /]# mysqld_safe =E2=80=93skip-grant-tables
[1] 5119
[EMAIL PROTECTED] /]# Starting mysqld daemon with databases from
/var/lib/mysql STOPPING server from pid file
/var/run/mysqld/mysqld.pid 070328 19:39:12 mysqld
Has anyone found a way to get a result set with the current row return
number in a select statement without using vars?
select concat('Test row ',currentreturnrownum()) as testdata , mytestdata
from mytestdatatable;
++---+
|Test row 1 |
In the category of terrible, horrible, no good, very bad (but at least
documented) software behavior, I bumped into this today:
http://bugs.mysql.com/bug.php?id=14770
where the LOAD DATA INFILE command does not respect the default value of a
column if no value is supplied in the file. Instead,
sounds like a good solution.
regards
anandkl
On 3/28/07, Maciej Dobrzanski [EMAIL PROTECTED] wrote:
In news:[EMAIL PROTECTED],
Ananda Kumar [EMAIL PROTECTED] wrote:
What i meant to say was. Say if i have two database A B, and if i
want to move only database A, then the shared tablespace
Hi Maciej,
[quote]
Try running mysqld_safe with additional
parameter: --log-error=/var/lib/mysql/my.err. Then check what has been
written into that file.[/quote]
[EMAIL PROTECTED] ~]# kill `cat /var/run/mysqld/mysqld.pid`
No complaint
[EMAIL PROTECTED] ~]# /etc/init.d/mysqld restart
Stopping
This may sound mundane, but why not use a subselect COUNT?
SELECT COUNT(
select concat('Test row ',currentreturnrownum()) as testdata ,
mytestdata from mytestdatatable;) FROM mytestdatatable;
(I can't test this as I don't have currentreturnrownum() and
I'm sorry, currentreturnrownum() doesn't exist .. I was looking for a
function like that so I can make a result set show what row it is in the
return set.
so I can get select currentrownumber , * from anytable;
then I get
1 (rest of date from the *)
2 (rest of date from the *)
3 (rest of date
Hello All.
We have replication setup thus:- Master A -- Slave B. Now, the data
center will like to implement ca-unicenter on server-A and do some
testings for automation purpose. You've guessed it, Mysql-A will be
up-and-down for the next couple weeks. To provide business continuity, I
have
I'm trying to install ProBIND, and I'm running mysql 4.1.20.
One of the ProBIND install scripts calls for tables to be created in MySQL, and
I've culled it down to this:
mysql CREATE TABLE zones (
- id INT(11) DEFAULT '1' NOT NULL AUTO_INCREMENT,
- PRIMARY KEY (id)
-
It makes no sense to use a default value with an auto_increment
attribute, which means, the default value is the auto-incremented value.
Carlos
Al Sparks wrote:
I'm trying to install ProBIND, and I'm running mysql 4.1.20.
One of the ProBIND install scripts calls for tables to be created
It makes no sense to use a default value with an auto_increment
attribute, which means, the default value is the auto-incremented
value.
Carlos
Hmmm... I see your point. I sort of figured that the default was an
initial value, and from there, it incremented when accessed.
Sort of weird
Hi Maciej,
I found that I made a mistake from the beginning
# mysqladmin -u root password yourrootsqlpassword
leaving out -- before password
Retried as follows;
[EMAIL PROTECTED] ~]# mysqladmin -u root --password mypassword
Enter password:
Typing either mypassword or YES prompted;
Retried as follows;
[EMAIL PROTECTED] ~]# mysqladmin -u root --password mypassword
Enter password:
Typing either mypassword or YES prompted;
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
* end *
That is asking
36 matches
Mail list logo
