Dear friends,
I am using mysql 3.23.58-max. Want to create database
Entered
mysql>CREATE DATABASE[IF NOT EXISTS] db_anyname
--
-
it gives me response of too many paramaters. Can anyone advice, please.
Delmar.
If I understand correctly, your text file does not have an ID for each
row, but the table does have an ID column. Good. Your table should
have the record ID column defined as AUTO_INCREMENT. Something like
CREATE TABLE table_name (
ID int NOT NULL PRIMARY KEY AUTO_INCREMENT,
other column
I'm running mysql 4.0.17 on Mac OS X 10.2.8 without problems. My first
guess would be that the upgrade reset the permissions on /tmp, so now
the mysql user doesn't have permission to create mysql.sock.
Try
cd /tmp
sudo chmod 1777 .
then see if mysqld will start. (While you're in /tmp, mak
I have a table which contains many items. Each item consists of an
scriptID, several attributes, and an optional field - a "parent" (called
"dupeitem" in the database) item. Most all of these fields are strings -
even the IDs which consist of a combination of letters and numbers. Items
which hav
landon kelsey wrote:
I run safe_mysqld out of /usr with ./bin/safe_mysqld &
/var/log/mysqld.log
868 031219 20:52:52 mysqld started
869 Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
870 If you do not want to use transactional InnoDB tables, add a line
871 skip-innodb
I have a table like this: tb(ke varchar(10),kc varchar(10),...) where ke contains
ascii string while kc contains dbcs string in UTF8. The
character_set_server(system,database,client,connection) are all utf8. I have no
problem to query the table using "like 'xx%' " against column ke with xx as as
I run safe_mysqld out of /usr with ./bin/safe_mysqld &
/var/log/mysqld.log
868 031219 20:52:52 mysqld started
869 Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
870 If you do not want to use transactional InnoDB tables, add a line
871 skip-innodb
872 to the [mysqld]
We're running MySQL 3.23.56 w/ InnoDB on Red Hat Linux 8.0,
compiled natively with bundled gcc:
# gcc -v
Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
--infodir=/usr/share/info --enable-shared --enable-threads=p
I had an account "mike" to mysql. But somehow I change the password. So now
I have just one access to the system as root.
Trying to login to mysql as root with password and without password no
success. Root password is: 123456.
What I'm doing wrong? I cannot connect to MYSQL as root.
[EMAIL PRO
I am working on an application for both windows and linux that will be
used as both a stand alone desktop application and as a client server
application. For the users who are using it as a standalone product I
want to embed MySQL into my program so the users don't have to install
MySQL to use
Hi,
I've recently been having some problems with mySQL on one of my OS X
computers. It was working perfectly until I upgraded from OS 10.2.6 to
OS 10.2.8, and now mysqld refuses to start up, showing the following
--
[EMAIL PROTECTED] mysql]$ sudo ./bin/mysqld_safe
Starting mysqld daem
At 11:16 -0600 12/19/03, Victor Pendleton wrote:
You will need to place the following at the head of your dump file.
SET FOREIGN_KEY_CHECKS=0
Also, in MySQL 4.1, mysqldump does this automatically. It puts out
the following at the beginning of the dump file:
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQU
At 16:26 -0800 12/19/03, K Q-B wrote:
I am creating a table and would like to use auto
increment, but I would like one column to increment in
only odd numbers 1,3,5... and another column of the
same table to increment in even numbers 2,4,6...
Is it possible to do this?
Not using an AUTO_INCREMENT c
On Fri, 19 Dec 2003, K Q-B wrote:
> I am creating a table and would like to use auto
> increment, but I would like one column to increment in
> only odd numbers 1,3,5... and another column of the
> same table to increment in even numbers 2,4,6...
>
> Is it possible to do this?
Not without a little
At 22:37 + 12/19/03, Mike S wrote:
I want to stop replication for one table in the database. According
to the mysql documentation: I need to add the parameter
(replicate-wild-ignore-table ) to the my.cnf file. I have some
question.
#1 In what database I should made the change to my.cnf? Sla
Hi Mark,
I'll tell you what I know. :-)
First, AVG_ROW_LENGTH is only needed for dynamic row-length tables (it's
ignored with fixed-length rows) -- more specifically, those with
TEXT/BLOB columns. Otherwise, if MAX_ROWS is used, MySQL will assume
that each TEXT/BLOB column will be filled complet
I am creating a table and would like to use auto
increment, but I would like one column to increment in
only odd numbers 1,3,5... and another column of the
same table to increment in even numbers 2,4,6...
Is it possible to do this?
Thanks,
KB
__
Do you Yahoo!?
New
I want to stop replication for one table in the database. According to the
mysql documentation: I need to add the parameter
(replicate-wild-ignore-table ) to the my.cnf file. I have some question.
#1 In what database I should made the change to my.cnf? Slave or Master?
#2 Than I should restart t
If you have a need for User Defined Functions in MySQL, now you can
write them in java. (As well as C++, perl, python, or php, of course.)
If you think java UDFs might be handy, please try it out and send some
feed back my way. Please keep in mind that this is alpha code, so you
probably don't wan
Ok, i have send them to your mail. I add a thing : when i stop the mysql
service, it take 1mn and freeze my computer cause it take 100% CPU.
At 20:48 19/12/2003, Victor Pendleton wrote:
Can you show us the output from the
show processlist;
command?
-Original Message-
From: Rezo [mailto:[E
Ok, i have send them to your mail. I add a thing : when i stop the mysql
service, it take 1mn and freeze my computer cause it take 100% CPU.
At 20:48 19/12/2003, Victor Pendleton wrote:
Can you show us the output from the
show processlist;
command?
-Original Message-
From: Rezo [mailto:[E
On Dec 19, 2003, at 12:58 AM, Trebor Scholz wrote:
I'd like to install mysql on OSX Panther.
In my tutorial it suggests to switch
Web Sharing off in the preferences but
There are many options in the menu there and web sharing off
Is not one of them.
Perhaps they mean to go to the System Preferenc
Can you show us the output from the
show processlist;
command?
-Original Message-
From: Rezo [mailto:[EMAIL PROTECTED]
Sent: Friday, December 19, 2003 1:38 PM
To: [EMAIL PROTECTED]
Subject: RE: MySQL runs slow on windows 2003
Yes i'am french !
I join to your mail a capture of my task l
Yes i'am french !
I join to your mail a capture of my task list.
At 20:25 19/12/2003, Victor Pendleton wrote:
What does your Windows Task list --> Processes show when you are running at
a high cpu usage?
Is French your native language?
-Original Message-
From: Rezo [mailto:[EMAIL PROTECTE
What does your Windows Task list --> Processes show when you are running at
a high cpu usage?
Is French your native language?
-Original Message-
From: Rezo [mailto:[EMAIL PROTECTED]
Sent: Friday, December 19, 2003 11:51 AM
To: [EMAIL PROTECTED]
Subject: RE: MySQL runs slow on windows 2003
Hi,
I'd like to install mysql on OSX Panther.
In my tutorial it suggests to switch
Web Sharing off in the preferences but
There are many options in the menu there and web sharing off
Is not one of them.
Any suggestions?
Best,
Trebor
--
MySQL General Mailing List
For list archives: http://list
Sorry in advance for the dumb newbie question but . . . I'm using a
content management system and want to avoid the hassle of entering data
by hand when I've already got it in a delimited text file. I get the
basic concept of using mysqlimport. However, the source file's data
doesn't match the ta
Hello,
I was able to duplicate the following sequence in both
4.0.14-max and 4.0.16. It happens in all my tables. I do not understand
why the cardinality for the date_created field does not = 223284.
mysql> select count(distinct date_created) from POSTING ;
+-
Sorry, i dont speak a very good english.
mysqld-nt.exe run with IIS 6.0 and it execute ASP pages. There is nothing
else that run expect that.
At 18:17 19/12/2003, you wrote:
What is the MySQL process running at during this time?
-Original Message-
From: Rezo [mailto:[EMAIL PROTECTED]
Se
I tried as advised as follows :
I tried to uninstall mysql rpm as
rpm -e /var/lib/mysql
It gives following.
[EMAIL PROTECTED] root]# rpm -e /var/lib/mysql
error: package /var/lib/mysql is not installed
[EMAIL PROTECTED] root]# rpm -e MySQL-server-4.0.16-0.i386.rpm
error: package MySQL-server-4.0
What is the MySQL process running at during this time?
-Original Message-
From: Rezo [mailto:[EMAIL PROTECTED]
Sent: Friday, December 19, 2003 9:19 AM
To: [EMAIL PROTECTED]
Subject: MySQL runs slow on windows 2003
Hello,
I have upgraded win 2000 to 2003 and since this moment, MySQL 4.0.
You will need to place the following at the head of your dump file.
SET FOREIGN_KEY_CHECKS=0
-Original Message-
From: sean peters [mailto:[EMAIL PROTECTED]
Sent: Friday, December 19, 2003 10:28 AM
To: [EMAIL PROTECTED]
Subject: mysqldump table order with foreign keys
Hey all,
I'm tryi
The query in question:
SELECT switch, hostname, INET_NTOA(it_iFace.ip) AS IP, location,
contact, port
FROM cam
LEFT JOIN iFace ON ( switch = it_iFace.hostID )
LEFT JOIN host USING ( hostID )
LEFT JOIN arp ON ( cam.mac = arp.mac )
WHERE arp.ip <=> if( "" = "",NULL,INET_ATON("") );
(both instances
Hi!
I have a simple webapp that allows users to register. The user is inserted
in the DB and a confirmation mail is sent to the user.
If the mail fails I'd like the DB to rollback the transaction, but it
doesn't do it. The new user entry is kept in the DB.
I'm using Tomcat 4.1 and mySQL 2.3.2.
I
Hey all,
I'm trying to dump the structure of a database using:
mysqldump -d myDatabase > structure.sql
Which works fine in getting the table create statements, but, how do i get
mysqldump to put the creates in an order that will allow replication with
foreign key concerns.
For instance if i
yes, just a typing mistakes~~
anyway, both of them work fine.
"gerald_clark" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> DId I type that?
> I meant 1,4
> I left it as substring because that was what he tried.
>
> ¿n©_ ¡E¢X ¡¸ wrote:
>
> >yes, it should work, but should not be
Hi all,
At table creation time I can use MAX_ROWS and AVG_ROW_LENGTH to
(a) limit the size of a HEAP table
(b) overcome MyISAM's default 4GB limit
But are they used in any other ways? Does MySQL use them to improve
performance by sizing buffers appropriately or to prevent fragmentation in
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bill Ataras wrote:
> Thanks. Yeah I saw the section on failover. I guess I didn't understand
> that autoreconnect in the url is now used for failover to another server
> rather than reconnecting to the same server. Is that what you mean? If
> that's t
Hello,
I have upgraded win 2000 to 2003 and since this moment, MySQL 4.0.17 run
very slow. CPU usage is always between 60 to 100%.
Where i can found a solution ?
Thanks a lot.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.
Hi!
What MySQL version you are running?
Can you show us your my.cnf, so that we see how much memory you had
allocated to the InnoDB buffer pool?
Did you run some big DELETE, UPDATE, or SELECT ... FOR UPDATE, or SELECT ...
LOCK IN SHARE MODE query at that time, so that you could really exhaust al
is there any difference between:
a)
>>select lname, fname
>>from person_tb, details_tb
>>where mem_id = det_id
>>and fin = "y";
and
b)
select lname, fname
from person_tb
where mem_id in (select det_id from details_tb where fin = "y")
which one will execute faster ?
--
MySQL General Mailing
Trevor Rhodes wrote:
Hello All,
person_tb contains mem_id, lname and fname
details_tb contains det_id and fin.
They both contain other fields, but I don't care about them at this time. I'm
trying the following
select lname, fname
from person_tb, details_tb
where mem_id = det_id
and fin = "y"
landon kelsey wrote:
(1) performed a standard install of Redhat Linux 9 months ago...now
(I found mysql 3.23.52 installed)
Under root, I executed mysql_install_db successfully:
showing:
installing all prepared tables
031219 0:44:16 /usr/libexec/mysqld: Shutdown Comp
Hi,
Does anyone know what privileges are required for a user to be able to
call statements that control replication?
Just to clarify exactly what I mean here:
I am writing a module to manage fail-over if a master db dies and would
ideally like to be able to run the app. without having to grant i
Hello all,
I have a simple MySQL replication system setup with a single master and
a single slave. The slave is running 4.0.16-standard and the master is
running 4.0.16-standard-log.
On an (almost) daily basis, I get this error on my slave:
031216 9:55:44 Error reading packet from server: l
[EMAIL PROTECTED] wrote:
>
> I downloaded mysql on windows 98.
> I entered
> cd c;\mysql_install_db
> It is responding as "too many parameters"
> Can anyone advice how to fix it, please.
You don't need to run mysql_install_db script if you install MySQL server on Windows.
--
For technical s
i'm root!!
***
Carlos Andre Moura de Amorim --> Funcionario UNCISAL
--> Tecnico de Informatica CEFET-AL
--> Acad. de Mecicina UNCISA
what distro are you using? what is running on this server? another
server is runnin' on the same machine? what hardware are you using? is
it heavy loaded?
On Fri, 2003-12-19 at 09:54, Carlos Andrà Moura de Amorim wrote:
> i added ulimit -n 1024 in mysql_install_db, i can't to install. Appear th
You must be 'root' to do a "ulimit -n 1024".
Marc.
-Message d'origine-
De : Carlos André Moura de Amorim [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 19 décembre 2003 14:55
À : Chris Elsworth
Cc : [EMAIL PROTECTED]
Objet : Re: Help me - please
i added ulimit -n 1024 in mysql_install_db,
i added ulimit -n 1024 in mysql_install_db, i can't to install. Appear the
error again. Please again!!!
On Thu, 18 Dec 2003, Chris Elsworth wrote:
> On Thu, Dec 18, 2003 at 05:28:30PM -0200, Carlos Andr? Moura de Amorim wrote:
>
> > 031217 14:32:34 Warning: setrlimit couldn't increase number o
ads mysql <[EMAIL PROTECTED]> wrote:
>
> I have intstalled mysql rpm.
> By mistake user table entries are deleted. Therefore I could not access mysql.
>
> I want uninstall the same and reinstall it.
>
If you want to re-create privilege tables you should move directory 'mysql' to another
place
I have intstalled mysql rpm.
By mistake user table entries are deleted. Therefore I could not access mysql.
I want uninstall the same and reinstall it.
Please guide me how to do that .
Thanks
-
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing
Hi,
This isn't MySQL specific, but it's very interesting and I thought people
may be interested.
http://www.tbray.org/ongoing/When/200x/2003/07/30/OnSearchTOC
Cheers,
Andrew
SQL, Query
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lis
Hi Sergei!
Thanks for replying again. I hope I'm not wasting too much of your time
with my questions! :-)
- Original Message -
From: "Sergei Golubchik"
Sent: Thursday, December 18, 2003 7:17 AM
Subject: Re: How boolean full-text search finds matches?
> Hi!
>
> On Dec 17, Matt W wrote
I believe there are some arm binaries for MySQL available but compiled
only for Linux. I've not seen any WinCE ones.
See www.handhelds.org for Linux pocketpc distributions.
John.
On Thu, 2003-12-18 at 22:20, Matt Lynch wrote:
> Hi,
>
> Does anyone know of a MySQL distribution for the PocketPC?
Hi,
I can't seem to find any problems, except for the few duplicate indexes in
tbl_klanten, tbl_v_levering, tbl_v_bestelbon - when you have PRIMARY KEY (klant_id)
you don need to add KEY klant_id (klant_id).
I created the tables on a 4.0.12 server and the EXPLAIN returned EQ_REF on both
qu
Hi!
Was 'mysql_connect' purposely excluding from libmySQL.dll export clause or
by accident?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
>
> I am new to MySQL and can not find how to do this. I am running 4.0.16. Table1
> has the correct values for a common field. Table 2 (the real one) needs to be
> updated from t1 via a common field.
>
> Can this be done with joins. And if not what is the best way.
Hello All,
person_tb contains mem_id, lname and fname
details_tb contains det_id and fin.
They both contain other fields, but I don't care about them at this time. I'm
trying the following
select lname, fname
from person_tb, details_tb
where mem_id = det_id
and fin = "y";
but it is giving me
Thanks. Yeah I saw the section on failover. I guess I didn't understand
that autoreconnect in the url is now used for failover to another server
rather than reconnecting to the same server. Is that what you mean? If
that's the case I can move to dbcp or something that should handle stale
connection
"xian ting" <[EMAIL PROTECTED]> wrote:
> in sql: insert into table select from ...
> can select from a remote data base server such as sqlserver using odbc
> as 'SELECT * into test01 FROM Fund IN [ODBC] [ODBC;Driver=SQL
> Server;UID=admin;PWD=;Server=(lacal);DataBase=CMBXMDM;]'in access.
> thanks
Hello Binay.
Friday, December 19, 2003, 2:04:51 PM, you wrote:
B> Hi Andrey,
B> many thanks for quick response. plz find my further query below.
>> AFAIR, you usu. do that with:
>> LOCK TABLE mytbl WRITE;
>> // do smth. here
>> UNLOCK TABLE mytbl;
B> ++
B> How can i achieve the
* rmck <[EMAIL PROTECTED]> [2003-12-19 01:24 +0100]:
> I'm trying to uderstand the difference between these tables
> (mysql.user, mysql.db) v.4.0. [...] I'v looked at the manual, but I'm just
> not getting it... Can someone break it down for me...
Very rough explanation:
- the user table contai
(1) performed a standard install of Redhat Linux 9 months ago...now
(I found mysql 3.23.52 installed)
Under root, I executed mysql_install_db successfully:
showing:
installing all prepared tables
031219 0:44:16 /usr/libexec/mysqld: Shutdown Complete
To start mys
Hi Andrey,
many thanks for quick response. plz find my further query below.
- Original Message -
From: "Andrey Subbotin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 19, 2003 12:27 PM
Subject: Re: Locking the tables
>
> Hello Binay.
> Friday, December 19, 2003, 1:5
65 matches
Mail list logo
