From: Christian Reichenbach [EMAIL PROTECTED]
We encountered that MySQL (or MyODBC) uses different
quoting characters for legal names and strings.
BSJ Well, let's put it this way : tables names between
BSJ square brackets only exists in Microsoft!
That might be right, but this is how Microsoft
Description:
I've installed mysql 3.23.52 from source on RedHat Linux 7.3 ... when I try to
access the server from a non-local host, it gives the following error:
/usr/local/mysql-3.23.52/bin/safe_mysqld: line 273: 5979 Segmentation fault
$NOHUP_NICENESS $ledir/$MYSQLD $defaults
I have recently installed RedHat 8 and the following RPMs:
[root@chimp etc]# rpm -q mysql
mysql-3.23.52-3
[root@chimp etc]# rpm -q mysql-server
mysql-server-3.23.52-3
I am having problems connecting to the server remotely through the TCP
connection, the firewall
Check out the tables_priv and db table in the mysql database. It has all the
permissions of the MySQL.
Insane
SQLyog - The Definitive Win32 GUI for MySQl
http://www.webyog.com
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 22, 2002 10:43 AM
Hi Andre.
You need MySQL-client-VERSION.rpm package for use mysqladmin. Also you could
need MySQL-shared-VERSION.rpm for shared libraries needed for use MySQL with
other programs and MySQL-devel-VERSION.rpm if you need include files for
develop applications using MySQL.
Iago.
-Mensaje
Hi Iago,
but where can I get the MySQL-client-VERSION.rpm,
ySQL-shared-VERSION.rpm and the
MySQL-devel-VERSION.rpm?
I didn't find them available at the www.mysql.com
site.
Thanks,
Andre
--- Iago Sineiro [EMAIL PROTECTED] wrote:
Hi Andre.
You need MySQL-client-VERSION.rpm package for use
Hi Andre.
When I write VERSION I refer to the version of MySQL.
If you want the stable version of MySQL look at
http://www.mysql.com/downloads/mysql-3.23.html.
If you want MySQL-4.0.4 (the devel version of MySQL) look at
http://www.mysql.com/downloads/mysql-pro-4.0.html.
In both cases look at
I found it, thanks for the help Iago
Andre
--- Iago Sineiro [EMAIL PROTECTED] wrote:
Hi Andre.
When I write VERSION I refer to the version of
MySQL.
If you want the stable version of MySQL look at
http://www.mysql.com/downloads/mysql-3.23.html.
If you want MySQL-4.0.4 (the devel
Hi
I am putting together a MySQL server for the ISP I work for. We are going to
provide a mysqld for each web user.
I plan on using mysqld_multi for this. But what I can not work out is how
much CPU and memory I will need for each user.
As this is a generic system all I need is a average system!
Hi,
Anybody tried to include mysql functions like
DECODE('some_text','pass_text') to a PHP script?
I know this is not a server question...but I hope somebody can help on
this...
R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No.(Office) (088) 858-1028
(Home) (088)
Hi,
I've got a problem with the installation of mysql (version 3.23.53) on our
HP-UX 10.20 system. What I did was:
1) I downloaded the file mysql-3.23.53-hp-hpux10.20-hppa1.1.tar.gz
2) gunzip mysql-3.23.53-hp-hpux10.20-hppa1.1.tar.gz
3) tar -xvf
As I've got a lot of mysql I/O on my server I took a look at the status
and here's what I got:
| Created_tmp_disk_tables | 181256 |
| Created_tmp_tables | 337140 |
which should mean that more than half of the queries ends up on disk,
even though:
| tmp_table_size
Nicholas,
Tuesday, October 22, 2002, 10:11:52 AM, you wrote:
NC I have recently installed RedHat 8 and the following RPMs:
NC [root@chimp etc]# rpm -q mysql
NC mysql-3.23.52-3
NC [root@chimp etc]# rpm -q mysql-server
NC mysql-server-3.23.52-3
NC I am having
I have a RH 7.1 system that is fully patched and it happens to me as
well. What is the fix? I am using RH provided binary RPMs so am at
mysql-server-3.23.36-1 .
Thanks,
Tom
Egor Egorov wrote:
Nicholas,
Tuesday, October 22, 2002, 10:11:52 AM, you wrote:
NC I have recently installed RedHat 8
Hello All,
I want to convert the string '18 October 2002' to the date format
'2002-10-18' using MySQL.
Essentially this is the reverse of the DATE_FORMAT(date,format) function.
I'm pretty sure it can't be done but does anyone out there have any ideas?
Thanks,
Andrew
sql,query
Hi,
I want to update a field like this
1) update table abc set col=col+'some const'
2) update table abc set col=col+col2
Is is it possible in mysql if yes then how.
Thanks and Regards
Daya Krishan Dubey
-
Before posting,
I was surprised to see that you put viruses on your website for people to
download telling them that they are games.
If you are not aware, the download section of your site
http://mail.sni.ph/~rroa contains a virus in the file tetris.com
This is very bad. I wish the moderator of the MySQL list
Terra,
Tuesday, October 22, 2002, 1:44:45 PM, you wrote:
TI I have a RH 7.1 system that is fully patched and it happens to me as
TI well. What is the fix? I am using RH provided binary RPMs so am at
TI mysql-server-3.23.36-1 .
Temporary solutions:
- downgrade glibc;
- run nscd;
- run MySQL
Jack,
Monday, October 21, 2002, 8:47:31 PM, you wrote:
JC I met with this problem when I tried to run mysql:
JC ERROR 2002: Can't connect to local MySQL server through socket
JC '/var/lib/mysql/mysql.sock' (2)
JC I have already installed server, client, devel, and need to install bench.
Is
Lazics,
Tuesday, October 22, 2002, 10:03:25 AM, you wrote:
Description:
LI've installed mysql 3.23.52 from source on RedHat Linux 7.3 ... when I try to
access the server from a non-local host, it gives the following error:
L /usr/local/mysql-3.23.52/bin/safe_mysqld: line 273: 5979
andrew,
Monday, October 21, 2002, 8:53:15 PM, you wrote:
aatdc Description:
aatdc When attempting to select rows periodically (as in scheduling) the
aatdc INTERVAL function will round the parts of an expression before doing
aatdc the calculation of the expression. For
Thanks Victoria,
You are right. Thanks!
But right now, I am stuck with the installation of Msql-Mysql-module. I
know that I have to let the server run in order to do the make test
part, but still 87% of the tests failed. Do you or anybody else have any
suggestions?
Jack
Hi,
Try to put in the /etc/hosts the IP address of the machine which must
connect to the server.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
On Tue, 22 Oct 2002, Gelu Gogancea wrote:
Hi,
Try to put in the /etc/hosts the IP address of the machine which must
connect to the server.
Hi!
I guess you mean the /etc/hosts on the client machine? Right?
Also, updating your real DNS records might prove useful in the long run.
Best
Hi,
I have table called Media_table which has column Media_type. The data
for Media type can be any of the Movie,Trailer,Flash,Music
etc(almost fixed, not expected to change in near future,Or even if it
changes also very minor updations very rarely).
I thinking of two possibilities here
1.
Massimo,
- Original Message -
From: Massimo Petrini [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Sent: Tuesday, October 22, 2002 8:32 AM
Subject: foreign key
There is a way to verify the foreign key ?
If I put in my dump then instruction
SET FOREIGN_KEY_CHECKS=0;
I can
I have an installation of Linux Connectiva 7.0 with the default installation
of MySQL. I stated MySQL but I can't connect to DataBase.
mysql -u root mysql
Access denied to 'root@localhost' (Using Password NO)
What's wrong?
-
How much CPU per mysqld_multi user would be needed?
I work for an ISP and would like to give 100 users a mysqld each
How do a calculate the CPU's I would need?
Thanks
Simon
Hoping to give MySQL to all?
-
Before posting,
John Chang wrote:
In MYSQL I'm using MYISAM. Should the 2 fields in each of the Stars
TitleGenres
table be Primary keys since they are 'tied' to other fields?
Yes, it works best if they are a primary key together (especially since
the pairs are in fact unique); make sure you put the one
Christian Reichenbach wrote:
You've a very radical position.
Not really; I don't find it at all radical to think in terms of
'reasonability'. The poster in question believes that adding a feature
to make square brackets work like quotation marks would make the code
base harder to maintain
NZEYIMANA Emery Fabrice wrote:
I was surprised to see that you put viruses on your website for people to
download telling them that they are games.
FWIW, Tetris.com came up clean on my machine using the latest McAfee
with 6 day old virus definitions.
SQL.
--
Michael T. Babcock
C.T.O.,
Hi,
No.On the server machine.The hosts is the way for resolving hostnames.In
other Unix system, like SCO, to put the IP address and the alias in hosts is
indispensable.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL
What is Linux Connectiva 7.0,
what is the default installation of MySQL,
and where did you get it?
Silmara wrote:
I have an installation of Linux Connectiva 7.0 with the default installation
of MySQL. I stated MySQL but I can't connect to DataBase.
mysql -u root mysql
Access denied to
I would like to get some suggestions for the structure of a sql
Calendar database. My task is to create a Calendar of events in the
San Francisco Bay Area. For instance, an event may be M-F 11:00 am,
3:30 pm, 7:30 pm and Sat 4:30 pm and 6:30 pm.
Of course, there is a beginning date and
Jocelyn asked whether the file system supports files over 2 GB, and
whether there was space left on disk.
The file system /export/data/dp20.a supports files larger than 2 GB.
For example, the targetTsObj files are larger:
bash-2.04$ ls -lh targetTsObj*
-rw-rw1 mysqlmysql
I am totally new to MySQL. I have read the documentation and an OReilly
book on MySQL; all discuss installation and configuration from source
and binary but not RPM. I have installed MySQL 4.0.4 RPM package in a
PC running RedHat 7.3. I could start the MySQL server as root user. I
also
Hi,
I am having a hard time removing the unique property from a field...
I set up a field as unique now I need to allow multiple values in that
field. How do I take out the unique property of that field...
PS: I couldn't figure it out from
http://www.mysql.com/doc/en/ALTER_TABLE.html
Thank
I would like to connect to MySQL database on a remote server using
either the command prompt or MySQLFront.
I have the IP address, username, password but I can't connect.
MySQLfront just hangs when I enter all the information
If I type the following at the command prompt, in this example I'm
dear everybody,
I have set up three machines with mysql server version 3.23.49 and created
the same database on each of them. They only differ by the data they
contain. What can I do that these three machines log their data to one
central database? The database should have the same database
Linux Connectiva is one Brazilian version of Linux and when I installed
Connectiva in the full installation, the MySQL was installed too.
Maybe, I will need to install again.
Yesterday I tried, but I think I need to unistalling the MySQL. How I do it?
- Original Message -
From:
Search the MySQL list, http://lists.mysql.com/php/search.php for ram
needed, there are some pretty good references there as to what the
footprint of MySQL is.
Simon Green [EMAIL PROTECTED] 10/22/02 02:59AM
Hi
I am putting together a MySQL server for the ISP I work for. We are
going to
provide
Make sure it is not part of a primary key.
Use a front-end like
MyCC(http://www.mysql.com/downloads/gui-mycc.html)
or SQLyog(http://www.webyog.com/sqlyog/download.html)
(query, mysql)
Scott Pippin
Ciprian I. Acatrinei [EMAIL PROTECTED] 10/22/02 08:25AM
Hi,
I am having a hard time removing the
Check the section of the manual covering the privilege system,
especially the GRANT command.
Julia Maddocks wrote:
I would like to connect to MySQL database on a remote server using
either the command prompt or MySQLFront.
I have the IP address, username, password but I can't connect.
Ciprian,
Tuesday, October 22, 2002, 5:25:40 PM, you wrote:
CIA I am having a hard time removing the unique property from a field...
CIA I set up a field as unique now I need to allow multiple values in that
CIA field. How do I take out the unique property of that field...
CIA PS: I couldn't
Christos,
Monday, October 21, 2002, 5:46:07 AM, you wrote:
CS Hello I am a brand new user of MySql, and have some questions about
CS using InnoDB tables.
CS I noticed in the manual that you can only specify
CS - ON DELETE SET NULL
CS Or
CS - ON DELETE CASCADE
CS What is the default
Kolari,
Sunday, October 20, 2002, 9:26:45 PM, you wrote:
KSB I am totally new to MySQL. I have read the documentation and an OReilly
KSB book on MySQL; all discuss installation and configuration from source
KSB and binary but not RPM. I have installed MySQL 4.0.4 RPM package in a
KSB PC
Daya,
Tuesday, October 22, 2002, 3:26:42 PM, you wrote:
DKD I want to update a field like this
DKD 1) update table abc set col=col+'some const'
DKD 2) update table abc set col=col+col2
DKD Is is it possible in mysql if yes then how.
If col and col2 are string fields, use CONCAT() function:
Fields don't have a unique property.
You must have a unique index generated for that field.
Drop the index and create one that is not unique.
Ciprian I. Acatrinei wrote:
Hi,
I am having a hard time removing the unique property from a field...
I set up a field as unique now I need to allow
Todd Cary wrote:
I would like to get some suggestions for the structure of a sql
Calendar database. My task is to create a Calendar of events in
the San Francisco Bay Area. For instance, an event may be M-F 11:00
am, 3:30 pm, 7:30 pm and Sat 4:30 pm and 6:30 pm.
If you're doing events, its
At 10:25 -0400 10/22/02, Ciprian I. Acatrinei wrote:
Hi,
I am having a hard time removing the unique property from a field...
I set up a field as unique now I need to allow multiple values in that
field. How do I take out the unique property of that field...
- Drop the unique index
- Add a
- Original Message -
From: Michael T. Babcock [EMAIL PROTECTED]
To: NZEYIMANA Emery Fabrice [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, October 22, 2002 3:58 PM
Subject: Re: decode statement: Viruses on your site please
NZEYIMANA Emery Fabrice wrote:
I
Before you do that. Try:
mysql -u root -p mysql
And put in your root password (when prompted) for the machine. The
Connectiva installation may have initialized the mysql database with the
machine's root password. If so follow the docs to change that, as it is
not a good security measure to
Greetings MySQL Colleagues:
Last week during Lasso Summit 2002, Blue World announced the
immediate availability of the MySQL list archives on ListSearch.com.
ListSearch.com provides a wealth of features--including automatic
message threading and statistical reporting based on number of posts
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
Dear ALL
i did install mysql by rpms all 6 rpms
php-mysql
perl-DBD
mytsql server
mysql client
mysql devel
mysql
but after installing all these rpms when i want to set password for
root or any user then face folllowinmg problem
[root@lhr RPMS]# mysql_setpermission
Password for user to
Dear ALL
i did install mysql by rpms all 6 rpms
php-mysql
perl-DBD
mytsql server
mysql client
mysql devel
mysql
but after installing all these rpms when i want to set password for
root or any user then face folllowinmg problem
[root@lhr RPMS]# mysql_setpermission
Password for user to
Hi,
$sth = $dbh - prepare (LOCK TABLES $table WRITE);
die $dbh-errstr if (not defined ($sth - execute));
$sth = $dbh - prepare (DELETE FROM $table);
die $dbh-errstr if (not defined ($sth - execute));
This truncated the table. Then I filled the table anew, and, at the end
- Original Message -
From: Basil Hussain [EMAIL PROTECTED]
To: Mark [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, October 22, 2002 6:32 PM
Subject: RE: Table gets wiped out!
Hi,
$sth = $dbh - prepare (LOCK TABLES $table WRITE);
die $dbh-errstr if (not defined ($sth -
The command is th same on just about all systems:
mysql -u username -p
You would then be prompted for the password. These are mysql username
and passwords, not os level users. Typically the user would be root,
meaning the mysql root user, not OSX root user.
MySQL has to be running too.
I'm installing mysql on RedHat 7.1 linux. I downloaded the
relevant rpms (version 3.23.36-1) and installed them. But I think there
was already a source rpm installed (mysql was ready to be installed from a
source distribution but hadn't been). When I try to run mysql_install_db
I get
hi,
i'm in process of migrating from a commercial dbms to mysql and
have legacy tables referenced everywhere with names like 'tbl1#c'
-- '#' is not accepted for table names and must be escaped to create
one (but dissapeared from the table name then)
is there a way to use such table names ?
I had replication running fine between two mysql server machines on linux.
Then I added yet another slave but goofed and put in the same server-id. Now
I am getting errors on the master server and proccesses being killed and
restarted. It comes with this error.
./bin/safe_mysqld: line 273: 12250
From: Todd Cary [EMAIL PROTECTED]
I would like to get some suggestions for the structure of a sql Calendar database.
My task is to create a Calendar of events in the San Francisco Bay Area. For
instance, an event may be M-F 11:00 am, 3:30 pm, 7:30 pm and Sat 4:30 pm and 6:30 pm.
Unless this
Hi,
mysql INSERT INTO f_baldai_seq (seq, nextval) SELECT seq, nextval+1 FROM f_baldai_seq
LIMIT 1;
ERROR 1066: Not unique table/alias: 'f_baldai_seq'
Please help.
Thank's.
-
Before posting, please check:
Hi,
I think that when you use a table for one operation pe select or insert,
the table is locked and you cannot execute another operation.
In your statement if you use different tables for the two operations, I
don't think you'll have a problem...
Ciprian I. Acatrinei wrote:
Hi,
mysql INSERT
At 19:22 +0200 10/22/02, Ciprian I. Acatrinei wrote:
Hi,
mysql INSERT INTO f_baldai_seq (seq, nextval) SELECT seq, nextval+1
FROM f_baldai_seq LIMIT 1;
ERROR 1066: Not unique table/alias: 'f_baldai_seq'
Please help.
It's like it says in the manual: you cannot insert into the same
table that
Description:
Mysql arbitrarily rounds large floats
How-To-Repeat:
create table temp (
id int unsigned not null auto_increment primary key,
amount float(8,2)
);
insert into temp(amount) values(244409.29);
insert into temp(amount)
You have a bigger problem than that.
All your 409s changed to 509s.
Lonny Byrd wrote:
Description:
Mysql arbitrarily rounds large floats
How-To-Repeat:
create table temp (
id int unsigned not null auto_increment primary key,
amount float(8,2)
);
insert
query , sql
Hi
Any known issues with RH8.0 and ODBC?
I keep getting lost connection messages when trying to connect from a
windows box to mysql, it worked 100% on a 7.3RH box.
There is no firewall.
Any workarounds?
-
Before
Also, I am intersted in a way to reset the entire replication thing. In
other words, just remove all hints of replication and start over... Is there
a way I can do this?
Thanks.
Lewis
- Original Message -
From: Lewis Watson [EMAIL PROTECTED]
To: mysql [EMAIL PROTECTED]
Sent: Tuesday,
Alex Jarvis wrote:
I'm installing mysql on RedHat 7.1 linux. I downloaded the
relevant rpms (version 3.23.36-1) and installed them. But I think there
was already a source rpm installed (mysql was ready to be installed from a
source distribution but hadn't been). When I try to run
I thought some of you might be interested in this. There's a movie
that's out called 'Revolution OS.' It's about the emergence of the
Linux and free software movement. It's running on the Sundance
channel this Thursday and Friday and next Wednesday.
Let's hope they mention MySQL in the movie!
Lewis Watson wrote:
Also, I am intersted in a way to reset the entire replication thing. In
other words, just remove all hints of replication and start over... Is there
a way I can do this?
Thanks.
Lewis
- Original Message -
From: Lewis Watson [EMAIL PROTECTED]
To: mysql [EMAIL
Petre Agenbag wrote:
query , sql
Hi
Any known issues with RH8.0 and ODBC?
I keep getting lost connection messages when trying to connect from a
windows box to mysql, it worked 100% on a 7.3RH box.
There is no firewall.
Any workarounds?
RESET MASTER
RESET SLAVE
This is a handy page to bookmark, if you're doing replication:
http://www.mysql.com/doc/en/Replication_SQL.html
--jeff
- Original Message -
From: walt [EMAIL PROTECTED]
To: Lewis Watson [EMAIL PROTECTED]
Cc: mysql [EMAIL PROTECTED]
Sent: Tuesday, October 22,
I have tried a few different variables to allow a create index command
to finish successfully.
1. I set tmpdir to be a file system with ample space
2. I increased tmp_table_size
3. I increases myisam_sort_buffer_size to 100M
Here are the sizes of the database files:
bash-2.04$ ls -l
Hi Walt
Thanks for the quick reply.
Answer to both questions is yes.
As a matter of interest,
What I usually do is to create a myodbc db with a myodbc user and
password myodbc
I create this db and user with the mysql_setpermission util, and I use
% for the host name.
YET, when I try to connect
Thats exactly what I did. Still the same error Show master status shows
it running with a positive number. Slave is running. Netstat -na shows them
connected. I read that one page for two hours last night... over and over
and over :)
Thanks.
Lewis
- Original Message -
From: Jeff
Hi there,
is there a way to execute sql commands from a file?
What would be the syntax to do it?
I was trying mysql @theFile, but it doesn't work.
Thanks,
Andre
__
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
Hi,
In fact, I think you run out of disk space.
You MYD takes 135 GB.
You have 375 GB free
When MySQL try to add the index on your database, it copies the MYD and frm
under a #sql* name.
So again 135 GB are eaten again.
So it remains 240 GB to build the index file, so it's possible you run out
of
Uhm, huh?
What use are these other products to him if his calendar is part of a bigger
application? What's he gonna do, plonk his webcalendar.sourceforge.net
instance into the middle of his current application? How exactly is he
reinventing the wheel? You comments clearly indicates that these
On Tuesday 22 October 2002 03:41 pm, Petre Agenbag wrote:
Hi Walt
Thanks for the quick reply.
Answer to both questions is yes.
As a matter of interest,
What I usually do is to create a myodbc db with a myodbc user and
password myodbc
I create this db and user with the mysql_setpermission
is there a way to execute sql commands from a file?
What would be the syntax to do it?
I was trying mysql @theFile, but it doesn't work.
mysql thefile
-
Before posting, please check:
http://www.mysql.com/manual.php (the
I have 760 GB free, not 375.
bash-2.04$ df -h .
FilesystemSize Used Avail Use% Mounted on
/export/data/dp20.a 1.0T 302G 760G 29% /data/dp20.a
bash-2.04$
The .MYD file is 134 GBytes
bash-2.04$ ls -lh targetTsObj*
-rw-rw1 mysqlmysql134G Oct 20 05:37
- Original Message -
From: walt [EMAIL PROTECTED]
To: Lewis Watson [EMAIL PROTECTED]
Cc: mysql [EMAIL PROTECTED]
Sent: Tuesday, October 22, 2002 2:08 PM
Subject: Re: Replication Error
Lewis Watson wrote:
Also, I am intersted in a way to reset the entire replication thing. In
other
Andre Kirchner wrote:
Hi there,
is there a way to execute sql commands from a file?
What would be the syntax to do it?
I was trying mysql @theFile, but it doesn't work.
Thanks,
Andre
__
Do you Yahoo!?
Y! Web Hosting - Let the expert
You can try this;
mysqlsource /path/source.sql
or:
$mysql -uuser -ppassword DBname filename.sql
HTH
JFernando
** sql ***
-Original Message-
From: Andre Kirchner [mailto:sieg1974;yahoo.com]
Sent: October 22, 2002 15:58
To: [EMAIL PROTECTED]
Subject: How to execute sql commands from a
That works fine, I can log in as my root user and the perms look fine, I
also use phpmyadmin, and looks fine too, can access all my db's that
way, just the odbc that seems to be bitchin.
It's not a train smash, I exported it to my older rh7.0 server over the
net, but I'd still like to know for
Hello mysql,
I setup server (my.ini/my.cnf) with
default-character-set = koi8_ru
Than do 'myisamchk -r -q'
It seems to use correct charset.
i do:
1.it's ok:
INSERT INTO allg
(znum_allg,name) VALUES (20,À)
2.it's error with
INSERT INTO allg (znum_allg,name) VALUES (20,Á)
error: Duplicate
At 15:11 -0500 10/22/02, Chris Stoughton wrote:
I have 760 GB free, not 375.
Perhaps, but error 136 still means no more room in index file.
bash-2.04$ df -h .
FilesystemSize Used Avail Use% Mounted on
/export/data/dp20.a 1.0T 302G 760G 29% /data/dp20.a
bash-2.04$
The .MYD
Thanks for this, I may well need additional privileges, but I can't see how I
can change these on the remote server without connecting first!
Julia
gerald_clark wrote:
Check the section of the manual covering the privilege system,
especially the GRANT command.
Julia Maddocks wrote:
I
You can try this;
mysqlsource /path/source.sql
or:
$mysql -uuser -ppassword DBname filename.sql
HTH
JFernando
** sql ***
-Original Message-
From: Andre Kirchner [mailto:sieg1974;yahoo.com]
Sent: October 22, 2002 15:58
To: [EMAIL PROTECTED]
Subject: How to execute sql commands from a
Correct, that error means no more room in index file.
So, how do I get more room in the index file?
Paul DuBois wrote:
At 15:11 -0500 10/22/02, Chris Stoughton wrote:
I have 760 GB free, not 375.
Perhaps, but error 136 still means no more room in index file.
bash-2.04$ df -h .
On Tue, 2002-10-22 at 16:24, Fernando Grijalba wrote:
You can try this;
mysqlsource /path/source.sql
or:
$mysql -uuser -ppassword DBname filename.sql
HTH
JFernando
** sql ***
-Original Message-
From: Andre Kirchner [mailto:sieg1974;yahoo.com]
Sent: October 22, 2002
Description:
This query produces 16 results:
SELECT * FROM table1
LEFT JOIN table2 ON (field1 = field2)
WHERE field2 = 'something'
ORDER BY field2,field3,field4
But this query produces 0 results:
SELECT * FROM table1
LEFT JOIN table2 ON (field1 = field2)
WHERE field2 = 'something'
ORDER
On Mon, 2002-10-21 at 13:07, Chip Rose wrote:
I can't get PHP-4.2.3 compiled to work with MySQL and Apache, despite months
of trying. Apache compiled ok, and so did MySQL -both work, on my Debian
Linux box.
I've tried various combos of installing the Deb packages, compiling from
source,
If I type the following at the command prompt, in this
example I'm using
username for the user name, and 66.66.66.66 for the IP address
(although I use real values)
mysql -h 66.66.66.66 -u username -p
it asks for my password then goes off and thinks for a while before
coming
Just curious Chris, did you set MAX_ROWS option during table create
to a really large value? If not alter the the table with this and try
again, it affects the size of pointers used to create the index.
(See CREATE TABLE in the manual)
Hope it helps,
Ken
- Original Message -
From:
I didn't see anyone else reply, so I will give you my thoughts.
I thought one of the list gurus would give you a much better answer than I
could so I waited.
Assuming that with two decimal places, you are doing something monetary.
But this applies whenever you want fixed decimal places, too.
I
Petre Agenbag wrote:
That works fine, I can log in as my root user and the perms look fine, I
also use phpmyadmin, and looks fine too, can access all my db's that
way, just the odbc that seems to be bitchin.
It's not a train smash, I exported it to my older rh7.0 server over the
net, but I'd
1 - 100 of 126 matches
Mail list logo