On Wed, 9 Feb 2005, Batara Kesuma wrote:
Hi,
I try to install MySQL 4.1.9 (official RPM from mysql.com). My machine
is running linux 2.6.9, and it has 4GB of RAM. The problem is MySQL
won't start if I set innodb_buffer_pool_size to = 2GB. Here is my
ulimit.
Are you trying this on a 32-bit
On Tue, 8 Feb 2005, Heikki Tuuri wrote:
You should upgrade to 4.1.9. That version commits ALTER TABLE at every 10
000 rows, and a runaway rollback can no longer happen.
This is very nice!
Are there any plans for the same with INSERT ... SELECT -type statements?
--
MySQL General Mailing List
On Mon, 7 Feb 2005, Bjorn van der Neut wrote:
Hello Everyone,
Can someone tell me If you can find out if the replace into function has
done an insert or an update?
It actually never does an update, it always INSERTs.
It either does an insert or delete(s) followed by an insert.
--
MySQL
On Tue, 1 Feb 2005, matt_lists wrote:
now we have this added on a few tables in the dump
DATA DIRECTORY='E:\mysql\data\campbell\' INDEX
DIRECTORY='E:\mysql\data\campbell\'
DATA DIRECTORY='E:\\mysql\\data\\campbell\\' INDEX
DIRECTORY='E:\\mysql\\data\\campbell\\'
Anybody know?
in CREATE TABLE is ignored on
Windows when importing anyways, it's safe to remove those clauses.
If you can find a way to reproduce it, feel free to add it to my old bug
report about this at:
http://bugs.mysql.com/bug.php?id=6660
cheers,
--
Tobias Asplund [EMAIL PROTECTED]
Trainer
If you installed MySQL 4.1.7 on Windows with the new installer, it will
automatically use InnoDB tables as the default unless you specify different.
(This is different from earlier versions), so the error was probably not in
the Query Browser, but in the server settings in this case.
On Wed, 3
On Wed, 3 Nov 2004, Chaitra Yale wrote:
...how can union be the same as intersect..iam trying to get the names
of comapnies that are in both queries.for example the first query
gives me companies A, B AND C and the second query gives A , B..i want
the intersect of these 2 queriesso i
On Wed, 3 Nov 2004, Anders Green wrote:
Tobias Asplund wrote:
If you installed MySQL 4.1.7 on Windows with the new installer
Yes I did.
it will automatically use InnoDB tables as the default
Ah ha. Thanks. :)
That just leaves this:
So now my question Where does InnoDB data get
On Thu, 21 Oct 2004, C.F. Scheidecker Antunes wrote:
Hello,
On a further inspection and by reading Paul DuBois' I guess m y system
has to many bin logs. How can I get ride of them?
Assuming you don't need them for replication or point-in-time recovery, you
can use the PURGE command.
results WHERE id_job = 25919;
INSERT INTO results(result,id_job) VALUES (25.388607,25919),(22.650234,25919);
COMMIT;
I think this manual page might explain what's happening:
http://dev.mysql.com/doc/mysql/en/InnoDB_Next-key_locking.html
--
Tobias Asplund [EMAIL PROTECTED]
Trainer
On Tue, 14 Sep 2004, Sheraz wrote:
when I try following:
CREATE TABLE `MyTable` (
`SNumber` char(32) NOT NULL,
`UserID` char(32) NOT NULL default '0',
PRIMARY KEY (`SNumber`)
) TYPE=MyISAM;
It created the exactly correct table, But when i add
any varchar field in the above
Can anyone tell me what's going on? Are there MySQL parameters that can
improve things?
To know if you need to tune something, you can send us the copy of SHOW
STATUS; and SHOW VARIABLES;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
On Tue, 14 Sep 2004, joe mcguckin wrote:
If I perform a fulltext search for 'foo', it won't match text like
'foo, inc'.
In addition to the other suggestions, make sure our ft_min_word_len isn't
more than 2, because it won't index words shorter than that many characters.
--
MySQL General
On Tue, 14 Sep 2004, Yves Goergen wrote:
Hi,
I can vaguely remember there was something like INSERT... on duplicate
key UPDATE... in MySQL, but the documentation search is almost as
useful as I'm used to - it cannot tell me anything about this. Can you
please? How does this work, what's the
On Tue, 7 Sep 2004, Lee Denny wrote:
Hello,
I need to perform a select that compares two dates
I need to return all records that haven't had date_2 set after a given
number of days since date_1.
... WHERE date_2 date_1 + INTERVAL X DAY
Where X is the number of days.
Assuming this is
On Tue, 7 Sep 2004, matt ryan wrote:
Still have not got this fixed, I'm all out of idea's, the slave has been
reloaded again today
I forgot, did you have multiple slaves on multiple machines? If so, do they
have identical hardware/drivers?
--
MySQL General Mailing List
For list archives:
On Fri, 26 Mar 2004, Seena Blace wrote:
Select group,hostname,details from table1 order by group;
I want the output should be like
Group hostname details
aa abababa
abababababab
On Mon, 15 Mar 2004, Boyd E. Hemphill wrote:
Using a tool to generate a data model I go the following statement:
Create table StateN (
StateId Int NOT NULL AUTO_INCREMENT,
StateNm Char(50) NOT NULL DEFAULT '',
StateCd Char(7) NOT NULL DEFAULT '',
SortInt Int NOT
On Fri, 6 Feb 2004, Alvaro Avello wrote:
the questions is , the wildcard in host field doesn't
involve localhost o a machine host's ? Which kind of permissions we
have to put in host fields to have a mobility and not to be afraid to
move our servers for an emergency ?
When the host field is
On Sun, 8 Feb 2004 [EMAIL PROTECTED] wrote:
the only way I can connect to the server is typing
mysql -h localhost -u root
make sure you don't have a line skip-networking in your /etc/my.cnf
cheers,
Tobias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
On Fri, 30 Jan 2004 [EMAIL PROTECTED] wrote:
Description:
When creating a table, mysql 5.0.0-alpha (binary package)
does not accept column name 'Found'.
How-To-Repeat:
create table log (Found INT UNSIGNED NOT NULL);
FOUND is a reserved word. Use within backticks, ie `Found`
On Wed, 28 Jan 2004, Deven Phillips wrote:
Hello,
There is a web site associated with the web-radio. Users of the web site
can rate songs which are contained in the database. The rating system
works such that users can rate songs from +3 to -2. Now, what I would
like to accomplish is to
On Fri, 23 Jan 2004, Rob Kemmer wrote:
Hi, MySQL Team!
I've downloaded and successfully installed v5.0 win2k, and am happily using stored
procs, but seem to be encountering problems with subqueries in stored procs. When I
run a stored proc containing a subquery, the first pass works, but
On Tue, 20 Jan 2004, Todd Burke wrote:
Is there any way to disable replication of all temp tables using
replicate-ignore-table or some other means? The names of the temp tables
are generated randomly by a script. Thanks
If you could have all temporary tables starting with tmp or something
On Wed, 21 Jan 2004, Yves Arsenault wrote:
Thanks for your response,
I'm using ColdFusion along side of MySQL to server dynamic content to some
websites.
When I run the page that this code is in, I get an SQL syntax error:
Syntax error or access violation: You have an error in your SQL
On Tue, 20 Jan 2004, Marco Paci wrote:
Since the process of inserting a new record and reading its PK field
value is a two step process implemented by:
1) insert into tablename (columnnames) values()
2) select last_insert_id()
,and since because of the architecture of my application I
On Tue, 20 Jan 2004, Chris Boget wrote:
The data I'm working with looks like this:
table1.columnA = '1;3;4;6;8;9;12;13;14;15';
table2.columnA = '3';
table2.columnB = 'this';
I need to write a query that will do something along these lines:
SELECT * FROM table1, table2 WHERE
On Tue, 20 Jan 2004, Chris Boget wrote:
The data I'm working with looks like this:
table1.columnA = '1;3;4;6;8;9;12;13;14;15';
table2.columnA = '3';
table2.columnB = 'this';
I need to write a query that will do something along these lines:
SELECT * FROM table1, table2 WHERE
On Tue, 20 Jan 2004, Mike Mapsnac wrote:
In the table value login_count is int(4). For example if value login_count
equal to 3 and each time user login I want to increment by one.
update customer set login_count='how? where id=12121212;
SET login_count = login_count + 1
--
MySQL General
On Mon, 19 Jan 2004, Mike Mapsnac wrote:
I think that main disadvantage of this command is thah it works for the
database but not for specific table. So if a database has 200 tables, find
result for specific table is not an easy task.
SHOW TABLE STATUS LIKE 'tablename'\G
cheers,
Tobias
On Mon, 19 Jan 2004, Ian O'Rourke wrote:
Regarding the following query:
SELECT ID,Author,DATE_FORMAT(EntryDate,'%d %m
%y'),SectionID,Title,Summary,Content FROM articles
ORDER BY EntryDate
DESC LIMIT 10
Okay, I've looked in the manually up and down, as I know how to do it in
Access, but
On Sun, 18 Jan 2004, Nitin Mehta wrote:
I need to select a column's value as different columns and other fields grouped by
those values.
I want to select distinct values of reseller column as individual columns and other
data grouped on these values.
Since the approach of tables usually
On Sat, 17 Jan 2004, Mike Mapsnac wrote:
Is it possible to find out when the table was created? How to get information about
the table?
You can use the unix command `stat`, the last of the 4 dates will be the
creation date (in the order of Last Accessed, Last Modified, Last Inode
On Sun, 18 Jan 2004, Hassan Shaikh wrote:
Hi,
How do I resize (shrink expand) InnoDB file?
You can read about the various InnoDB specific startup options here:
http://www.mysql.com/doc/en/InnoDB_start.html
cheers,
Tobias
--
MySQL General Mailing List
For list archives:
On Fri, 16 Jan 2004, tait sanders wrote:
yep I've already done this.
everything I do comes back with the same error:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
I even deleted the mysql.sock and used 'mysql_config --socket' to
recreate it.
this
On Thu, 15 Jan 2004, Jamie Murray wrote:
Hi Guys,
after waiting about a minute I get
ERROR 2013 (HY000): Lost connection to MySQL server during query
See if changing any of the
SHOW VARIABLES LIKE 'net%timeout';
helps.
Not sure why the crash popup comes up, however.
cheers,
Tobias
--
On Fri, 16 Jan 2004, Jough P wrote:
Greetings all, I'm trying to grant a user the file privilege and am
getting error messages. Here's my SQL statement
mysql GRANT file ON bs.table1 TO [EMAIL PROTECTED] IDENTIFIED BY
'password123';
It gets the following error:
ERROR 1144: Illegal
On Tue, 13 Jan 2004, EP wrote:
I am wondering:
I can see the MySQL data files for my various databases.
What technically prevents me from simply copying those files and using copies
- to move my database to another file structure or server
- to back-up my current db
Copying will not work
On Wed, 14 Jan 2004, Ugo Bellavance wrote:
mysql 4.0.17 on redhat 9 or debian 3.0
mysql show variables like 'log';
+---+---+
| Variable_name | Value |
+---+---+
| log | ON|
+---+---+
1 row in set (0.00 sec)
mysql set global
On Mon, 12 Jan 2004, Viktor wrote:
Hello mysql,
Table-level privileges do not work at all... (on Windows)
Works fine for me:
4.1.1a-alpha-max-nt:tmp GRANT SELECT ON tmp.tmp TO [EMAIL PROTECTED]
IDENTIFIED BY 'aaa';
Query OK, 0 rows affected (0.18 sec)
4.1.1a-alpha-max-nt:tmp \q
Bye
On Tue, 13 Jan 2004, Priyanka Gupta wrote:
Hi,
I am trying to do some performance analysis by trying different indexing
schemes and testing how long it takes. To get consistent results, I would
like to use something like SQL_NO_CACHE. However, the mysqld version that I
have installed does
On Mon, 12 Jan 2004, Hassan Shaikh wrote:
Hi,
The following does not work for InnoDB tables. The manual says The next
AUTO_INCREMENT value you want to set for your table (MyISAM).
ALTER TABLE table_name AUTO_INCREMENT = new_value;
Any suggestions for InnoDB?
Insert a row with a custom
On Mon, 12 Jan 2004, Ed Lazor wrote:
Is there an abstract way to refer to field names in a result set?
select ID, Name, Price from Products order by field(1)
where field(1) would be the abstract way of referring to the specific field to sort
on.
ORDER BY #
Where # is the number of the
On Mon, 12 Jan 2004, Alaios wrote:
Hi there. Do u know how can i backup my database?
(create insert)
http://www.mysql.com/doc/en/Backup.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
What do I need to add to the my.ini file? Can anyone post a typical setup
of this as an example?
I install with mysqld-nt-max --install servicename
servicename in those cases are MysQL40, MySQL41 and MySQL50
Those are the relevant rows:
[mysqld]
[mysql40]
basedir =
On Mon, 12 Jan 2004, Lewis, Jason wrote:
Okay I have a field in my db called MemberLevel in this field you can be one of 5
levels.
Platinum
Gold
Silver
Paying
Non-Paying
now my question is, how would I ORDER BY MemberLevel and get it to come out in the
above order? I have been
On Mon, 5 Jan 2004, Hal Vaughan wrote:
I've found an odd problem in queries.
I have a lot of data regarding vehicle speeds in a survey. All the data is in
the form: xx/yy, for example 43/55 means that vehicle was clocked at 43 miles
per hour in a 55 miles per hour zone. 80/55 means we have
On Mon, 5 Jan 2004, Allen Weeks wrote:
Hi All,
Just a quick question, does anyone have a good estimate of when ver 4.1 will
go production.
When known bugs are fixed.
You can read up on MySQL's release policy here:
http://www.mysql.com/doc/en/Release_philosophy.html
--
MySQL General Mailing
On Tue, 6 Jan 2004, Martijn Tonies wrote:
Hi,
In MySQL 4.1, is there a function to know what the
current default server-wide characterset is?
You can find all those with:
SHOW VARIABLES LIKE 'character_set%'
cheers,
Tobias
--
MySQL General Mailing List
For list archives:
On Tue, 6 Jan 2004, Knepley, Jim wrote:
Any chance that there's a quarterly strategic roadmap published
somewhere?
I have projects that sometimes depend on a feature in the next rev' or
some such, and I need to plan out for my organization... Difficult to
answer my boss when the
On Tue, 6 Jan 2004, Luc Foisy wrote:
There was a user comment under the Foriegn Key section of the documentation reading:
To restore from a mysqldump file that uses foreign keys:
mysql SET FOREIGN_KEY_CHECKS = 0;
mysql SOURCE your_dump_file;
mysql SET FOREIGN_KEY_CHECKS = 1;
The command
On Mon, 5 Jan 2004, Matthew Stuart wrote:
I am trying to create a couple of columns (one createddate and one
updateddate) in a MySQL table that are DATETIME or TIMESTAMP values,
but I am having trouble understanding how it works. I want both columns
to auto add a date and time when a record
This bug was fixed to 4.0.17, it happened when you inserted a negative
value manually into an auto_increment column
for more info see:
http://bugs.mysql.com/bug.php?id=1366
On Mon, 5 Jan 2004, Donald Henson wrote:
Please post your table schema. As to why bignbr rather than zero, I'll
have
On Mon, 5 Jan 2004, Marc Dver wrote:
Based on the collective experiences of the members of this group, what
are the best methods for learning mysql, both from the perspective of
certification and of learning enough to excel in the production
environment? My interests include both the
On Mon, 5 Jan 2004, Greg Owen wrote:
I tried (you can laugh here) to do it this way, but failed miserably:
mysql select class,count(questnum),count(difficulty='0'),
count(difficulty='1'),count(difficulty='2'),
count(in_use='0'),count(in_use='1') from Questions
group by class;
You
On Mon, 5 Jan 2004, Douglas Sims wrote:
The test was a bit harder than I anticipated. I should have paid more
attention to column types and database name, among other things. But I
did pass - at least, the preliminary report said pass, but also said
that the exam will be reviewed and If you
On Fri, 2 Jan 2004, Roger Baklund wrote:
* Gohaku
I was just curious if there's a shorthand way of replicating a Table
Schema.
I use the following to create a new Table with the same schema.
create table new_table ( select * from table);
delete from new_table;
You can avoid the
http://www.mysql.com/doc/en/example-Maximum-column-group-row.html
might help you do what you're looking for.
On Thu, 1 Jan 2004, Schulman, Michael wrote:
As far as I know min(price) and max(price) will return the lowest and higest
price, not the first and last in the group. Again I know
On Fri, 2 Jan 2004, Caroline Jen wrote:
In case that a user has multiple roles; for example,
John Dole is both author and editor,
1. I should have two rows for John Dole?
John Dole author
John Dole editor
or. I should have only one row and use comma ',' to
separate
On Fri, 2 Jan 2004, Jonathan Villa wrote:
I have a loop which is similar to the following:
while(array contains elements) {
UPDATE users SET status = no WHERE name = array[i]
}
great, it works but the query runs many times. I want to make only one
call to the database and have all the
On Mon, 29 Dec 2003, Leo wrote:
I know someone already ask this,
and the answer generally 'NO YOU CANT' :b
but, is there any work around so i can make a backup server (slave),
from many other server (master) through replication?
You could run a server instance per database replicated and use
On Mon, 22 Dec 2003, Jeff McKeon wrote:
Is it possible to have 2 database on one server replicating from the
same Master server?
yes.
In other words. DB01 is the Master on System01,
System02 has DB01_rep1 and DB01_rep2, each with their own replication
from DB01.
Shouldn't be a problem.
I
Can the user the mysqld process run as (usually the mysql user) read/write
the /var/lib/data directory without problems?
Does your /etc/my.cnf file contain a
datadir = /var/lib/mysql
or is it pointing somewhere else?
Did adding skip-innodb to your my.cnf solve anything?
On Fri, 19 Dec 2003,
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
On Mon, 15 Dec 2003, Peter Lovatt wrote:
Try
Insert INTO `table` ( `inc_field` ) values (10)
the auto inc field will then generate the next sequential numbers
HTH
Peter
Or just use
ALTER TABLE table AUTO_INCREMENT=10
That way you don't have to enter a record just to set
On Mon, 15 Dec 2003, Graham Little wrote:
doing selective quoting below.
LOAD DATA INFILE D:\mysql\sql\CountryData.txt
INTO TABLE cou (id, country);
See how you try to load from a file into the columns id and country in the
cou table?
The table the data is being inserted into
On Mon, 15 Dec 2003, Roberts, Mark (Tulsa) wrote:
I have an order taking system where the tables are store in a MySql database. I need
to develop a select statement to output all new orders to a .csv formatted file.
Is this possible to do in MySql. I would try looking this up, however, I am
Sven Köhler wrote:
I set the isolation level to READ_REPEATABLE and use mysqldump |
bzip2 to get the result. I've tested the restore and it's fine!
So how does mysqldump handle binary data?
If it does embed the data into the SQL-statement somehow, that's crap,
since
On Mon, 15 Dec 2003, Paul Fine wrote:
If I have a table like with a column being the PK for the table and being an
Auto Increment value, what is the best way to return this value to my
script?
If you insert a row LAST_INSERT_ID() will return the primary key value in
this setup.
The other way
On Tue, 9 Dec 2003, Mayuran Yogarajah wrote:
Diana Soares wrote:
Use PURGE {MASTER|BINARY} LOGS TO 'log_name' instead of RESET
MASTER.
From the manual:
Deletes all the binary logs listed in the log index that are strictly
prior to the specified log or date. The logs also are removed
On Wed, 10 Dec 2003, Gavin Dimmock wrote:
Hi All,
I want to change the default port on mysql server from 3306 to 5 (for
example). The server is NT. Has anyone done this before?
Any help really appreciated,
Can either modify the service to start with the --port parameter or add in
your
You have a few ways to do this.
What's happening here is that you do a comparison in a string context,
which means that it will sort according to the ascii values, and 1 comes
before 8.
To sort the way you want you need to specify to MySQL that you want to do
it in a numeric context.
You have two
On Thu, 4 Dec 2003, Uros Kotnik wrote:
I posted this few days ago, but with no answer, also posted it to
benchmark list..
Executing this SQL, takes ~5 sec.
select artists.name , cds.title , tracks.title from artists, tracks,
cds
where artists.artistid = tracks.artistid and cds.cdid =
If you do a fulltext search on multiple columns at once, there must be a
combined fulltext index on this exact set of columns. Just having an index
on them individually will not work.
On Wed, 3 Dec 2003, Mirza wrote:
Hi,
I have error 1191 can't find fulltext index matching the column list,
I think that
http://www.mysql.com/doc/en/example-Maximum-column-group-row.html
covers your problem here.
You either have to solve it with Temporary tables, the MAX-Concat trick
(in the url above) or a subquery (which will be more inefficient than the
other two options).
On Thu, 20 Nov 2003,
On Sat, 8 Nov 2003, Michael Satterwhite wrote:
This has got to be a common question, but I'd really appreciate a little help.
I recently reinstalled my Linux (SuSE 8.2). I *KNOW* I don't have a cron run
that deletes this.
When I try to start mysql, I get the message
Can't connect to local
It depends on your filesystem's and OS's max-size of a file in its
filesystem.
HOWEVER, there are a few ways you can get around this.
You can use InnoDB tables, or read about RAID types here:
http://www.mysql.com/doc/en/CREATE_TABLE.html (almost at the bottom of the
page).
You can also use
MySQL doesn't support TOP, however, there's a LIMIT syntax for MySQL that
roughly does the same thing:
http://www.mysql.com/doc/en/SELECT.html for a brief explanation.
In your example what you are looking for is:
SELECT DateCreatedField
FROM my_table
ORDER BY DateCreatedField DESC
LIMIT 10;
If you have 4.0.2 or later you can use the CAST() function, if you have
earlier you should be able to emulate it with the BINARY keyword for the
ORDER BY clause, examples below:
[EMAIL PROTECTED]:tmp CREATE table sort (
- num int
- );
Query OK, 0 rows affected (0.00 sec)
[EMAIL
this command in
a script to make it automatic to insert records.
Nestor :-)
Nestor A. Florez
Tobias Asplund [EMAIL PROTECTED] 10/15/2003 12:02:21 PM
c:\mysql mydb myfile.sql
ERROR 1044: Access denied for user: '@localhost' to database 'mydb'
try mysql -u administrator mydb myfile.sql
80 matches
Mail list logo