Hello monty,
It seems like something changed in 3.23.31 and 32 in auto_repair
there.
I see on many servers after crash (i've resently got unexpected
powerdown for 10 of my machines so it worked like a good testcase) I
got tables failed to be repaired (or well selects fail on them)
28.Jan
Hallo ...
I tried to create simple replication:
2 machines
mysql-3.23.32
master - name register
slave - nane proxy
master configuration:
[mysqld]
set-variable = max_connections=300
log-bin
server-id=1
slave configuration:
[mysqld]
master-host=register
master-user=replicate_user
Running the standard (brand-new) OpenBSD install of MySQL from
/usr/ports/databases/mysql/
Version 3.23.32 - the port that Brad made just a few days ago. No
options. Just "make install".
It works fine exceptI keep getting this error:
ERROR 2006: MySQL server has gone away
It comes back
On the slave err log I have:
010128 11:04:28 Slave: Failed reading log event, reconnecting to retry,
log 'FIRST' position 4
010128 11:04:28 Slave: reconnected to master
'repl@glenastle:3306',replication resumed in log 'FIRST' at position 4
010128 11:04:28 Slave: received 0 length packet
You might take a look at my message about
MySQL 3.23.32 and FreeBSD 4.2-stable
try doing what i did there. I did it only
yersterday but so far not sig 11.
Me message is posted yersterday and it has
FreeBSD 4.2-stable in the subject and it is from
me (Artem Koutchine). Search for it.
-
Dear Sir,
Hello,
We have installed MySql in Windows NT Server.
MysqlAdmin services are doing fine and but when we try
to enter the prompt of mysql.we are getting the
follwing error
ERROR :1045
Access denied for user 'odbc@localhost )using password
yes
port is:3306 and user is :root
How to
i don't know exactly, but based on the message it seems to be
a permission problem in the mysql rights. So, RTFM on
the mysql permission model and commands.
- Original Message -
From: "Velamarthy Murthy" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, January 28, 2001 3:08 PM
Why not just reinit the database as specified in the
last step on install (after make install) in the manual.
No need to delete your database, just back them up
somewhere else. Then delete eveyrthing in your
localstatedir (where thedatabases are) including
'mysql' dir. Do reinit, and copy back
David Wilde writes:
Hello All,
I am new to MySQL and I am sure you have all heard this question a million
times, so I appologize in advance. My question is, I have installed MySQL
on a slackware 7.1 box, as well as a SuSE 7.0 box, and both seem to be
running fine with one minor
OK I get what you mean except that I installed on debian potato and
therefore do not have the reinit step since I used apt-get. Do you have any
ideas on this one.
Thanks again jm
- Original Message -
From: "Artem Koutchine" [EMAIL PROTECTED]
To: "John-Mark" [EMAIL PROTECTED]; [EMAIL
I have no idea what 'apt-get' is. MySQL, IMHO, should always be
installed from the sources by compiling by hands. Get the sources
and learn to install it correctly.
- Original Message -
From: "John-Mark" [EMAIL PROTECTED]
To: "Artem Koutchine" [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent:
Hello
I realised several SSL keywords in the Makefiles but cannot find a way to
activate SSL/TLS via ./configure. Did I miss something or is there no SSL
support implemented yet? Can I expect it for the future? (Would be great!)
bye,
-christian-
--
Save the forests, eat
Unfortunately, the OpenBSD threads library has been known to be
problematic at the moment, try using MySQL with the Pth threads library
in the meantime. This can be automated quite easily by using the pth
FLAVOR of the MySQL port. "make FLAVOR=pth install".
// Brad
[EMAIL PROTECTED]
[EMAIL
I posted the solution a couple of nights ago. The mysql folder and some of
the files within have the owner set to root. You need to change that to
mysql.
From: anthony ortega [EMAIL PROTECTED]
Date: 27 Jan 2001 22:46:25 -0800
To: [EMAIL PROTECTED]
Subject: simple problem with mysql install
Good Evening!
I've been working with VB and MySQL for awhile now, but not together. I've used VB to
use the built in database that comes with VB, but I doubt I'm using it to its full
potential.
I like the way PHP and MySQL interface, very naturally actually. I was hoping that I
could take my
and dumb too!
if(?) there is no app to launch, i.e., no GUI (Mac OS Xpb) -how do i
manipulate MySQL?
if you say "RTFM" -where is that? or a site perhaps?
thank you.
(seems kind of broad for a list archive search.)
p.s. i know there are front-end GUIs available, which do you folks
recommend?
there is the mysql command-line client, it's under bin under the mysql
base directory, it's called mysql on UNIX and mysql.exe on win32
:-) command line all the way!
can one 'get in' and control MySQL through OS X pb's Terminal app?
(various Unix shells.)
i think i need a GUI to start though, don't you?
At 11:48 AM -0700 1/28/01, Andrei Cojocaru wrote:
there is the mysql command-line client, it's under bin under the
mysql
no I started with the command line client and you don't need a shell, if
you have the client you can connect to remote mySQL servers if they allow
outside connections
On Sun, 28 Jan 2001 [EMAIL PROTECTED] wrote:
can one 'get in' and control MySQL through OS X pb's Terminal app?
(various Unix
Hello smart people,
Here's the situation:
table: books
|BookNumber |Author|Title |
| ... | ||
| 312 |'TWAIN,
Here's the situation:
table: books
|BookNumber |Author|Title |
| ... | ||
| 312 |'TWAIN, MARK'
Hello smart people,
My question is:
Is this three stage action possible with one SQL statement?
Yes you can do a query like:
select books.title from
words as w1,words as w2, wordlinks as v1,wordlinks as v2,books
WHERE (w1.WordNumber =v1.WordNumber ) AND (w2.WordNumber =v2.WordNumber
)
Where can I see a list of changes that were made in 3.23.3x versions of
mySQL?
--
-Spinlock
EmpireQuest Creator
http://www.empirequest.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Your TEXT does not appear to be defined as a fixed-length variable.
As I understand it, you can't index and search on a variable-length
TEXT field.
On 28 Jan 2001, at 21:46, Richard Heyes wrote:
Hi,
Having trouble with indexing TEXT column types, for the purpose of a
basic search engine
On Sun, Jan 28, 2001 at 02:59:21PM -0700, Andrei Cojocaru wrote:
Where can I see a list of changes that were made in 3.23.3x versions
of mySQL?
They are listed in the manual. Check the table of contents.
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408)
Are you sure that your select is in fact using the index on that column? Could
you please explain select for us.
John Jensen wrote:
To: "Scott Gerhardt" [EMAIL PROTECTED]
From what I have heard from a local guru. you shoud double that
again. I had mysql working fine on 150 meg for
I just want to ask a quick question which is probably only indirectly related
to this group. Where can I find some useful info on how to integrate MySQL
into Apache authentication scheme? Basically, I want to use MySQL database
to store users' ids and passwords rather than .htpasswd file
so you want to list all of them starting with the highest level and going
up to the lowest level?
On Mon, 29 Jan 2001, Oliver Joa wrote:
Hi,
I have a recursive Problem. I have a Table with columns "id", "name" and
"pid". E.g:
name1
name11
name12
name121
name122
name13
I think I have stuffed up the installation of the MySQL thing. I am trying
to get it installed onto a Debian box and am not having alot of luck :o|
http://www.scanners.8m.com/config.html
Any help would be appreciated,
Cheers
Dan Clark
Information Systems
System Support
HealthCare Otago
5046
Hello there,
We have a number of Sun sparcs connected to 2 NetApp file servers, and are
currently using 1 sparc running mysql with the databases residing on one
of the NetApps. I would like to run a 2nd sparc mysql server, also
serving the same databases (read-only) from the same NetApp. Is
Hello there,
We have a number of Sun sparcs connected to 2 NetApp file servers, and are
currently using 1 sparc running mysql with the databases residing on one
of the NetApps. I would like to run a 2nd sparc mysql server, also
serving the same databases (read-only) from the same NetApp. Is
On Wed, 24 Jan 2001, Xinkun Wang wrote:
|
|I've got a problem about Mysql table. if I insert several records in a
|certain order, firstly it is ok, but when I delete them and insert those
|records again (in the same sequence), But the order in MySql is totally
|different. For instance, I have
HI
I am trying to install mysql++.
I did automake, autoconf ./configure, make and make install.
When I add this row in kdevelopp / C++
#include sqlplus.hh
this message appears:
"In file inclued from /usr/local/include/sqlplus.hh:9,
from main.cpp:24:
/usr/local/include/defs:5: mysql.h: No folder
33 matches
Mail list logo