Start with the troubleshooting section of the manual.
Is the server running?
Where did it put the socket file?
What program gave you that error?
What system are you running?
What version of MySQL is this?
Where did you get it?
How did you install it?
So many questions. So few answers.
CSHAkira w
Hi,
Could someone please e-mail me a copy of the example cnf files, as they
did not come with my distribution. Thanks.
For a Sun E450 with a single 300Mhz processor and 256Mb of RAM which
.cnf file would you suggest I used? The machine is being used for a MRP
server as well as a ODBC mysql serve
That might depend on the table type of radacct, and the field type of
username.
Mucahit Celikag wrote:
> Hi,
>
> I am using mysql running under solaris.
>
> I am giving two similar queries and geting different results.
> I couldn't find the solution to this problem.
>
> Example.
>
> Q1.
Hi,
I'm new in this list and new to MySQL also. What I want to know is how
to limit the size of a database.
Thanks.
--
Ali Kemal YURTSEVEN
Is Net A.S.
Iletisim Uzmani
-
Before posting, please ch
but mysqldump generates an invalid statement.
mysql> CREATE TABLE TESTBADDUMP (
-> e_test enum('0','1') NOT NULL default ''
-> );
ERROR 1067: Invalid default value for 'e_test'
mysql>
I think that's what the orignator is trying to show. That mysqldump is
generating an in
Le Mon, Jun 18, 2001 at 04:04:52PM +0300, Sinisa Milivojevic a écrit:
> [EMAIL PROTECTED] writes:
> > mysqldump regenerates a bad sql statement from a bad initial create table.
> >
> > When you create this table for example (ok it's not a really nice definition):
> >
> > CREATE TABLE TESTBADDUMP
how to setup passwords for mysql
On Mon, 18 June 2001, [EMAIL PROTECTED] wrote:
>
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> database,sql,qu
Try quoting (' ') the 0 in your create:
CREATE TABLE TESTBADDUMP (
e_test enum('0','1') NOT NULL default '0' );
-^
You should then get the result you want.
Have a great day...
John
On Monday 18 June 2001 08:54, [EMAIL PROTECTED] wrote:
> mysqldump r
Hi,
> mysqldump regenerates a bad sql statement from a bad initial create table.
>
> When you create this table for example (ok it's not a really nice definition):
>
> CREATE TABLE TESTBADDUMP (
> e_test enum('0','1') NOT NULL default 0
> );
>
> desc TESTBADDUMP;
> +---
[EMAIL PROTECTED] writes:
> mysqldump regenerates a bad sql statement from a bad initial create table.
>
> When you create this table for example (ok it's not a really nice definition):
>
> CREATE TABLE TESTBADDUMP (
> e_test enum('0','1') NOT NULL default 0
> );
>
> desc
My vote goes to a my.cnf configuration file. (/etc/my.cnf - or one of
the other possible locations)
It is, after all, a configuration option.
[Raid]
directory1=/disk1/mysql
directory2=/disk2/mysql
directory3=/disk3/mysql
etc..
> -Original Message-
> From: Markwalder Philip [mailto:[EMA
mysqldump regenerates a bad sql statement from a bad initial create table.
When you create this table for example (ok it's not a really nice definition):
CREATE TABLE TESTBADDUMP (
e_test enum('0','1') NOT NULL default 0
);
desc TESTBADDUMP;
++---+---
Hi Samuel
I would do this in sql. I thinks this would be much more convenient to administrate.
It would be great if you would see these informations also in with the command eg:
show database storage
and you can see as return, where the files are located.
Thanks
Philip
On Mon, 18 Jun 2001
I've been experiencing some strange behaviour
in which mysqld will get into an odd state.
When doing certain long-running operations
(see below) on large tables (5-10 million rows;
20-30 columns per row -- mix of varchar and int)
with unique indeces mysqld will occasioanlly get
into a confused s
Dear :
Sir
There are a message error display ...
Can't connect to database : Can't connect t local MySQL server through
socket '/var/lib/mysql/mysql.sock' (111)
How and where that I can trouble shooting it ?
Best Rgards
Isn't this something that RAID O does for you on a larger scale anyway?
I would expect that most would have some sort of raid on their mutliple drive
system.
On Monday 18 June 2001 01:52 am, you wrote:
> On Sun, Jun 17, 2001 at 11:48:04PM -0700, Jamie Krasnoo wrote:
> > Is there a way to tell My
Roger Norton writes:
> he development team I am currently with is considering using MySql. However, as
>part of the we require the actual benchmarks that were used as well as the results.
>Is it possible to have a set of the SQL queries in the form
>
> CREATE TABLE t ( n NOT NULL VARCHAR(100)
Stepan Havel writes:
> Solaris8 on a Ultra5 Box, mysql++ 1.7.9: the example and also my own
> appliacations core dumps if they can not connect to mysql, in other words
> the try block does not work! I have tried gcc 2.95 (recommended in the
> manual) and 2.95.3!
>
> Does any has experience with t
David Ayliffe writes:
> I wrote this program in VC++ using the MYSQL++ API for VC. I have a
> generic function (below) which I call numerous times each time with a
> different query string. It works fine the first time around. But the
> second time I call this function it causes the program to
On Mon, 18 Jun 2001, Jamie Krasnoo wrote:
> Yes. It definitely would. I didn't know Yahoo uses MySQL.
>
> What would be great for an interim is if a script could determine the space
> available and suggest the settings to create the table. I see that by
> setting RAID_CHUNKS you could tell how m
he development team I am currently with is considering using MySql. However, as part
of the we require the actual benchmarks that were used as well as the results. Is it
possible to have a set of the SQL queries in the form
CREATE TABLE t ( n NOT NULL VARCHAR(100));
INSERT INTO t VALUES ("
Sir,
We are using mysql-3.23.38 and are using Red Hat Linux
7.0. The linux kernel version is 2.2.16-22.We are
using
an IBM-PC with 128 Mb RAM,intel PIII processor.
We are presently using kannel SMS gateway-1.0.3 and
are
using Mysql as database.
We are using a C API to connect to the database.
Hi!
Is there a case insensitive version of 'InStr' function in MySql ?
I need to search a database for secified substring.
This can be done by function InStr which "Returns the position of the first
occurrence of substring substr in string str".
There are also functions named: LOCATE, POSITION w
Today on a slave I got (this actually has occured several times in the past
months):
Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log
'xxx-bin.040' at position 47694
010511 10:37:19 Error reading packet from server: log event entry exceeded
max_allowed_packet -
> Hi there,
>
> I'm using select queries like
>
> SELECT * FROM table_name WHERE col_name LIKE '%some_word%'
>
> to find rows that have col_name match to some_word. But I would also like
> to find the number of word matches for each row so that I can order these
> rows according to their relevanc
> thank you.
> that's sort of what i thought.
>
> now for the silly question:
> i know how to do it with 'monitor' (CLI), but where/how do you
> "import" using phpMyAdmin, please? (this i'd love to know :) i looked
> through the manual but didn't see anything for "import" db.
Click a database on
> Fatal error: Call to undefined function: dayname() in
> /home/ccrb/ccrb-www/index.html on line 8
>
> This indicates that I'm missing most all of the functions. Is there a
> standard include that I need, or is my php installation not complete?
>
> Here is the line of code in question:
>
>
Solaris8 on a Ultra5 Box, mysql++ 1.7.9: the example and also my own
appliacations core dumps if they can not connect to mysql, in other words
the try block does not work! I have tried gcc 2.95 (recommended in the
manual) and 2.95.3!
Does any has experience with this, or am I allone in the dark a
Yes. It definitely would. I didn't know Yahoo uses MySQL.
What would be great for an interim is if a script could determine the space
available and suggest the settings to create the table. I see that by
setting RAID_CHUNKS you could tell how many directories MySQL should make.
The script could e
Dawn H wrote:
>
> -Original Message-
> From: Les Roberts [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, June 17, 2001 9:06 PM
> Cc: Dawn H
> Subject: Fwd: FW: FW: HELP! functions don't work...
>
> first I apologize for the bad function name... I had changed it to several
> and left it at day
101 - 130 of 130 matches
Mail list logo