I just installed MySQL 4.1 on Mac OS X Panther Client. I am now having
trouble authenticating users(root, admin) to MySQL. I am able to start
MySQL but not using a specific user name and password.
When I type ./mysql in /usr/local/mysql/bin, I am able to access MySQL.
However, I have no privileges
Hi!
Creating the indexes after the import will only slow down the operation.
MySQL recreates the whole table at CREATE INDEX.
We are working on a fast index create in MySQL-5.1. Until then, the fastest
way is to import the rows to a table where indexes have already been
created, just like you h
What are the implications of setting the "--bdb-no-sync" flag when
using the BDB storage engine. I haven't found alot of documentation on
this in the docs or via google.
Does this mean that after every transaction, sync will not be called?
When will sync be called then?
Will setting this flag l
Hi:
I have installed MySQL on two Windows XP PC systems. One system, the one at
school is not thoroughly tested but it appears to work. The other one at
home yields an error when the Administrator is run. I downloaded the zip
version of MySQL It is 36773 KB and all evidence indicates it is version
Jarle Aase schrieb:
> Is there a way to boost the performance? The database is idle, and while
> importing, performance is the key priority (record-locking,
> transaction-rollbacks and file-integrety/crash-recovery are not required
> until the data are imported).
- Disable the foreign key checks
My first guess is the indexes. Maybe create them after the import. It will
nonetheless take a bit of time!
--Original Message--
From: Jarle Aase
To: MySQL list
Sent: Mar 17, 2005 11:53 PM
Subject: Problem: Slow "LOAD FILE" performance with innodb
Hi list,
I'm trying to import some data in
Hi list,
I'm trying to import some data into a MySQL database. The data-file is
5.5G, and consist of about 132 million rows. The machine is a P4 3GHz
with 1G RAM and a single 250 GB ATA-disk for data. The operating system
is Debian GNU Linux "testing" with kernel 2.6.8 with hyperthreading
support.
oix ppl,
thanks a lot for the answers, but if it was this simple I wouldn't ask...
Yes, I am Core Certificate, and yes I did read the show-table-status page.
BUT, that don't satisfy my needs.
The sugestion to use data_length divided by the number of rows is good if all
rows have a fixed le
Hi all,
Using mysqld (mysql Ver 12.22 Distrib 4.0.18, for
pc-linux (i686)) and have come across some funky SQL
code that appears to work occassionally - maybe,
depending on the sql client I'm using, but I'm not
sure why/not.
I'm using mysql from the command line client, as well
as a jdbc client
Marco Neves wrote:
I'm looking for some way to know the size each row of a table uses in my
database (phisical - real disk space allocated or logical - datasize
ignoring compression and any control data, don't mind, anything is better
than nothing).
You might try using the Data_length and Index_len
Francisco,
> Maybe it's my setup... but:
>
> whenever I try to login to use the mySQL query browser, it instantlly
> turns off the 5.0.2 alpha mySQL instance (stops running). the error I
> get is:
>
> mysqld-max-nt.exe - Application Error
>
> the instruciton at "0x00538d34" referenced memory at "0
Marco Neves wrote:
oix ppl,
Nobody have any sugestion that can me help with this issue?
thanks
mpneves
On Wednesday 16 March 2005 14:09, Marco Neves wrote:
Look under storage requirements in the manual.
You are MySQL core certified?
oix ppl,
sorry for the question, but I looked in the Manual on
oix ppl,
Nobody have any sugestion that can me help with this issue?
thanks
mpneves
On Wednesday 16 March 2005 14:09, Marco Neves wrote:
> oix ppl,
>
> sorry for the question, but I looked in the Manual online and didn't find
> nothing that do this that I'm looking for, so I'm hopping someone
I have Python code that I run on Windows and Solaris. It works properly
on Windows. However, on Solaris, when it inserts records, datetime
columns end up with a value of zero. I suspect that this began
happening after we upgraded the MySQL server to 4.1.10 from a 4.0.x
version (I think we we
Mahmoud Badreddine <[EMAIL PROTECTED]> wrote on 03/17/2005 03:16:47
PM:
> Hello,
> I imported tow tables from an Access database to MySql.
> Call them table1 and table2.
>
> Both tables came with unique identifiers (ID1 for table1 and ID2 for
> table2)which were generated automatically as a reg
Hello,
I imported tow tables from an Access database to MySql.
Call them table1 and table2.
Both tables came with unique identifiers (ID1 for table1 and ID2 for
table2)which were generated automatically as a regular integer
index(0,1,2...N-1) for an N set of data. I would like to get rid this
ty
At 01:28 PM 3/17/2005, you wrote:
I have 2 tables, category & product. product contains category_id which
points back to category.id
I'm trying to get all fields for each category plus the total no. of
products in that category. A simple query for this:
SELECT c.*, COUNT(p.id) AS total
FROM cat
When will 5.0.3 come out?
Thanks,
Lily
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 17, 2005 10:17 AM
To: Francisco Tapia
Cc: mysql@lists.mysql.com
Subject: Re: 5.0.2 alpha crashes with Query Browser
Lots of users report such instabilities in th
brian ally <[EMAIL PROTECTED]> wrote on 03/17/2005 02:28:46 PM:
> I have 2 tables, category & product. product contains category_id which
> points back to category.id
>
> I'm trying to get all fields for each category plus the total no. of
> products in that category. A simple query for this:
>
I have 2 tables, category & product. product contains category_id which
points back to category.id
I'm trying to get all fields for each category plus the total no. of
products in that category. A simple query for this:
SELECT c.*, COUNT(p.id) AS total
FROM category AS c, product AS p
WHERE c.p
Lots of users report such instabilities in the 5.0.2-alpha build for
Windows. We went back to 5.0.1.
PB
-
Francisco Tapia wrote:
Maybe it's my setup... but:
whenever I try to login to use the mySQL query browser, it instantlly
turns off the 5.0.2 alpha mySQL instance (stops running). the erro
Richard,
Explain auto_increment field please.
Thanks,
Jerry
-Original Message-
From: Richard Whitney [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 17, 2005 10:31 AM
To: Gerald Preston
Cc: mysql@lists.mysql.com
Subject: Re: insert was working
Gerald!
Do you have an auto_increment f
I'm not sure if it's a OS X, PHP or MySQL issue so I apologize in
advance if this is taken as too off topic.
I have a PHP5.x site under development with MySQL 4.1.10. I had the
site running fine and there were no speed issues at all. Everything is
on the same system (a dual G5 Xserve).
Today
Interestingly enough, adding the PATH to the .bash_profile has made the
preference pane 100% stable now (the Admin GUI is another story). So
I'm wondering if the pref pane simply calls a shell script or command.
If that is the case, shouldn't the PATH be added or created during
installation o
On Thu, 17 Mar 2005 11:31:32 Michael Stassen wrote:
You can't call TextEdit from the command line like that, you have to launch
it in the GUI.
This will do the trick:
open -a /Applications/TextEdit.app .bash_profile
That doesn't really matter, though, as you do not want to use TextEdit,
becau
Maybe it's my setup... but:
whenever I try to login to use the mySQL query browser, it instantlly
turns off the 5.0.2 alpha mySQL instance (stops running). the error I
get is:
mysqld-max-nt.exe - Application Error
the instruciton at "0x00538d34" referenced memory at "0x007f9000". The
memory coul
Okay...now we're getting somewhere. Thank you. Adding the file wasn't
the problem, I just wasn't sure WHERE it should be added. Yes, I am
using 10.3. Just trying to pin down why the GUI tools can't seem to
start and stop this thing reliably. As I stated before, I'm not a Unix
geek :) so fo
You can't call TextEdit from the command line like that, you have to launch
it in the GUI. That doesn't really matter, though, as you do not want to
use TextEdit, because it saves files as RTF!
Launch a Terminal window. You'll be in your home directory. Enter
ls .bash*
to see if you already
Gerald!
Do you have an auto_increment field?
If so, what's it set as?
Richard
Quoting Gerald Preston <[EMAIL PROTECTED]>:
> Hi!
>
>
>
> I was able to insert data with the following:
>
>
>
> sub insert_sql {
>
>
>
> my ( $group_name, $me, $daily, $item, $unit, $qty, $amount, $tax, $total,
> $D
Hi!
I was able to insert data with the following:
sub insert_sql {
my ( $group_name, $me, $daily, $item, $unit, $qty, $amount, $tax, $total,
$DEBUG ) = @_;
print "[EMAIL PROTECTED]" if $DEBUG;
( $group_name, $me, $daily, $item, $unit, $qty, $amount, $tax, $total ) =
&clean_sq
Jeff Justice wrote:
I'm not sure where I would go to
change the .bash_profile.
It's in your home directory. You land there just by opening a new
Terminal window. I suppose if you had to wimp out, you could probably say:
$ TextEdit .bash_profile
But real Unix users don't use GUI text
Hi,
We are developing an application that needs to use a massive back-end
database. The database will contain around 75 million rows with around
80 columns per row. We would prefer to use MySQL as the database
platform as it is free. The MySQL database would be hosted on a
dedicated server that we
Okay, I was able to get the MySQL to shut down via command line.
However, not being a Unix person, I'm not sure where I would go to
change the .bash_profile. I've never had to change it for anything up
until now.
I will be curious to see if adding the path affects the problem in any
way with
For those of you watching but still not getting his point: He is saying
that QUOTE() improperly escapes a string where a \ and a ' appear together
in the unquoted text. the sequence \' should look like \\\' when
QUOTE()-ed. It should escape \ as \\ and ' as \'.\\+\' = \\\' .
QUOTE() seems t
Is there a free service where I can upload my CSV file to let the
guess_table script go through and suggest create table statement?
I did recently downloaded and tried the guess_table.pl script that is
mentioned in Mysql cookbook. (10.36 Guessing Table Structure)
I could not run the script due to
man pkgadd
-J
- Original Message -
From: "Joerg Bruehe" <[EMAIL PROTECTED]>
To:
Cc: "Jonathan Stockley" <[EMAIL PROTECTED]>
Sent: Thursday, March 17, 2005 9:16 AM
Subject: Re: 4.1.10a packaging for Solaris
Hi Jonathan, all!
Am Mi, den 16.03.2005 schrieb Jonathan Stockley um 22:33:
I jus
Hi Jonathan, all!
Am Mi, den 16.03.2005 schrieb Jonathan Stockley um 22:33:
> I just downloaded the 4.1.10a release for Solaris 8 and 9 (32bit). It
> seems that it is no longer in a tar archive. Was this change
> intentional?
Both "yes" and "no":
Yes, it was intentional to create and offer PKG f
Hi everyone,
I'm following up on my own question. There appears to be a bug in the way
how QUOTE() interacts with the mysql client.
Using --raw mode can apparently solve the problem reported in my original
post:
shell> mysql --raw -N -B -e "SELECT QUOTE(sometext) FROM foo;" test
'Pitt\'s Place'
Ankur G35 Saxena wrote:
All I had to do was rpm -Uvh --nodeps
I have the MySQL AB RPMs running on Red Hat 9 just fine. I didn't have
to force them at all.
I suspect you had to force it because you had MySQL installed already.
The problem is, the Red Hat package is called "mysql", whereas the M
H...
It looks like you upgraded from a MySQL that doesn't know about
collations...
All the tables created with a version of MySQL that doesn't know about
collation are considered by a version that does know... being of collation
"latin1_swedish_ci"... (on columns where collation makes sense..
Hi,
After upgrading to mysql 4.1.10nt
I am being told that some of my tables are read-only
I cannot find where or how you might specify that a table is read/write to
whatever
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.
Hello.
>Please let me know how to install MySQL successfully on Linux.
You may use official binaries. See:
http://dev.mysql.com/downloads/
[snip]
I was installing MySQL on Linux. At that time it was giving some problem
when I did ./configure.
Your libc libraries are not 100% c
Hello.
> Hi, I am trying to install the latest version of MySQL(i am not sure
> 4.0.23?
Use 4.1.10a. See:
http://dev.mysql.com/downloads/
> Hi, I am trying to install the latest version of MySQL(i am not sure
> 4.0.23? currently in the office). The RH9 comes with some 3.2.xx
> vers
MyISAM tables files have MYI suffix. See:
http://dev.mysql.com/doc/mysql/en/full-table.html
> Hi,
>
> I have a InnoDB database with MySQL version 4.1.0-alpha installed on my
> RedHat Linux 9.0. The data files name is like *.frm, *.MYD, *.MYI".
>
>
> Currently the table size
Hello.
Please, search in MySQL archives (at lists.mysql.com/mysql) about
successful solutions to your problem. You may use --focre --nodeps
flags for the rpm command.
[snip]
I want to upgrade mysql client 3.23. to mysql 4.1.10
But when I type rpm -Uvh mysql-client-4.1...rpm
It's sa
Hi,
I am using mysql Ver 14.7 Distrib 4.1.8, for pc-linux (i686)
When running a certain query I get the following error:
DBD::mysql: t execute failed: Illegal mix of collations
(latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation
'find_in_set'
I do not understand why I have a
Hi!
From: Philippe Poelvoorde <[EMAIL PROTECTED]>
Reply-To: "'mysql@lists.mysql.com '"
To: mysql@lists.mysql.com
Subject: Re: Queries inside UDF
Date: Thu, 17 Mar 2005 08:22:46 +
...
You can actually access a DB within a UDF, but you should do the same than
when you're using the C api of mysq
Hi!
i have a question:
FIELD IN MS SQL SERVER
FiledName: uiAutID
DataType: unique identifier
DefaultValue: newid()
Is RowGuid: Yes
how i can describe the some column in MySQL?
if isn't possible, how can i solve my problem?
P.S.: is necessary for u
sguazt sguazt wrote:
Thanks for answering!
Your solution would be right if I can modify the database (and I have no
control on software that populate tables).
Unfortunately I can do only queries on that db; so the due date has to
be recalculated every time I want to perform the main report (that
49 matches
Mail list logo
