mario henriquez wrote:
> hi, i got a problemas in mysql with suse 10 enterprise server, the error:
>
> #1064 - You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use near ''
> at line 1.
>
> when i treat to create a new d
Hi Gabriel,
Yesterday MySQL died again... there is nothing in the log files... (be
it mysqld.log, .err, or /var/log/messages).
The hosting provider is running an application called 'big-brother'
and a lot of sef-faults appear in the logs from this. I don't know if
thins is the cause... if this
Spoken too soon...
Yesterday MySQL died again... there is nothing in the log files... (be
it mysqld.log, .err, or /var/log/messages).
The hosting provider is running an application called 'big-brother'
and a lot of sef-faults appear in the logs from this. I don't know if
thins is the cause... if
Yup... For now the problem stopped...
These humongos values were because they were initialized at MAX_INT on
that 64bit machine...
In the my.cnf file they were not mentioned at all !
2^64 - 1 == 18446744073709551615
Now look at the values below !
--
Gabriel PREDA
Senior Web Developer
On 6/22
Gabriel, in your SHOW VARIABLES, I see a handful of settings that are
much, much larger than normal:
| max_binlog_cache_size | 18446744073709551615
| max_join_size | 18446744073709551615
| max_seeks_for_key | 18446744073709551615
| max_write_lock_coun
Hi,
Please let us know what all variables you have configured in your my.cnf
files.
what is your total size of memory in box.
eg : max_connections
key_buffer_size
sort_buffer_size.
Gabriel PREDA wrote:
Hi list,
Since we bought a better hardware for our dedicated MySQL Server we
I think you will need to give the list some more information!
What error message do you get? Is it an error when running SQL queries, or a
problem connecting to the database?
James Harvard
At 9:22 am -0300 24/4/06, Gabriel Mahiques wrote:
>I migrated to mysql 5 but the applications with Visual
Hello.
These are some active bugs with different versions of MySQL
Administrator. Check if your problem remains with the latest one.
>Hi All,
>
>I'm trying to take scheduled backup from mysql administrator and it
>always
>gives me a popup with this message.
>
>"Enter user name and
Creating a database is a separate thing from adding permissions for a
database to the grant tables. When you create a database it's a "free
floating" database that nobody (except root) has permission to access
until you issue the grant statements to make someone "own" it. But
nobody actually owns
> Thank you very much for your bug report!
> And sorry if I doubted your report at the beginning; I hadn't thought
> of the rpm script.
No problem. I sometimes get bug reports that I know are impossible! Yet they
weren't. This one I would have barely noticed if it had not knocked the
slaves all of
> Hmm, I don't see any changes in ft-related files since 4.0.18 that could
> cause it (there were bugfixes, but they affect only *searching* - that
> is MATCH - and not *updating*).
>
> Can you create a test case ?
Well, I put up a file in the secret folder a few days ago as referenced in a
bug r
We start mysql with 'service mysql start' (we install from the RPM for
linux).
I've never seen mysql create binlog files under the name root before, and
after reverting to an old version, it doesn't again. It created a big mess
with all the slaves stuck at the end of an older binlog and not advanc
From: "Sergei Golubchik" <[EMAIL PROTECTED]>
> > 4. Thread stack warnings:
> >Warning: Asked for 196608 thread stack, but got 126976
> Same here.
OK, we can disable the warnings in the log file, but what's really behind
this warning?
A brand new, plain vanilla Fedora Core2 (aka RedHat FC2) ins
Hi!
On May 25, Steven Roussey wrote:
> We had some servers that were upgraded from 4.0.17/18 to 4.0.20 and had
> several problems thereafter:
>
> 1. Tables with FTS indices became corrupted, with queries on them causing
> segfaults on the servers.
Hmm, I don't see any changes in ft-related files
Abubakr wrote:
Hi,
i m using mysql 4.0.15 and tomcat 4 as a webserver on linux 8 machine, now the
problem that i am facing is that while testing my web application when i send too many
refresh requests to the web page, the server's CPU utilization reaches to 100% for a
very long duration of
Two things first, first of all you obviously don't have mysql correctly
installed, message "a" means mysql dead unexpectedly while trying to
start, mysql cannot start. Why? I just don't know you didn't detailed
your install procedure. Message "b" means that you cannot connect to the
db because me
First of all, get rid of Windows and use Linux =)
Secondly, try downloading the newest version 4.0.18-nt from mysql.com. That
will help you out. I run both Windows, Mac, and Linux versions of MySQL and
haven't had any problems with the MySQL installer for any OS.
If you have any other questions,
Donald Tyler <[EMAIL PROTECTED]> wrote:
>
> I am just learning to use Linux and I am having some problems with
> getting MySQL to load.
>
>
> I have successfully installed & tested both Apache & PHP, so I am pretty
> comfortable with the whole configure and make processes.
>
>
> I followed the
"karl james" <[EMAIL PROTECTED]> wrote:
> Im kinda new at creating databases thru the command line
> When I try to login using.
> Mysql -h hostname -username -p
>
> I get this message on command line.
>
> C:\Documents and Settings\Karl James>mysql -h hostname -u username -p
> -p;
> 'mysql' is not
Estoy tomando el sol
.
q
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Estoy tomando el sol
.
q
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Nir,
Tuesday, September 24, 2002, 6:21:39 PM, you wrote:
NG> I am trying to get mySQL set up and am having problems. I am using Win2000.
NG> I am using the Apache server and believe I have that set up properly as the
NG> server is in the running state. When I type "mysql" in the DOS prompt, the
N
Luciano Pulvirenti writes:
> If you create a Berkeley-DB table (es. CREATE TABLE TEST TYPE BDB) is not
> possible delete it after.
> The command DELETE TABLE TEST responds Table unknown.
> Thank You
> Luciano
>
Your CREATE statement is a bit dubious, so check that there is such a
table at all.
Arnie Miles writes:
> Hi:
>
> Im using Windows 2000, and Im having problems with MySQL GUI. It
> works intermittently. Sometimes it just closes out for no apparent
> reason. Sometimes it will not let a known good user log in. Sometimes
> it will let a known good user log in, but then will
Cody,
did you copy the InnoDB data files, log files, and .frm files
verbatim to the new computer? Have you tried wuith the same my.cnf
parameters you had in the old computer? Does InnoDB crash always
in the same function call?
It looks like the internal data dictionary of InnoDB is corrupted.
In
Cody Swanson writes:
> Hey,
>
> We just got a new Dell Poweredge 6450 preloaded with redhat 6.2. Our intention
> is to move the database off a smaller machine and load it into this one. We
> currently have MySQL 3.23.38 using the innobase driver on redhat 6.2 with kernel
> 2.4.4. This is on
On Monday 21 May 2001 13:50, Cody Swanson wrote:
> Hey,
>
> We just got a new Dell Poweredge 6450 preloaded with redhat 6.2. Our
intention
> is to move the database off a smaller machine and load it into this one. We
> currently have MySQL 3.23.38 using the innobase driver on redhat 6.2 wi
Sander Pilon writes:
> The 5_Class.html file online is only a few lines and only describes the
> manipulators, as opposed to the old 5_Class.html file distributed with
> 1.7.5 and the downloadable one, which is 300Kb and contains descriptions
> of much, much more.
>
> Manipulators is (the only)
On Sun, Apr 29, 2001 at 02:45:06PM +0200, Sander Pilon wrote:
>
> The 5_Class.html file online is only a few lines and only describes
> the manipulators, as opposed to the old 5_Class.html file
> distributed with 1.7.5 and the downloadable one, which is 300Kb and
> contains descriptions of much, m
Sent: 29 April 2001 14:32
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: Problems with MySQL++
>
>
> Sander Pilon writes:
> > >
> > > It is fine and complete will all chapters and in all formats.
> > >
Sander Pilon writes:
> >
> > It is fine and complete will all chapters and in all formats.
> >
>
> This page used to have lots of cool documentation...
>
> http://www.mysql.com/documentation/mysql++/5_Class.html
>
>
>
Yes, and there two versions of manual. One for on-line browsing and
th
>
> It is fine and complete will all chapters and in all formats.
>
This page used to have lots of cool documentation...
http://www.mysql.com/documentation/mysql++/5_Class.html
-
Before posting, please check:
http://ww
Sander Pilon writes:
> > Howdy,
> > ./ChangeLog
> >
> > Indeed, those don't appear to be in the tar archive.
> >
> > Any ideas?
>
> Do you need them?
>
> tar xfz mysql++.tar.gz
> cd mysql++-
> ./configure; make; make install
>
> Voila.
>
> And yes, the mysql online manual has b
Well, cool. If that works I'm happy. I was trying to go by the README and
use automake. Thanks!
It'd sure be nice if somebody fixed the docs, or at least put a note on the
web site that said they're broken. That probably cost me at least a day of
confusion. :-(
>> Howdy,
>>
>> I posted th
> Howdy,
>
> I posted this question over on the plusplus list, but so
> far I've not received a response. This list seems more
> active, so perhaps someone here can offer me a hand.
>
> I'm trying to get the 1.7.8 distribution of MySQL++ to
> build as directed in the README -- using auto
Hi!
>
> mysql> SELECT *,MATCH a,b AGAINST ('collections support') as x FROM t;
> +--++--+
> | a| b | x|
> +--++
Hi Matt,
Probably worth checking the archives for 'restartable' - there are a few
messages there.
Quentin
-Original Message-
From: Matt Mueller [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 5 April 2001 9:53 a.m.
To: [EMAIL PROTECTED]
Subject: Problems with Mysql on Sol7 i386
Hello,
I a
# isamchk -a -d -e -f -i -l -o imp_addr.ISM
ISAM file: imp_addr.ISM
Data records: 1223 Deleted blocks: 0
Recordlength:25
Record format: Packed
table description:
Key Start Len Index Type
User time 0.00, System time 0.00
Maximum resident set siz
Hi,
Try some of the more aggressive fixing options on isamchk - see the manual
for details.
Quentin
-Original Message-
From: Nuno Ferreira [mailto:[EMAIL PROTECTED]]
Sent: Friday, 16 March 2001 10:39 a.m.
To: [EMAIL PROTECTED]
Subject: problems with mysql table
Hi there
Christopher McClan writes:
> Hello,
>
> I've followed the instructions from the MySQL web site entitled "Instructions
> for building MySQLGui with the FL_Editor, and am currently trying to install
> mysql++1.78. I've made the modifications to sqlinst/connection1.hh &&
> sqlinst/result1.h
;
> Cc: [EMAIL PROTECTED]
> Subject: Re: Problems with mySQL and DBTools
>
>
>
> On Thu, 8 Feb 2001, Curtis, Lorenzo wrote:
>
> > 2. Is there a detailed outline to use to compile Apache with PHP and mySQL
> > effectively?
>
> www.devs
On Thu, 8 Feb 2001, Curtis, Lorenzo wrote:
> 2. Is there a detailed outline to use to compile Apache with PHP and mySQL
> effectively?
www.devshed.com/Server_Side/PHP/Soothingly_Seamless/print.html
--
/"\
\ /ASCII RIBBON CAMPAIGN
X AGAINST HTML EMAIL
/ \AND POSTINGS
--
42 matches
Mail list logo
