Hi Adam,
there was a similar thread within the last 24 hours.
try SHOW VARIABLES LKE '%time%';
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月 1日 日曜日 14:47、Adam Murphy さんは書きました:
> I am trying to insert a table ibf_posts
>
> into a localhost database using the MYSQL control center every time i
Hi Barry,
2003年 5月 31日 土曜日 00:30、あなたは書きました:
> Thanks Nils. I can remotely connect to the database. I removed the local
> host entries for the bdancis account (the same name as the remote login)
> and added a new entry for [EMAIL PROTECTED] but was still not able to log on
> locally even if I run:
>
> I am new user of MySQL and whenever I type mysql to start the ware it
> simply states -- Can't connect to local MySQL server through socket
> 'var/lib/mysql/mysql.sock'. I know I am doing something very wrong
here
> and mabe some of you might be able to help me solve this problem.
Might be th
Hi Alan,
you would have to do
mysql -u root -p
and then enter the password to connect.
best regards
Nils Valentin
Tokyo/Japan
003年 5月 31日 土曜日 04:02、2Hosts.com さんは書きました:
> Hi Nils,
>
> So if I su to root and try to start mysql, I get the following... does that
> mean I'm secure? I am still
>Description:
The file scripts/mysql_install_db crashes when trying to create the
databases. Since the system isn't configured MySQL cannot start
>How-To-Repeat:
Just a simple build from source will do the trick. There are no
compile errors and even the make install
Hi Christoph,
O.K, what I can say already from your enclosed print is that the server mysqld
is ignoring your settings.
Lets find out why.
Check how your mysql server is started (as mysqld or safe_mysqld) :
ps ax |grep mysql
see that in my case a script is starting mysql-max (Suse Linux)
694
varchar doesn't cause a problem, its a case of not using it speeds things
up.
As with all things, horses for courses, if you don't need to use it, don't.
Jerry
- Original Message -
From: "Andrew Braithwaite" <[EMAIL PROTECTED]>
To: "'Ulterior'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
S
What I was going to say ::
I was always told to stay clear of the varchar for performance, and that was
on the mysql training course and the dev's.
So I'd take that its relevant
Jerry
- Original Message -
From: "Nick Arnett" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sat
Hi
var/lib/mysql/mysql.sock
is created when MySQl runs, it may be a permissions problem with the
directory - does MySql have write permission for this directory
Peter
-Original Message-
From: Vishal Thakur [mailto:[EMAIL PROTECTED]
Sent: 01 June 2003 10:37
To: ABHIJIT NAIK
Cc: MySQL; Su
re-install mysql, it wont work without mysql.sock.
On Sun, 2003-06-01 at 01:04, ABHIJIT NAIK wrote:
> Dear Friends,
>
> I am new user of MySQL and whenever I type mysql to start the ware it
> simply states -- Can't connect to local MySQL server through socket
> 'var/lib/mysql/mysql.sock'. I know
Robert Mark Bram schrieb:
Howdy All!
When I tried to install the new MySql, I got the result below:
C:\mysql\bin>mysqld --install
The service already exists!
The current server installed: C:\mySql\bin\mysqld-nt
C:\mysql\bin>
My problem is this: I used the "add remove programs" utility to remove
I have a table, in the table is a field called name_id; in a second
table (a linking table) I also have the field name_id, this should be
the same/reference the same name_id as in the first table.
The first table is fully populated. How do write a SQL statement to
get the data from the name_i
Howdy All!
I encountered a 1045 error myself and in searching Google found this thread
from March 2003. I am not sure if it was solved, so, for the record, here is
what I did to solve it.
I tried logging into mysql as default with just this command:
mysql --local-infile -h localhost
I then trie
In the last episode (Jun 01), [EMAIL PROTECTED] said:
> i have one multiple column fulltext index for 3 columns i join in a
> fulltext match statement
Fulltext indexes are different from regular indexes. I don't think it
matters what order the columns are in.
--
Dan Nelson
[EMAI
Howdy All!
> When I tried to install the new MySql, I got the result below:
>
> C:\mysql\bin>mysqld --install
> The service already exists!
> The current server installed: C:\mySql\bin\mysqld-nt
>
> C:\mysql\bin>
>
> My problem is this: I used the "add remove programs" utility to remove the
> old
I am trying to insert a table ibf_posts
into a localhost database using the MYSQL control center every time i try to insert
that one table i get an error
[forum] ERROR 2013: Lost connection to MySQL server during query
??
pleas help
Adam
i have one multiple column fulltext index for 3 columns i join in a
fulltext match statement
> In the last episode (Jun 01), Daniel Rossi said:
>> hi just reading up on optimising indexes, does it matter what order u
>> set your indexes ?
>>
>> The first index part should be the most used column.
In the last episode (Jun 01), Daniel Rossi said:
> hi just reading up on optimising indexes, does it matter what order u
> set your indexes ?
>
> The first index part should be the most used column. If you are
> always using many columns, you should use the column with more
> duplicates first to g
Howdy All!
When I tried to install the new MySql, I got the result below:
C:\mysql\bin>mysqld --install
The service already exists!
The current server installed: C:\mySql\bin\mysqld-nt
C:\mysql\bin>
My problem is this: I used the "add remove programs" utility to remove the
old MySql server, but
hi just reading up on optimising indexes, does it matter what order u set your indexes
?
The first index part should be the most used column. If you are always using many
columns, you should use the column with more duplicates first to get better
compression of the index.
i dont really under
Howdy all!
I now know that I was running 3.23.55 and that I need 4.1 for Unicode
support.
I am running Windows XP Pro and in my "add or remove programs" utility, I
see "MySQL ODBC 3.51 Driver" and "MySQL Servers and Clients 3.23.55".
If I use Windows "add or remove programs" utility to remove "
That will give you version of mysql client you're running,
For version of mysql server, after successful connection to mysql, use
status command.
mysql> status
Or
telnet to port 3306 of server running mysql
C:\>telnet 192.168.1.2 3306
you'll see few garbage and mysql version number in there too
$ mysql --version
On Sat, 2003-05-31 at 22:21, Robert Mark Bram wrote:
> Howdy all!
>
> How do I find out what version of mysql I am running from the command line?
>
> Is there a type of system select statement I can execute?
>
> Rob
> :)
> :->
> :-}
>
> --
> MySQL General Mailing List
> For
Howdy All!
How do I activate unicode support for my tables?
I searched the mysql manual and found a section that says "MySQL software
now offers extensive Unicode (UTF8) support" but I could not find a section
that went through how to do it.
Secondly, if I turn on unicode support for a tables, w
Howdy all!
How do I find out what version of mysql I am running from the command line?
Is there a type of system select statement I can execute?
Rob
:)
:->
:-}
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTEC
try passing the --host param to specify the ip address of the MySQL
server. Lets say that you have MySQL running on 192.168.1.105
$ mysql --host=192.168.1.105 -u username -p
do a man mysql for more info
SK
On Sat, 2003-05-31 at 15:34, ABHIJIT NAIK wrote:
> Dear Friends,
>
> I am new user of My
Check running processes, to see how many are currently using mysql
(mysqladmin proc). Compare to "max_connections" (mysqladmin var).
Change my.cnf (or whever your config file is) and restart mysql
Martin
- Original Message -
From: "ABHIJIT NAIK" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTE
Dear Friends,
I am new user of MySQL and whenever I type mysql to start the ware it
simply states -- Can't connect to local MySQL server through socket
'var/lib/mysql/mysql.sock'. I know I am doing something very wrong here
and mabe some of you might be able to help me solve this problem.
I am ru
Dennis,
are you building on Red Hat 8.0?
Our guess is that there is some bug in glibc-2.2.92 there. mysqld crashes
just after thread creation on many Red Hat 8.0 computers if built from
source on that computer.
Workaround: use an official binary from www.mysql.com or build on Red Hat <=
7.3.
Be
Rainer,
- Original Message -
From: "Rainer Collet" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, May 31, 2003 5:49 PM
Subject: Re: MySQL/InnoDB-4.0.13 is released
> [EMAIL PROTECTED] ("Heikki Tuuri") wrote in message
news:<[EMAIL PROTECTED]>...
> > Hi!
> >
> > I
Dear all,
I'm designing a database for a travel company but i'm puzzled.. Maybe you can shed a
light on this:
I've got an travelpackage that can exicts of more possible departure date's but it has
also have more than one accommodation.
So 3 tables:
(table one)
-Travelpackageid (Primary Key)
-
Hi,
I would use mediumint rather than int for the ID column (int has support for
up to 2.1 Billion records wheras mediumint is up to 8.3 million - more
efficient for your data type). I don't think the varchar will cause much of
a problem. Useful section here:
http://www.mysql.com/doc/en/Data_si
Alex Thurgood <[EMAIL PROTECTED]> wrote:
> Le lun 26/05/2003 ? 21:00, [EMAIL PROTECTED] a ?crit :
>
>> From: Victoria Reznichenko <[EMAIL PROTECTED]>
>> To: [EMAIL PROTECTED]
>> Subject: Re: Automatic calculation of date additions
>> Date: 26 May 2003 15:57:41 +
>>
>> Alex Thurgood <[EMAIL PR
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jerome Smith wrote:
> Hello everybody,
>
> Im new to this list, and also new to MySQL. I would be very grateful if
> someone could help me with the following problem:
>
> I have MySQL server version 4.0.12 with a database on a Linux server. I
> work
Hello everybody,
Im new to this list, and also new to MySQL. I would be very grateful if
someone could help me with the following problem:
I have MySQL server version 4.0.12 with a database on a Linux server. I
work from a Windows XP client. I am trying to load data from a text file
into a table
Mark,
Here's a "brute force and ignorance" approach. Disclaimer: It has worked
once,
and may work again some day. In particular, I haven't looked at the MySQL
internals, and I've only tried it on a very small table.
You have "foo.frm", which used to be the .frm file for an InnoDB table.
I not
> -Original Message-
> From: Mikey [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 30, 2003 11:53 AM
> To: [EMAIL PROTECTED]
> Subject: Why doesn't this query work?
>
>
> OK, first of all thanks for the pointers, however, the query I now have
> doesn't seem to work. If I run the query up unt
> -Original Message-
> From: Ulterior [mailto:[EMAIL PROTECTED]
> Sent: Saturday, May 31, 2003 7:35 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Insert query
>
>
> sow what would you suggest, Jerry?
>
> ( I need a very FAST search on this table's filename field)
>
> Ulterior
>
> > Don't use va
38 matches
Mail list logo
