Carlos,
We have a hosting provider with a Linux box and an MySql database.
We have a local Mysql database.
In both machines I use phpMyAdmin.
On the startpage (right frame) of phpMyAdmin you should see a link
called Show MySQL system variables. Look what the values of the
variables
-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 varchar unless
-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 until
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 note
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
-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 from a
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 PROTECTED] wrote:
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:
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)
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!
InnoDB is a
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
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 PROTECTED]
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
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
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,
$ 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 list
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.
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 MySQL
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
Howdy All!
When I tried to install the new MySql, I got the result below:
C:\mysql\binmysqld --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 in
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 get
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. If you
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
Howdy All!
When I tried to install the new MySql, I got the result below:
C:\mysql\binmysqld --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,
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
[EMAIL
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
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
Robert Mark Bram schrieb:
Howdy All!
When I tried to install the new MySql, I got the result below:
C:\mysql\binmysqld --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
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 I
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;
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:
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]
Sent:
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.
33 matches
Mail list logo