Warning, do not install 5.03 it still crashes on win32. This occured
after
very few minutes of testing. I will send more info as I locate it.
Great... Is there any official word on the 5.0.2 crashes? Have there
been fixes regarding this issue?
With regards,
Martijn Tonies
Database
Gleb Paharenko wrote:
Thanks for the reply.
See:
http://dev.mysql.com/doc/mysql/en/problems-with-character-sets.html
Yeah Thanks - seen that already.
Check that you have the charsets directory in c:\mysql\share.
Again, thanks, but that doesn't actually solve the issue.
There are entries
Hello.
All other applications properly do lookups, inclusing Apache, PHP,
exim4 and
courier-mta.
Please check that you can find afterparty.local using `host` utility
and able connect to it with mysql client. Send an output
of the following statement executed on the weird server:
Hello.
You may use:
http://dev.mysql.com/tech-resources/crash-me.php
especially see the 'Index limits' section. Not only the number of indexes is
valuable, but, say, the length of index as well.
G M [EMAIL PROTECTED] wrote:
[-- text/plain, encoding 7bit, charset: us-ascii, 10
Hello.
Add '[EMAIL PROTECTED]' account.
I did this;
050328 16:20:57 7 Query GRANT ALL PRIVILEGES ON *.* TO
root@'%'
GRANT ALL PRIVILEGES ON *.* TO root@'%'
Yet still I get 050328 16:21:08 8 Connect Access denied for
user: '[EMAIL PROTECTED]' (Using
Hello.
Could you reproduce the error with the official binaries of the latest
release? Also you may switch to the debug version of the server and
try to find the clues in the trace files. Check that everything is OK
with OS. See:
http://dev.mysql.com/doc/mysql/en/debugging-server.html
There's no real official word on the 5.0.2 crashes on win32, although
I believe there were a number of bug reports. A lot of the crashing that
I have come across when using 5.0.2 on win32 has to do with the
informational functions - DESCRIBE, SHOW etc.
There were also a number of crashes that I
I got stuck in this one, and i belive there's a solution, i just don't
happen to see it.
i have a table with conections between itens. something like
+---+---+
| A | B |
+---+---+
| 1 | 2 |
| 1 | 3 |
| 1 | 4 |
| 2 | 1 |
+---+---+
i'm trying to solve with one query a way to get all of the
select l.b, r.a = l.b from tab l join tab r on l.a = r.b where l.a = 1 ;
seems to produce the result you want
Gabriel B. [EMAIL PROTECTED]
29/03/2005 09:30
Please respond to
Gabriel B. [EMAIL PROTECTED]
To
mysql@lists.mysql.com
cc
Subject
help with a mutuality check (good query exercise
after more examination, it appears that i have different versions of mysql,
installed in different locations
an #/rpm -q mysql says that i have mysql-3.23, which is the FC2 versionof
mysql.
given that i apparently have mysql files in /usr/bin, and /usr/local/bin,
i'd like to first clean out the
Can I run load data from master on myisam tables where my table size is approx
30G?
Is there a better way to do this ?
-
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
I cannot stop or lock tables on the master webapps write data to it constantly.
I am copying over the binlogs and applying them to the slave.
It is taking a long time so I just want to know if load data or copying tables
over would bring replication back to where it is.
I
Renato Golin
On Tuesday 29 March 2005 11:26, Shamim Shaik wrote:
Can I run load data from master on myisam tables where my table size is
approx 30G?
- stop slave
- on master do:
- lock tables
- tar cpf - /var/lib/mysql/tbl | ssh -C slave tar xpf - -C /var/lib/mysql/tbl
- start slave
- on master again:
-
On Tuesday 29 March 2005 11:44, Shamim Shaik wrote:
I cannot stop or lock tables on the master webapps write data to it
constantly.
I am copying over the binlogs and applying them to the slave.
It is taking a long time so I just want to know if load data or copying
tables over would bring
Although I didn't find it in the docs anywhere, I know from experience that
you cannot join more than 31 tables in 4.0.21
I was wondering if anybody knew if this limit has changed in version 5
Thx
Rob
I suspect 5.x.x is the same as 4.1.x which is 61 tables - dependent on
processor. See an earlier posting of mine on the same subject.
What they really need to do is replace the #define with a struct and
some 'code' to interpret its contents then you could have any limit you
wanted - provided
The tool is well regarded. I have not used it, but many people have
with success. But, most FMP databases are so poorly structured that it
is often best to start over. Keep in mind the necessity of importing
data from FMP to MySQL though.
.
Kevin Bice
Foster
G M [EMAIL PROTECTED] wrote on 03/29/2005 01:54:17 AM:
hi all,
in a table of say 100 fields, how many (maximum )numbers of indexes
can be created...
thx in adv.
This is really just a math problem as the database limits are much smaller
than the number of possible index combinations.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Until this version, I used to just copy the data/db directory from the
old database to the new one.
Now, I can't do that, and I think it is because of the data dictionary.
I have a database that only exists on this machine, and I want to get it
into
I want to get everything from user than if record exist in admin so
user has admin(administrator) in table user with user.id =
admin.admin_id, so I need to get 'admin' first_name and last_name
If there is no record in table admin with adin.user_id = user.id ,
than I need at least all records from
It would appear that the package is for the 64-bit OS, even though it is
listed as being for the 32-bit one.
I see directories, that failed to install, of:
/usr/local/mysql-max-5.0.3-beta-sun-solaris2.8-sparc-64bit/sql-bench
I had gotten my file from
Jerry Swanson [EMAIL PROTECTED] wrote on 03/29/2005 11:43:56 AM:
I want to get everything from user than if record exist in admin so
user has admin(administrator) in table user with user.id =
admin.admin_id, so I need to get 'admin' first_name and last_name
If there is no record in table
Hi!
On Mar 28, Homam S.A. wrote:
It seems that MySQL freaks out whenever it seems
something that looks like a derive table and refuses
it to cache. Even a non-UNION query like:
SELECT * FROM
(SELECT * FROM X WHERE A = 5) AS DerivedTable
Won't be cached.
It's a bug. Could you submit a
I am trying to determine the average time that a Distinct IP address is
using the server
If I have 15 thousand records of ip addresses and access times like:
IP Now() media.id
--
10.1.7.205
On Tue, 29 Mar 2005, Shamim Shaik wrote:
Can I run load data from master on myisam tables where my table size is
approx 30G?
Is there a better way to do this ?
Hi,
1) LOAD DATA FROM MASTER: From the manual:
It acquires a global read lock on the master while taking the
snapshot,
Fedora Core 3, which is the Linux distribution that i'm using, is still
shipping with 3.23.58
The beta (test) version of Fedora 4 has mysql-4.1.10. However, FC4 is
scheduled to go live on June 6th. But i need a MySQL server now.
This server will be mostly used for logging (think: syslog logging
Graham Anderson [EMAIL PROTECTED] wrote on 03/29/2005 02:20:48 PM:
I am trying to determine the average time that a Distinct IP address is
using the server
If I have 15 thousand records of ip addresses and access times like:
IP Now() media.id
TYPO ALERT!!! I left out the all important word INTERVAL. The query
should read:
SELECT accesstime
FROM userlog
where accesstime (NOW() - INTERVAL 15 minutes)
and IP='10.1.7.205'
LIMIT 1;
Sorry all!
-S
[EMAIL PROTECTED] wrote on 03/29/2005 02:50:35 PM:
Graham Anderson [EMAIL PROTECTED]
This is it. I quit for today... Change minutes to minute and I promise
to be more careful next time -- ROFLMAO!
-S
[EMAIL PROTECTED] wrote on 03/29/2005 02:59:09 PM:
TYPO ALERT!!! I left out the all important word INTERVAL. The query
should read:
SELECT accesstime
FROM userlog
where
I read the manual and i am still confused as to how the merge tables use
indexes.
Can someone help me with this ?
-
Do you Yahoo!?
Yahoo! Mail - Easier than ever with enhanced search. Learn more.
I need to imort a MySQL DB inot MSQL is this possible?
Thank you
Andrew
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.4 - Release Date: 27/03/2005
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
I need to imort a MySQL DB inot MSQL is this possible?
There are probably other tools that can do this, but
Database Workbench can convert your schema and
transfer your data:
www.upscene.com
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL MS
I have a table that I created by hand like this:
DROP TABLE IF EXISTS testset;
CREATE TABLE testset (
id int(10) unsigned NOT NULL auto_increment,
name varchar(50) NOT NULL default '',
special enum('','all','safe','unsafe') NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY name (name)
Hi,
I understand that we should use IS instead of = for selecting fields
with NULL. But then, shouldn't the statement below cause a syntax error?
Please explain.
select * from test2 where datecurrent=NULL;
Thanks,
Lee
--
MySQL General Mailing List
For list archives:
leegold [EMAIL PROTECTED] wrote on 03/29/2005 04:58:11 PM:
Hi,
I understand that we should use IS instead of = for selecting fields
with NULL. But then, shouldn't the statement below cause a syntax error?
Please explain.
select * from test2 where datecurrent=NULL;
Thanks,
Lee
Nope
this sql works on mysql version 3.23.58...my remote server
SELECT c.City, r.Region, co.Country
FROM subnets s, cities c, regions r, countries co
WHERE c.CityId = s.CityId
AND c.RegionID = r.RegionID
AND c.CountryID = co.CountryId
AND s.SubNetAddress = '24.24.172'
LIMIT 0 , 30
but the same syntax
Sir
I had found your address by Denise Johnston from HIMAA.She asked me to write
you in order to give me some explanations about research work and friends from
your University
Thank you
I hope to read from you soon.
Is there a way to represent infinity in mysql?
I've got a range field in my GUI, which is x...
if the user chooses this field, in the DB, I store it as:
id | from | to | other
2 | x | infinity | etc...
this is because there are situations of x and between x AND y,
so from and to is the
On Tuesday 29 March 2005 20:51, Scott Klarenbach wrote:
Is there a way to represent infinity in mysql?
I could make infinity default to 100,000,000 or some other number I
know will never be reached, but it seems less elegant a solution...
probably not the best but you could have two fields:
Scott Klarenbach wrote:
Is there a way to represent infinity in mysql?
I've got a range field in my GUI, which is x...
if the user chooses this field, in the DB, I store it as:
id | from | to | other
2 | x | infinity | etc...
this is because there are situations of x and between x AND y,
so
hi...
we're trying to install mysql/mysql-server (4.1.10a-1.i386) and are running
into some serious problems. we had mysql/server (3.23.52-3.i386) running,
but needed to go to the higher version...
can someone tell us how/what we need to do to get this working correctly.
actually, if anybody's
Hi folks-
This is my first post to any MySQL lists, so be gentle. If I'm posting
SQL queries to the wrong forum, please direct me to the proper
resources.
Anyways, I have a simple schema that stores some IP accounting data.
I'm attempting to extract the data, grouping by the service type
Hi,
MySQL treats NULL, '' (empty string) as different.
I mean when I select from/insert into a table, its behaviour is
different.
Select * from table1 where name='';
is different from
Select * from table1 where name=NULL;
Similarly
Insert into table1(name)
On Mar 29, 2005, at 10:38 PM, Jason Dixon wrote:
Anyways, I have a simple schema that stores some IP accounting data.
I'm attempting to extract the data, grouping by the service type
(label), and also grouping by each 24-hour window/day from the
datetime column (timestamp). I'm not sure how
I acquired a CD-ROM that lists many thousands of
animal species. The main file is a 813-MB MDB file.
I'm not sure if it's a spreadsheet or database, but
it's apparently designed to work with Microsoft
Access, which I THINK is a spreadsheet. (I don't have
it.)
I have just enough memory to open the
David Blomstrom wrote:
I acquired a CD-ROM that lists many thousands of
animal species. The main file is a 813-MB MDB file.
I'm not sure if it's a spreadsheet or database, but
it's apparently designed to work with Microsoft
Access, which I THINK is a spreadsheet. (I don't have
it.)
I have just
DB Tools software will convert the file for you. You can download it at
http://dbtools.com.br/EN/index.php. All you have to do is download and
install the FreeWare version and then use the TOOLS DAO Import Wizard.
J.R.
-Original Message-
From: David Blomstrom [mailto:[EMAIL PROTECTED]
On Tue, 29 Mar 2005 19:28:56 -0800, bruce [EMAIL PROTECTED] wrote:
we're trying to install mysql/mysql-server (4.1.10a-1.i386) and are running
into some serious problems. we had mysql/server (3.23.52-3.i386) running,
but needed to go to the higher version...
I was about to attempt the same
bruce wrote:
hi...
we're trying to install mysql/mysql-server (4.1.10a-1.i386) and are running
into some serious problems. we had mysql/server (3.23.52-3.i386) running,
but needed to go to the higher version...
can someone tell us how/what we need to do to get this working correctly.
actually,
On Tuesday, March 29, 2005 21:29, bruce wrote:
hi...
we're trying to install mysql/mysql-server (4.1.10a-1.i386) and are
running into some serious problems. we had mysql/server
(3.23.52-3.i386) running, but needed to go to the higher version...
can someone tell us how/what we need to do
Thanks for both your tips. I discovered by chance that
Navicat (which I have) will do the conversion - very
easily. Whether or not it will be a success is hard to
say; it's loaded nearly 3 million rows so far, with
over 8,000 errors recorded.
But I'm going to download DB Tools, as I have frequent
Narasimha,
In programming languages, a 'null string' is empty, but in ANSI SQL,
NULL means unknown, _not_ empty, so
in ANSI SQL, NULLs are never equal to anything, not even themselves: the
expressions NULL=NULL, NULLNULL and NULL='' all evaluate to NULL.
Microsoft SQL has an 'ansi_nulls'
David Blomstrom wrote:
Thanks for both your tips. I discovered by chance that
Navicat (which I have) will do the conversion - very
easily. Whether or not it will be a success is hard to
say; it's loaded nearly 3 million rows so far, with
over 8,000 errors recorded.
3 million records in an
On Tue, 29 Mar 2005 20:39:54 -0800, Florin Andrei
[EMAIL PROTECTED] wrote:
On Tue, 29 Mar 2005 19:28:56 -0800, bruce [EMAIL PROTECTED] wrote:
we're trying to install mysql/mysql-server (4.1.10a-1.i386) and are running
into some serious problems. we had mysql/server (3.23.52-3.i386) running,
Hello list,
I have two MySQL 4.1 servers, one local and one remote. I need to transfer
database from one server to another. What actually is the best way of
handling this task?
Are there any standard MySQL tools available for doing that (I mean MySQL
Administrator/Query Browser etc.)
Best
The RPM's from mysql.com should work fine on FC3. The source RPMs
should build as well. I would say it shouldn't take that much effort.
I don't know about performance issues, but I always figured that you
can tune InnoDB with a bit more control than myisam. For inserts, you
could probably have a
Again the logging server i mentioned before: it's like syslog logging
to a DB, lots of INSERTs, perhaps a few SELECTs every now and then,
the tables are append-only and are rotated about once a day.
For reasons that i am not going to discuss here, the machine has no
uninterruptible power supply.
57 matches
Mail list logo