Allen Wayne Best wrote:
hello;
I am having a spot of trouble getting to MySQL to start. Here is the message:
050407 22:43:49 mysqld started
050407 22:43:49 /usr/libexec/mysqld: Can't find file: './mysql/host.frm'
(errno: 13)
I looked at the /var/log/messages file and found this:
Apr 6
Kevin A. Burton wrote:
Mikael Fridh wrote:
Kevin A. Burton wrote:
This is a bug.
Feature.
Putting system configuration information on a unix machine in /var..
.yeah... thats not a feature.
It's a feature because you installed it there.
I decided to put my datadir in /mysql/data which makes
skip-slave-start.
Anyway, WITH skip-slave-start you will still have the slave information
(binlog positions etc.) initiated but it will just not start replicating.
The information in master.info overrides anything in my.cnf.
--
___
|K | Ongame E-Solutions AB - www.ongame.com
| /\| Mikael Fridh
--
___
|K | Ongame E-Solutions AB - www.ongame.com
| /\| Mikael Fridh / Technical Operations
|_\/| tel: +46 18 606 538 / fax: +46 18 694 411
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
What's with that?
Let us know if your timezones are set correctly.
--
___
|K | Ongame E-Solutions AB - www.ongame.com
| /\| Mikael Fridh / Technical Operations
|_\/| tel: +46 18 606 538 / fax: +46 18 694 411
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
and use that in your CHANGE MASTER TO...
saved me from a full disk binlog corruption on a Master server once.
--
___
|K | Ongame E-Solutions AB - www.ongame.com
| /\| Mikael Fridh / Technical Operations
|_\/| tel: +46 18 606 538 / fax: +46 18 694 411
--
MySQL General Mailing List
For list archives
Lynette Tillner wrote:
I'm setting up a development box with FreeBSD 4.10 and installed MySQL 4.0.12 on it. Everything in the install appeared to work smoothly.
However, when I go to start MySQL I get an error that says:
database list could not be retrieved
So, how do I fix this? I've been
database(s) on the master, this change does not
show up on the slave.
I bet i need some help
$5 says you have the same server-id on both hosts.
--
___
|K | Ongame E-Solutions AB - www.ongame.com
| /\| Mikael Fridh / Technical Operations
|_\/| tel: +46 18 606 538 / fax: +46 18 694 411
--
MySQL
.cnf file on
the slaves.
consider just copying/tar'ing the mysql datadir - raw file backup and restore
are more efficient than mysqldumps.
--
___
|K | Ongame e-Solutions AB
| /\| Mikael Fridh / Technical Operations
|_\/| tel: +46 18 606 538 / fax: +46 18 694 411
--
MySQL General
/) {
$table=1;
print;
next;
}
}
if ($table) {
exit if /^CREATE/;
print;
}
}
}
--
___
|K | Ongame e-Solutions AB
| /\| Mikael Fridh / Technical Operations
|_\/| tel: +46 18 606 538 / fax: +46 18 694 411
On Thursday 17 June 2004 06.25, Stano Paska wrote:
Is there some common technique to notify another user, when he wants
open second dialog with same person, which is opened by first user at
the same time?
Another user sees on list of persons actual data, but this record is
already opened with
, and restart
the slave SQL thread with SLAVE START. We stopped at log 'george-bin.3794'
position 242
217149
5. another set global SQL_SLAVE_SKIP_COUNTER=1 and it was replicating again!
Someone please clear things up for me a little!
Thanks
--
Mikael Fridh
--
MySQL General Mailing List
For list
-
From: Mikael Fridh
To: DePhillips, Michael P; [EMAIL PROTECTED]
Sent: 1/23/2004 6:50 PM
Subject: Re: Replication Madness
I'm not sure I quite follow you here.
I think you mean that when the slave connects to the master, sometimes
the
master does not resolve the address the slave has - thus
I'm not sure I quite follow you here.
I think you mean that when the slave connects to the master, sometimes the
master does not resolve the address the slave has - thus failing because you
don't have grants for the slave's IP address..
Generally I think it's a bad idea to be dependent on a dns
- Original Message -
From: Mike Mapsnac [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 23, 2004 11:42 PM
Subject: Select help
Hello
I want to select from the table sum of logins for each day.
Here's one way to do it.
SELECT SUBSTRING(last_login, 1, 10) AS day,
Many times during higher load periods one of our slaves' replication is slower
than real-time and the slave can get behind several minutes.
94211 system user NULLConnect 519 Has read all relay
log; waiting for the I/O slave thread to update it
In this case it's 519
2 (of many) solutions here:
Create the column as a datetime instead and set it with NOW() when you first
insert the data.
In your update query, set the hr_con column to the current value.
(If you set the value explicitly it will not be updated with the automatic
timestamp value.)
read this
Hi, I tried this and it seems to work:
SELECT SUBSTRING_INDEX(INET_NTOA(ip), '.',3) AS addr, COUNT(*) AS addrsum FROM
ips GROUP BY addr;
Perhaps you don't have your IP adresses stored as integers but instead as
text. Then the following query is for you!
Your query:
SELECT ip, COUNT(*) from
]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
--
Ongame E-Solutions AB
Mikael Fridh
Junior Systems Administrator
Smedsgränd 3, 753 20 Uppsala, Sweden
Mobile: +46 708 17 42 00
Office: +46 18 65 53 57
Fax: +46 18 69
On Friday 28 November 2003 14.51, Lemasson Sylvain wrote:
Hello,
Hi
The first think is that I cannot add a primary constraint on test because
Mysql do not make the difference between 'bla' and 'BLA'. It is case
insensitive. I have the same problem when I do: select * from test where
Sorry about the double posts...
But I forgot something...
On Friday 28 November 2003 14.51, Lemasson Sylvain wrote:
Can something be done so that mysql be case sensitive ?
If you only need case-sentivitity on selects read this:
http://www.mysql.com/doc/en/Case_Sensitivity_Operators.html
The
Hacker gets in this way:
-[Webserver][rooted]-[DBServer][rooted]-File_Access(/var/lib/mysql/database)
I'd say the major security breach is already when the Webserver is rooted.^
If he gets to your webserver he could still read WHATEVER DATA he wants from
your database with the information he
http://www.mysql.com/doc/en/Replication.html
On Wednesday 26 November 2003 17.49, Mark wrote:
Hello - we would like to be able to run multiple servers (probably on
multiple networks) that all share one common database. By having more
than one MySQL server on seperate networks we can guarantee
On Wednesday 26 November 2003 17.51, Millaway, John wrote:
Inserting a NULL into a NOT NULL column used to automatically get the
DEFAULT value. I realize that it was non-portable, non-standard behavior,
but the code relies on it. How do I get this behavior in the 4.0.x server?
mysql CREATE
One of My MySQL slaves is trailing behind its master.
| 42 | system user | | NULL | Connect | 8193 | Has read all relay
log; waiting for the I/O slave thread to update it | NULL |
8193 seconds behind.
Why might the slave be trailing?
I just did a
slave stop;
slave start;
Regarding your mysql dump
If you did not redirect standard output (mysqldump test dumpfile.sql),
it did not go anywhere.
Mike
On Tuesday 25 November 2003 11.46, Swati K wrote:
Hi People,
wanted to know if one can write a Function or a procedure in a mysql
4.0.12..???
Also about this data
i have a backup copy created using mysqldump called
test-dump-Sat.sql.
i need to restore it into the test database on my
remote Solaris server.
after getting into mysql i gave command:
use test;
mysql test test-dump-Sat.sql;
try the same command from shell.
shell mysql -uUser -p test
but when i try to run :
% mysql -u root reporter reporter-dump-Sat.sql
mysql -uroot -p reporter dumpfile
it says :
ERROR 1044: Access denied for user: '@localhost' to
database 'reporter'.
think it's because of that extra space between the '-u' and 'root'
you also need the -p parameter so
Currently LOAD DATA FROM MASTER is subject to the following conditions:
* It works only with MyISAM tables.
* It acquires a global read lock on the master while taking the snapshot,
which prevents updates on the master during the load operation.
What I would do is take a snapshot from
http://downloads.mysql.com/archives.php?p=mysql-4.0v=4.0.15
On Thursday 20 November 2003 12.15, Karam Chand wrote:
One of the my client is using the above version and he
is getting an error with my app so I would like to
test my app against this version..
Can I get a link to 4.0.15
Karam
On Thursday 20 November 2003 16.52, Hassan Farha wrote:
It would be great if we could put 'mysql' in the subject of our questions.
I receive mail from many different places and it would help classification.
Thanks!
All of these headers (and more) are in mails on the mailinglist:
This is in the Upgrading from 3.23 manual:
http://www.mysql.com/doc/en/Upgrading-from-3.23.html
Note: when you use subtraction between integer values where one is of type
UNSIGNED, the result will be unsigned. In other words, before upgrading to
MySQL 4.0, you should check your application for
On Monday 17 November 2003 18.04, Andrew wrote:
I have a MySQL database with records in a table that i would like to
replace. The table is
items and the field is description. I would like to replace the existing
text within this filed with some new text.
I did this before and it was
-online.com/mysql/
--
Ongame E-Solutions AB
Mikael Fridh
Junior Systems Administrator
Smedsgränd 3, 753 20 Uppsala, Sweden
Mobile: +46 708 17 42 00
Office: +46 18 69 55 00
Fax: +46 18 69 44 11
e-mail: [EMAIL PROTECTED]
http://www.ongame.com/
--
MySQL General Mailing List
For list archives: http
On Thursday 13 November 2003 10.41, nm wrote:
Hi there
I have a question regarding replication.
This is the situation:
Mysql-Max4.0.16
192.168.0.10 master
192.168.0.11 slave
I would like to use the slave as the backup server
and use it in case the master goes down for any reason.
I'm
for the past decade as a massive effort to keep up with
Apple.
- Byte Magazine
Given infinite time, 100 monkeys could type out the complete works of
Shakespeare. Win 98 source code? Eight monkeys, five minutes.
-- NullGrey
--
Ongame E-Solutions AB
Mikael Fridh
Junior Systems Administrator
Smedsgränd
On Wednesday 12 November 2003 17.15, David T-G wrote:
% [client]
% password=mysql_root_password
What if one user connects to the database as different users (as I do, in
fact; sometimes all-db-root, sometimes one-db-root, sometimes read-only
user)? Let's back this out of root and go to
Martin,
Shut down your 3.23 server.
Make a binary copy of the data.
Install 4.0
Upgrade your privileges with the 4.0 script.
Start 4.0 server.
That's it, right?
Worked for me...
When doing backups I always do a full recursive backup of the entire mysql
data directory. This way I know that I'm
38 matches
Mail list logo