Hello guys,
Im kinda new at creating databases thru the command line
When I try to login using.
Mysql -h hostname -username -p
I get this message on command line.
C:\Documents and Settings\Karl Jamesmysql -h hostname -u username -p
-p;
'mysql' is not a recognized as a internal or exteranl
Asif,
- Original Message -
From: Asif Iqbal [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, July 31, 2003 10:41 PM
Subject: Mysqld is keep crashing
This is what I bumped into now
030731 15:39:50 mysqld started
030731 15:39:52 InnoDB: Database was not shut
anyone have a good sample script of connecting mysql from C API? thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Jeremy
I'm planning to use a dual xeon 2.8Ghz and 6/8 gb ram
on the database server.
Redhat 9 is the o.s.
Applications (perl dbi) will reside on other boxes.
What hw/o.s. are you using?
Can you send me your variables (max connections etc.) ... just for a check
;)
Thanks!!
|-Original
Thanks Roger, I will give it a bash.
PS, just to get my head around things.
The distinct clause will return only one occurrance of the implicated field.
distinctrow would do the same, but for an entire row. what I am looking for
is something like distinctset(field1,field2,field7) , is this what
According to the manual mysql server goes away automatically after 8 hrs
(by default). I changed wait_timeout and tried to recreate the problem but
no luck! I can access the server even after 8 inactive hrs.
Please help.
Anubrata
--
MySQL General Mailing List
For list archives:
Hi,
I want to backup some data from a database. In previous releases when I
backuped a database to a file I got inserts each in one line, separated
with semicolon. It was very comfortable, because I could very easy edit
the file, change something and give it to the database. Now after the
backup
[EMAIL PROTECTED] wrote:
The manual page for MERGE tables states the code is in gamma since 3.23.25.
But it also says you can only SELECT, DELETE, and UPDATE, which isn't true
since version 4.0.something.
Can anyone verify if the MERGE tables is still in gamma? We occassionally
have
How do i use the UPDATE statement to update a range of Primary Key id
numbers. (let say 100 through 1000).
Example,
UPDATE testTable set testField='' WHERE
test_id in (100:1000);
how about
UPDATE testTable set testField='' WHERE
test_id = 100 and test_id = 1000;
or just:
expr BETWEEN
Ralph Guzman wrote:
I have to do a catalog search through multiple tables and columns for
product model number, description, and name. I realize that doing
pattern matching with multiple LIKE statements is slow so I found that
FULLTEXT searches is a better alternative.
I have added a FULLTEXT
Dear Ladies and Sirs,
can anyone give me a hint please, if it is possible toimport data data from
a zipped File,
without unzipping it before.
I'm using MySQL 3.23 on a LINUX System.
I guess it is possible using a 'named pipe' and 'funzip' , but I don't lnow
how.
Thank you
Klaus
--
Morten Gulbrandsen [EMAIL PROTECTED] wrote:
mysql SHOW VARIABLES LIKE have_innodb;
+---+--+
| Variable_name | Value|
+---+--+
| have_innodb | DISABLED |
+---+--+
1 row in set (0.02 sec)
mysql
===
Goodygood, Victoria
Hi all
I want to provide a list of up to 20 online users on our network of
football forums, but would like to list those live on the current team
first, before filling any remainder with those online using a
different team. I couldn't see any way of getting it all into one
select (which in
Thank you for pointing that out Kaarel you saved me some time.
I wonder, Patric, if you ever read the source code of the OS you are
developing for or if you ever read the source of the compilers you use
because it is most likely that there are bugs and following your
argumentation: a feature is
Ralph Guzman [EMAIL PROTECTED] wrote:
I have to do a catalog search through multiple tables and columns for
product model number, description, and name. I realize that doing
pattern matching with multiple LIKE statements is slow so I found that
FULLTEXT searches is a better alternative.
I
Karam Chand [EMAIL PROTECTED] wrote:
Greetings
I have MySQL 4.0.14 running on WinXP.
Whenever I create a temporary table from an existing
table that has multiple keys ( the temporary table has
columns reordered from the original table ) with a
query like -
create temporary table if
Mysql [EMAIL PROTECTED] wrote:
Mysql is in default directory
my.ini - sure looks correct accourding to manual
Trying to start frist time using command:
C:\mysql\bin\mysqld --standalone
Yields this error message: Can't fine
messagefile'C:mysqin\share\english\errmsg.sys'aborting
Anubrata Chakrabarti [EMAIL PROTECTED] wrote:
According to the manual mysql server goes away automatically after 8 hrs
(by default). I changed wait_timeout and tried to recreate the problem but
no luck! I can access the server even after 8 inactive hrs.
If you use mysql command line client
Hi!
On Aug 01, Maciej Bobrowski wrote:
Hi,
I want to backup some data from a database. In previous releases when I
backuped a database to a file I got inserts each in one line, separated
with semicolon. It was very comfortable, because I could very easy edit
the file, change something
--opt Same as --add-drop-table --add-locks --all --quick
--extended-insert --lock-tables --disable-keys. Enabled
by default, disable with --skip-opt.
Fine, --skip-opt works great.
Tkanks a lot,
regards,
Maciej
--
MySQL General Mailing List
For
Thanks!
I did that and started mysql as : safe_mysqld --interactive_timeout=10
But it DOESN't go away after 10 secs.
On Fri, 1 Aug 2003, Victoria Reznichenko wrote:
Anubrata Chakrabarti [EMAIL PROTECTED] wrote:
According to the manual mysql server goes away automatically after 8 hrs
(by
Hi group,
I have two mysql-Innodb server(4.0.13) with replication enabled in that.
server A Server B
I have the database dump of server B. In server B, I have enabled the log-
bin, log-slave-update in server B.
In case of database crash, How can I restore the data from log file. I know
I am a Windows User and very used to the Dos Prompt. Can someone please
tell me what the Shell Prompt is?
What I am asking is the difference between a shell and a dos prompt
vis-a-vis mysql.
Thank you.
Ola
My ibdata1 file is growing. Do I need to worry about that ? I am guessing it
will automatically delete old data to fit the size, correct ? Also how do I
limit the growth size. I tried to put max:2000M , but since my Innodb is
crashing and can't restart mysql I removed the whole my.cnf file all
A shell prompt is the Unix/Linux equivalent of the DOS prompt. Since you
have the choice of several different operating systems shells to work in
(Bourne shell - sh, Korn shell - ksh, C shell - csh, Bourne Again shell -
bash (my favorite), etc) the command line prompts are generically referred
to
It's conceptually the same. Both allow you to enter in commands to either
execute code in batch or enter program names to be excuted. I'm not sure
about Win platforms. But, in the *.nix environments you have a choice
of different shells. And, also you can run things in the background and
a host of
Hi
Thanks to everybody who told me how to store a BMP image as a BLOB using the
LOAD_FILE.
Now I would like to now if there is a function that does the opposite to
LOAD_FILE?
I have tried using SQLFetch after using a SQLBindCol, but all I get returned
is the first 4 bytes even if the size of
Hey Enserink, your mail have virus!, please before sending mail please
check your machine!!!.
- Original Message -
From: W. Enserink [EMAIL PROTECTED]
Sent: Friday, August 01, 2003 8:43 AM
Subject: copying a
Hi all,
Im in need of some tps.
I want to copy a row in a table to a
There is absolutely no difference. Shell prompt is used in *nix because of
the different shells you can work in but it all comes down to the same
thing.
Just type what is asked at the DOS prompt and it will work. The only part
that won't work is the file in the mysql/scripts directory as they are
Andreas,
I don't know of a standard for naming such things. My advice is to group
your table names with a prefix if they are related to one another. Name
fields in such a way that the field's *purpose* is clear to you;
e.g.-checked_out_by, checked_out_date, is_checked_out, etc. Make
It depends on what you want to know.
I used _Fundamentals of Database Systems_ (Elmasri and Navathe) when I took
a DB course. It was pretty good, though my impression is that there might
be a classic which is better.
The problem with the more MySQL-specific books is that you might not learn
the
karl james [EMAIL PROTECTED] wrote:
Im kinda new at creating databases thru the command line
When I try to login using.
Mysql -h hostname -username -p
I get this message on command line.
C:\Documents and Settings\Karl Jamesmysql -h hostname -u username -p
-p;
'mysql' is not a recognized
reason to to many connections
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dear Ladies and Sirs,
can anyone give me a hint please, if it is possible toimport
data data from a zipped File, without unzipping it before.
I'm using MySQL 3.23 on a LINUX System. I guess it is
possible using a 'named pipe' and 'funzip' , but I don't lnow how.
I've used Perl and the
Morten Gulbrandsen [EMAIL PROTECTED] wrote:
USE company;
DROP TABLE IF EXISTS EMPLOYEE;
CREATE TABLE EMPLOYEE
(
# PK
SSN CHAR(9) NOT NULL,
# FK
SUPERSSNCHAR(9),
DNO INT NOT NULL DEFAULT 1,
CONSTRAINT EMPPK
PRIMARY KEY (SSN),
Hi programmers,
according to the manual,
There are two option files with the same function:
`C:\my.cnf', and the `my.ini' file in the Windows directory.
Is it sufficient with only one of the files ?
I have only my.ini
For which purpose is my.cnf , please?
Yours Sincerely
Morten
I installed MySQL 4.0.4-beta from a cdrom that came with the book Teach yourself PHP,
MySQL and Apache (a SAMs publication) on a linux 7.2 OS. I installed the binary
distribution and attempted to follow the directions from the included manual.
When I execute the command:
.bin/safe_mysqld
tuncay bas [EMAIL PROTECTED] wrote:
reason to to many connections
Look at:
http://www.mysql.com/doc/en/Too_many_connections.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___
Hello list,
is there a common naming system for db objects ?
Thousands.
Like:
1) Tables: mytable, tblmytable, tbl_mytable
2) Indices: idx_anindex
3) Columns: int_somenumber, date_lastupdate
4) id for the numerical primary key e.g. table customers.id
and then for referencing
I have tried to remove myself from this list, but the unsubscribe
function does not function. How does one get off of this list?
At the risk of sounding condescending
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
Is at the bottom of every message.
Also if that doesn't
[EMAIL PROTECTED] wrote:
it's like bash_history.. command history (used with up/back key mostly)
You want to get rid of it for good: ln -sf /dev/null .mysql_history
or run mysql client with -q option.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This
Morten Gulbrandsen [EMAIL PROTECTED] 08/01/03 07:22AM
Hi programmers,
according to the manual,
There are two option files with the same function:
`C:\my.cnf', and the `my.ini' file in the Windows directory.
Is it sufficient with only one of the files ?
I have only my.ini
For which purpose
Its doesn't look like you are starting the process as root. Turn into
root then start the process. Then exit turn back into you're user
account and use mysql.
Regards,
A$
- Original Message -
From: Jbo [EMAIL PROTECTED]
Date: Thursday, July 31, 2003 10:26 pm
Subject: Newbie question
Jim,
Great question!
I use the ol'Reddick VBA naming conventions.
tbl - table
idx - index
fld - field
You can search them in google, but I'd like to know if MySQL has its
own established conventions too.
Regards,
A$
- Original Message -
From: Jim Smith [EMAIL PROTECTED]
Date:
Primaria Falticeni [EMAIL PROTECTED] wrote:
1. Is it a way to grow the speed of the replication out of the
master-connect-retry variable?
What do you mean speed of replication?
2. I backup the databases. Assuming that the last relay log file is
sql-relay-bin.005 and the last bin log
I am studying the scalability of MYSQL on SMPs on Linux. I am wondering
if
any one has performed scalability studies. If so, I would be interested
in
a pointer to the results; if not, I am curious if there is interest in
MYSQL's scalability. Pointers to benchmarks used to study MYSQL would
Hi,
Would anyone explain me why the startup scripts check
for command line arguments and the contents of
/etc/my.cnf right after setting the env variables such
as basedir, pid-file and so?
if the MySQL code and scripts are expected to be on a
specific hardcoded location (yeah, right we could
Hi!
On Aug 01, Dan Muey wrote:
Dear Ladies and Sirs,
can anyone give me a hint please, if it is possible toimport
data data from a zipped File, without unzipping it before.
I'm using MySQL 3.23 on a LINUX System. I guess it is
possible using a 'named pipe' and 'funzip' , but I
Wasn't my question.
Why do you need to label a table as a table? There is some merit in using
type prefixes in VB because of its loose typing, but it makes no sense in a
database context where the types of objects are quite distinct.
-Original Message-
From: Adam Fortuno KOVICK
Hello.
I need to run a query written in a file from inside mysql console, not
shell prompt.
Anyone can help me?
Thanx
Lorenzo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
On Fri, Aug 01, 2003 at 04:55:09PM +0200, Lorenzo Rossi wrote:
I need to run a query written in a file from inside mysql console, not
shell prompt.
Anyone can help me?
mysql help
MySQL commands:
Note that all text commands must be first on line and end with ';'
help(\h)Display
Jim,
Habit. I look at so many objects I don't know what I would do if they
weren't prefixed with a type.
I still didn't answer your question on why should you use them, but
this is why I do.
Regards,
A$
- Original Message -
From: Jim Smith [EMAIL PROTECTED]
Date: Friday, August 1,
Hi,
my help command displays not so many options :(
Thanx a lot, bye.
Lorenzo
Fred van Engen wrote:
Hi,
On Fri, Aug 01, 2003 at 04:55:09PM +0200, Lorenzo Rossi wrote:
I need to run a query written in a file from inside mysql console, not
shell prompt.
Anyone can help me?
mysql help
Hi all,
I'm fairly new to MySQL and have the following scenario:
The Table-A below was converted from a Filemaker Pro database. The color
field was a value list in the FMP database that converted over as a text
field. The color field contains all the selected values in the value list
(from the
Is there a pdf format of this ibman page ? OR is there a good book on
Mysql+innodb out there ?
Thanks
On Fri, 1 Aug 2003, Heikki Tuuri wrote:
Asif,
- Original Message -
From: Asif Iqbal [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, July 31, 2003 10:41 PM
Hi,
I have a table:
mysql describe archivetable;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| sessionid | char(10) | | PRI |
I'm running mySql 3.23 on OS X 10.2 and I've reached a bit of an
impassse with mysqlhotcopy, after having to re=install dbd and dbi, I
keep getting the error:
DBD::mysql::db do failed: You have an error in your SQL syntax near '`
READ, `trypanofan`.``construct`` READ, `trypanofan`.``dapi``
Hi did anyone reply to this?
Andrew
I am currently in the process of building a calender/date MySQL table that will
be searched for available dates for holiday tours?
I want to use a time column as there will be a restriction on places
for up to 3
days so this will have to be taken into
Hi,
On Fri, Aug 01, 2003 at 11:55:36PM +0800, Jaime Teng wrote:
Now, I have two of these tables (archivetable,currenttable).
My problem is how do I perform a single query such that I get
results from these two tables:
mysql select * from archivetable,currenttable;
On 1 Aug 2003 at 17:08, Andrew wrote:
Hi did anyone reply to this?
It doesn't look like it. Pretend you don't know anything at all
about your project and try reading your message. Would you have any
idea what sort of answer was wanted? If you want help, you have to
explain exactly what's
Thanks Keith here it is :)
The booking system will take the format of a form. Customer or travel agent can
select a date of travel. They will also input how many places are needed.
The system will then check that the selected dates are available. At this point
there are two possible responses.
I've gone through the mailing list archives, read the appropriate parts of
the manual and searched the internet and still have questions. What I'm
running into is a serious performance problem with a fairly large (by my
standards) database. My system setup is as follows:
Dual processor Sun E250
Dear all,
the MySQL Documentation Team is looking for native Arabic speakers on
this list who are interested in reviewing an Arabic translation of the
MySQL reference manual. Reviewers will receive our gratitude, and
will of course be mentioned in the credits section of the manual.
If you're
Gary,
The if() function often allows you to replace a union query. For example
this may work for you - watch the LIMIT it operates AFTER the sort so
your sort needs to put the records which you want at the front:
SELECT user_id, username, last_login, if(last_team = 380, 1, 2) as
SortOrder FROM
Normally I'd say do a select...into...from, but I don't think MySQL
supports that. In lew of that, try this:
(1) Create the new table.
CREATE TABLE tbl_table_b (
record SMALLINT NULL,
id SMALLINT NULL,
color VARCHAR(10)
);
(2) Insert the values from the source table to the destination.
* Petre Agenbag
The distinct clause will return only one occurrance of the
implicated field.
distinctrow would do the same, but for an entire row. what I am
looking for
is something like distinctset(field1,field2,field7) , is this what the
MAX-CONCAT trick attempts to do?
Not exactly, but
Morten ,
The file used is my.cnf on unix and my.ini on windows.
You should only have one file.
Andy
-Original Message-
From: Morten Gulbrandsen [mailto:[EMAIL PROTECTED]
Sent: 01 August 2003 14:23
To: [EMAIL PROTECTED]
Subject: my.cnf is not available under windows 2000
Hi
http://www.mysql.com/doc/en/Linux.html
If you are using Linux, you need to read this section. You can get up to
4096 connections minus a few for the server admin threads. Did this a while
back and works well. I don't know if any of these issues have been resolved
in the Kernel or LinuxThreads
* Jaime Teng
[...]
Now, I have two of these tables (archivetable,currenttable).
My problem is how do I perform a single query such that I get
results from these two tables:
mysql select * from archivetable,currenttable;
+++-+-+
Hi,
Congratulation to MySQL for a two pages article published by the leading
business journal in Germany (Wirtschaftswoche).
Sorry, no online resource available only a headline
http://www.wiwo.de (German language)
sql, mysql
Andreas Karl Wittwer
I'm not related to wiwo in any case, just a
I have an osCommerce Site along with another Dating site on a completely
different server. on the oscommerce site I have 1200 products and the
server queries the records very slowwly. I have enabled gzip compression
to try and speed this up. Only very slightly has the oscommerce site been
sped
1. Optimize your database calls:
http://www.mysql.com/doc/en/MySQL_Optimisation.html
2. Buy bigger servers.
3. Optimize your application.
4. Upgrade to ver 4.x to take advantage of query caching.
I apologize for the general answer, but optimization is _very_ specific
and without detailed
I appreciate the suggestion. However, this solution will require me to run
step (3) for each record I want updated into Table-B. That would be 1000+
times.
Any other way to get this done without having to run all those updates?
Thanks,
Brent
-Original Message-
From: Adam Fortuno
Hi,
Lets say I have a query similar to:
SELECT * FROM company WHERE id='3' OR id='1' OR id='7' ;
I want to be able to get the results to come out ordered by the order
the ids were searched (the sequence in the WHERE OR; 3 first then 1,
then 7...), so the results would be like:
Row | id
I have this my.ini
--
[WinMySQLAdmin]
Server=C:/MYSQL/bin/mysqld-max.exe
QueryInterval=10
[mysqlcheck]
host=localhost
user=root
force
fast
all-databases
silent
debug=c:\mychk.log
---
but do not check the BD at startup and do not write the log file. Some idea?
Not surprising, the dbms has no built-in support for ordering rows by
the filters in the where clause.
But with a bit of programming you should be able to construct a useful
ORDER BY clause to do what you want...
SELECT * FROM company WHERE id='3' OR id='1' OR id='7'
ORDER BY CASE id when '3'
Brent,
Maybe but give us more information. I know you moving data from one
table into a new one, but not much else. Whats the logic to the changes
you're making?
A$
- Original Message -
From: Brent Elison [EMAIL PROTECTED]
Date: Friday, August 1, 2003 3:25 pm
Subject: RE: Newbie
* Yoed
Lets say I have a query similar to:
SELECT * FROM company WHERE id='3' OR id='1' OR id='7' ;
I want to be able to get the results to come out ordered by the order
the ids were searched (the sequence in the WHERE OR; 3 first then 1,
then 7...), so the results would be like:
Row |
Ok, let me explain my logic and please correct me if I'm wrong...
I gather from my limited understanding of MySQL and rdbms that it is not
advisable to store multiple values in one field on a db (such as the color
values in Table-A below). I was thinking that I needed to have a separate
table
Trying to start first time using command:
C:\mysql\bin\mysqld --standalone
Yields this error message: Can't find
messagefile'C:mysqin\share\english\errmsg.sys'aborting
Now in C:\mysql\share\english\ there is an errmsg.sys
Do you have any language=C:/mysqin/share/english/ entry in the
I am trying to insert data using the C API.
Particulars:
OS: Mac OS X 10.3 (7A179)
MySQL: MySQL 4.1.0-alpha
table type: tried both MyISAM and InnoDB
I have a table:
mysql describe testtable;
++-+---+--+-+-+---+
| Field | Type| Collation
Be sure to visit the MySQL list archives at
http://www.listsearch.com/mysql.lasso.
Here are stats for last month.
Enjoy!
Bill
MySQL List Stats
July, 2003
Note: Up/Down %
Hi Guys:
Does anyone know how come I'm getting a lot of mysql processes when I start
mysql server for the first time.
When I type top it showed the following:
5:33pm up 15 min, 4 users, load average: 0.16, 0.19, 0.10
80 processes: 79 sleeping, 1 running, 0 zombie, 0 stopped
CPU0 states:
Hi
Backups/recovery procedures for MySQL are very simple, and efficient.
The approach I take, is to
- Implement a replicated dual master
and
- Flush mysql db logs
- Use mysqldump db | gzip -c db.sql.gz at a quiet time
- Copy mysql logs
This is essentially, the same process one would use
now when using the
C:\mysql\bin\mysqld --standalone
the error message changes to:
Can't find messagefile 'c:mysql hare\english\errmsg.sys'
NO that is not typed incorrectly! mysql is has no idea where is wants to
find that file.
I have downloaded the file twice now, with same result
below is a
Hello,
I vaguely remember reading in the manual that the order of the retrieved
rows in a response to a select statement is unpredictable (unless you
use an order by clause). this possibly depends on the indices set up for
the table and/or used in constructing the result etc. is this accurate?
You should use what you referred to as an insertion counter field. I'd call
it a id field that uses auto_increment. It's very useful to use this and
by definition it enables you to retrieve the data in the order that it was
inserted.
- Original Message -
From: Murad Nayal [EMAIL
87 matches
Mail list logo