I upgraded as stated in the subject, but my databases don't
show up in mysql. The databases are still physically there,
but mysql just ignores them. Apparently, it overwrote all
my old system db data, because the users and privileges
were gone too. I installed the binary version first, hoping
Bill,
- Original Message -
From: Bill Todd [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, September 08, 2003 3:02 AM
Subject: DECIMAL math?
Since DECIMAL fields are stored as strings how are calculations performed?
Does MySQL use string math routines or does it
Chris,
- Original Message -
From: Chris Nolan [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, September 05, 2003 4:31 AM
Subject: Lock escallation etc?
Hi all!
Here's a question for all my fellow geeks / coders / software engineers
/ curious DB admins.
I've
Hi!
- Original Message -
From: Quoc kinh [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, September 08, 2003 7:04 AM
Subject: MySQL research
Dear Sirs,
We are Vietnamese students and both of us are
interested in database.
Therefore, we did choose our graduation
A DNS problem, may be ...
Marc.
-Message d'origine-
De : JOUANNET, Rodolphe [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 5 septembre 2003 13:02
À : [EMAIL PROTECTED]
Objet : Very slow connexion
Hi,
This problem is specific to the WAN connexion, not to the LAN connexion.
I've a Sun
Hi all,
Up until now we always created database backups using the mysqldump tool.
But I'm wondering, if it is possible to just create a tar archive of the
complete mysql data directory.
We are running on Linux (2.4.18) and we use mysql 4.014.
Thanks,
Harm de Laat
Informatiefabriek
The
David B. Held [EMAIL PROTECTED] wrote:
I upgraded as stated in the subject, but my databases don't
show up in mysql. The databases are still physically there,
but mysql just ignores them. Apparently, it overwrote all
my old system db data, because the users and privileges
were gone too. I
Hello, i know this must be the dumbest question by far (i think i´m even blushing
myself), but how do i call my own native functions? i did all the steps in the
item_create.* and the item_func.* but when call it from the mysql prompt i always get
a sintax error, even if i call some function of
Hello, i know this must be the dumbest question by far (i think i´m even blushing
myself), but how do i call my own native functions? i did all the steps in the
item_create.* and the item_func.* but when call it from the mysql prompt i always get
a sintax error, even if i call some function of
EMS HiTech company is pleased to announce MySQL Manager for Windows 2.6 -
the next version of our powerful MySQL administration and development tool!
You can download the latest version and user's guide from
http://www.mysqlmanager.com/download.phtml
What's new in version 2.6?
1. We've added
Heikki,
Thank you for educating us all! Your obvious knowledge of other database
vendor's products is impressive to say the least.
In case it is of any interest to you, my information regarding Oracle
supporting nested transactions comes from a third-year university text,
used by the uni I am
I have a clientprogram tring to connect to a MySQL database via ODBC, but
the client is receiving
'(access is denied to XX with password yes). '
How do I find out what password the client is sending?
-
Kenneth Lundström
[EMAIL PROTECTED]
--
MySQL General Mailing
You may tar de mysql data directory but you shouldn't do it with mysql
server running (because it is using the files).
If you do not want to stop the mysql server (or lock it from writes),
you can, for example, use mysqlhotcopy first to create an identical data
directory and then do a tar on that
Sebastian Hoffmann [EMAIL PROTECTED] wrote:
I have just updated from MySQL 3.23 to MySQL 4.0.14. My operating
system is Mac OS X (10.2.6).
I have now encountered an odd problem with some select statements
which appear to work differently in the new version:
I want to do a join on two
I run a site with a few million MySQL requests a day, but I've run
into a strange problem which I'm trying to slove.
The server is running mysql 4.0.14, Apache 2.0.47, mod_perl2-1.99r09,
DBI 1.38 and DBD-mysql 2.1026 on a FreeBSD 4.8 machine.
About once or twice a day, I get a bunch of slow
I haven't gotten any e-mails from the list in several days, are there
problems?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello, in order to call a native function do i have to add something else to its name,
i.e. mysql_get_update? because everytime i try to call my native function from the
mysql prompt it gives me a syntax error.
Hi,
I have just started using MySQL from MSSQL 7. I need to port the following
into MySQL from an existing (working) query on MSSQL Server:
SELECT product_id, name, description
FROM products
WHERE product_id NOT IN (SELECT product_id FROM sales WHERE customer_id =
10)
i.e. get all the products
Gustavo,
Prefix them with 'SELECT FUNCTION_CALL;' (e.g. 'SELECT VERSION();').
Regards,
Adam
-Original Message-
From: Gustavo Castro [mailto:[EMAIL PROTECTED]
Sent: Monday, September 08, 2003 10:03 AM
To: [EMAIL PROTECTED]
Subject: Functions
Hello, in order to call a native function do
Andy Hall wrote:
Hi,
I have just started using MySQL from MSSQL 7. I need to port the following
into MySQL from an existing (working) query on MSSQL Server:
SELECT product_id, name, description
FROM products
WHERE product_id NOT IN (SELECT product_id FROM sales WHERE customer_id =
10)
i.e. get
Andy:
Sub queries are supported as of version 4.1 (see link #1). As for your
query, double-check the syntax in the select piece. Specifically take out
the 'sales.sale_id' and anything else from the 'sales' table. Then try
again.
Regards,
Adam
Link #1 -
sub-queries, but also seen examples of it done. Is it only supported in a
later version? We are running v. 3.23.3.
As far as I know, subqueries are only supported in MySQL v4(.1?)+
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
* Andy Hall
I have just started using MySQL from MSSQL 7. I need to port the following
into MySQL from an existing (working) query on MSSQL Server:
SELECT product_id, name, description
FROM products
WHERE product_id NOT IN (SELECT product_id FROM sales WHERE customer_id =
10)
i.e. get all
Thanks for the query suggestions, but unfortunately none of them seem to do
the trick.
Not possible to upgrade to 4.x at the moment, so I am going to have to do it
in 2 queries; one to get the list of ID's, then create a list in PHP and
drop it into the second query.
Thanks for the help!
Andy
You need to get the conditions for the LEFT JOIN out of the WHERE clause:
SELECT product_id, name, description, sales.sale_id
FROM products
LEFT JOIN sales ON
products.product_id = sales.product_id WHERE
sales.sale_id IS NULL AND
sales.customer_id = 10
I lied in my
Andy Hall [EMAIL PROTECTED] wrote:
I have just started using MySQL from MSSQL 7. I need to port the following
into MySQL from an existing (working) query on MSSQL Server:
SELECT product_id, name, description
FROM products
WHERE product_id NOT IN (SELECT product_id FROM sales WHERE
Names of vendors who are happy to provide servers
applicable for high load Linux/MySQL. Willing to
do custom configurations.
Anyone?
--
Michael Bacarella24/7 phone: 1-646-641-8662
Netgraft Corporation http://netgraft.com/
Finger email address for public key.
SELECT product_id, name, description, sales.sale_id
FROM products LEFT JOIN sales ON products.product_id = sales.product_id
WHERE sales.customer_id = 10 AND sales.sale_id IS NULL
This query should return no rows, because if you retrieve rows where sales.sale_id is NULL, customer_id for these
Egor Egorov [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
[...]
Do you lose all your databases and tables or tables of
the database 'mysql'? Do you have databases
directories and files of tables in these dirs?
Never mind. Apparently, 3.22 was installed to /usr/local,
and 4.0 was
I have an application, where I use the following select-query:
select h.huvud_id,datum, start_tid, stopp_tid,l.lokal_beteckning,
namn,adress,rubrik,amne,grupp,kursnamn,lr.signatur
from huvud_schema as h,lokaler as l,huvud_amnen as ha,amnen as a,
grupper as g,huvud_grupper as hg,kurser as
Hi all,
A few weeks ago, someone mentioned that Innodb would soon have multiple
tablespaces available under MySQL. I saw that Innodb.com shows this on their
to do list. Is anyone aware of the status of this upgrade, or a site that
would have details regarding the upgrade?
thanks
--
MySQL
El Lunes, 8 de Septiembre de 2003 09:01, Michael Bacarella escribió:
Names of vendors who are happy to provide servers
applicable for high load Linux/MySQL. Willing to
do custom configurations.
Anyone?
--
Michael Bacarella24/7 phone: 1-646-641-8662
Netgraft Corporation
Sean,
I am at this very moment programming them :). The deadline is Sept 15th,
2003.
Best regards,
Heikki
Innobase Oy
http://www.innodb.com
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
Order MySQL support from
Hi everybody
I'm pretty new to MySQL (and to this list). My problem is I need to get
a dump of all databases in seperate files, I know how to do one
database to one file and all databases to one file.
So far I'm using this command:
mysqldump --user $USERNAME --password=$PASSWORD $DBNAME | gzip
hi, it's the third time i'm trying to post this message to the list.. so
please reply , even if it is for saying nothing.. only to be sure that this
mail have been distributed.
Thanx
---
ok here we are,
first of all, hi to every one since i'm new to this list.
then it's my first
Hello,
i´m using the 3.23.57 version and i´ve declared a native function, but when
i call it (SELECT GETUPDATE(1);) i
get this line
ERROR 1064: You have an error in you SQL syntax near '(1)' at line 1;
I think i´ve followed all the steps right:
1)added the line in lex.h
{GETUPDATE
Sebastian Tobias Mendel genannt Mendelsohn [EMAIL PROTECTED] wrote:
SELECT product_id, name, description, sales.sale_id
FROM products LEFT JOIN sales ON products.product_id = sales.product_id
WHERE sales.customer_id = 10 AND sales.sale_id IS NULL
This query should return no rows, because if
I've cobbled together a short PERL script to delete older records from the
tables in a database. The DELETE works fine but when I try to put in a
statement to return the number of rows deleted, I get an error.
The code reads as follows:
sub run_query {
# print Query: , $statement, \n;
my
Hi,
Check this first:
http://www.mysql.com/doc/en/CREATE_TABLE.html
On Mon, 2003-09-08 at 18:34, Kraan Deufe wrote:
hi, it's the third time i'm trying to post this message to the list.. so
please reply , even if it is for saying nothing.. only to be sure that this
mail have been distributed.
Kraan Deufe [EMAIL PROTECTED] wrote:
ok here we are,
first of all, hi to every one since i'm new to this list.
then it's my first real advanced experience with mysql, even if i've already
used SQL Server, PostgreSQL and (kof kof) Access.
well, then i'm trying to create a heavy database
To whom it may concerned,
I am a web development support person working for North Carolina AT State
University. I am involved in a library project right now which requires a
MySQL free software installed on my computer so I can create a mysql database
for the project. By searching the internet
Hi!
On Sep 07, Sebastian Hoffmann wrote:
Hello,
I have just updated from MySQL 3.23 to MySQL 4.0.14. My operating
system is Mac OS X (10.2.6).
I have now encountered an odd problem with some select statements
which appear to work differently in the new version:
I want to do a join
I would use MySQL CC (command center, I think...)... I seem to remember someone
mentioning that mysql gui is discontinued...
CC is available from the mysql.org site, and is very easy to install on windows xp
(it's on my laptop...)
-Original Message-
From: Liwen Han [mailto:[EMAIL
On 8 Sep 2003 at 14:15, Jack Coxen wrote:
sub run_query {
# print Query: , $statement, \n;
my $sth = $dbh-do($statement)
or die Can't prepare $statement: $dbh-errstr\n;
$numrows = ($sth-rows); # This is where the problem is
print $numrows;
}
This is a DBI question, not a MySQL
Hi!
On Sep 08, Gustavo Castro wrote:
Hello,
i?m using the 3.23.57 version and i?ve declared a native function, but when
i call it (SELECT GETUPDATE(1);) i
get this line
ERROR 1064: You have an error in you SQL syntax near '(1)' at line 1;
I think i?ve followed all the steps right:
Greetings,
I have been exploring MySQL's full text search feature and have not been
able to find any information on querying a full text search across
multiple tables. Do you have to make recursive queries to each table?
Thank you in advance,
Steve Radabaugh
--
MySQL General Mailing List
For
ups, i knew i had to copy that line properly.
what i added to the lex.h was this
{ GETUPDATE,SYM(FUNC_ARG1),0,CREATE_FUNC(create_func_getupdate)}
i copied the line from the abs function. in fact, as you may see, all my
function is nothing but a copy of the abs function with little
Dan Greene wrote:
I would use MySQL CC (command center, I think...)... I seem to remember someone
mentioning that mysql gui is discontinued...
You remember right, the MySQL GUI IS discontinued. Why it is still
availiable for download, ask MySQL
Jakob
^--
To Unix or not to Unix. That is
What transaction isolation level(s) does BDB support? I can't find any
information on BDB transactions section 7.6 of the manual.
Thanks,
Bill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I am using the binary distribution of mySQL for
Windows-2000 and am not able to connect to the
DBserver. I used the Setup executable to install the
application. I verified that the my.ini file was
created and contained appropriate information. But,
when I right-click with my mouse on the stop
On Mon, Sep 08, 2003 at 03:26:34PM -0700, Bill Todd wrote:
What transaction isolation level(s) does BDB support? I can't find any
information on BDB transactions section 7.6 of the manual.
BDB only does READ COMMITTED.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine,
ups, i knew i had to copy that line properly.
what i added to the lex.h was this
{ GETUPDATE,SYM(FUNC_ARG1),0,CREATE_FUNC(create_func_getupdate)}
i copied the line from the abs function. in fact, as you may see, all my
function is nothing but a copy of the abs function with
are there any issues regarding special characters that
should be escaped when storing binary data in a BLOB
field? any special ascii codes that must be checked
for before inserting data into a table?
i remember reading something about ascii(26) causing
some problems when using mysqldump and
030905 10:39:38 mysqld started
030905 10:39:40 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 2 3128426578
InnoDB: Doing recovery: scanned up to log sequence number 2 3128426578
mysql and php question:
the magic_quotes_gpc is set to 1. when i echo it to
the browser, it shows the added slashes. i inserted
these same values into a database. when i read the
database values and printed them, i forgot to use
stripslashes. but i was surprised to see that the
slashes were
We're considering switching to InnoDB tables for a couple of tables in
our database where we need transactions. We're complete newbies with
reference to innodb, although we are seasoned veterans with regards to
MySQL/MyISAM and general concepts.
We have come up with a couple questions that we
Abs wrote:
mysql and php question:
the magic_quotes_gpc is set to 1. when i echo it to
the browser, it shows the added slashes. i inserted
these same values into a database. when i read the
database values and printed them, i forgot to use
stripslashes. but i was surprised to see that the
slashes
Hi i have just started to use them aswell to do proper relationships
between tables to add data restrictions on deleting records.
1) can you join a MyISAM table to an innodb table in a select?
This seems to work.
2) Under 'Restrictions...' in the manual, it says:
When you restart the MySQL
Since InnoDB does not allow phantom reads with Repeatable Read isolation
(which are allowed in the ANSI SQL definition of Repeatable Read) what is
the difference between these two isolation levels. Is it just serialization
and that is all?
Bill
--
MySQL General Mailing List
For list archives:
Using InnoDB with an autoextend tablespace, if I start a transaction that
results in many record versions, will the rollback segments grow dynamically
and force the tablespace to grow dynamically to provide the required room
for record versions in the rollback segments?
Bill
--
MySQL General
hi,
I am working for our product to support MySQL ansi mode.
But I don't understand the the meaning of the option ONLY_FULL_GROUP_BY, the
description in manual is
You can use a field/expression in GROUP BY that is not in the field list. , but I
think it should be You can't
Isn't it?
thanks
1) can you join a MyISAM table to an innodb table in a select?
Absolutely.
2) Under 'Restrictions...' in the manual, it says:
When you restart the MySQL server, InnoDB may reuse an old
value for an
AUTO_INCREMENT column.
Under what circumstances does this occur?
If you perform an INSERT
Hi all.
I'm using MySQL-4.0.14, compiled by Gentoo's ebuild script.
Somewhere along the line, I've picked up a '--skip-locking' flag that I
can't find the source of.
It's not in the /etc/init.d/mysql script. It's not in my my.cnf. Gentoo
has a start-stop script which is run by scripts in
At 12:00 +1000 9/9/03, Daniel Kasak wrote:
Hi all.
I'm using MySQL-4.0.14, compiled by Gentoo's ebuild script.
Somewhere along the line, I've picked up a '--skip-locking' flag
that I can't find the source of.
It's not in the /etc/init.d/mysql script. It's not in my my.cnf.
Gentoo has a
InnoDB of course does not support
FULLTEXT indexes, and so forth.
Which is a pain, because i want the foreign key relationships but fulltext
indexing at the same time :\
As for transactions , is it simply by doing this?
start transaction
do query
commit
if error
rollback
??
--
MySQL
At 13:06 +1000 9/9/03, [EMAIL PROTECTED] wrote:
InnoDB of course does not support
FULLTEXT indexes, and so forth.
Which is a pain, because i want the foreign key relationships but fulltext
indexing at the same time :\
As for transactions , is it simply by doing this?
start transaction
do query
start transaction
do query
if error
rollback
else
commit
--
Heh thats what i meant ;)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What is all this talk about max db, like why did they go and buy out SAP
DB ? What is going to happen to different databases under the mysql banner
or will the maxdb be implemented in mysql ?
Because some of the features in sap, i think everyone would want into
mysql, man i wish i could code c++
Paul DuBois wrote:
At 12:00 +1000 9/9/03, Daniel Kasak wrote:
It's been suggested that I add 'enable-locking' to the [mysqld]
section of my.cnf.
You might want to reconsider. It's disabled by default on all systems
as of MySQL 4, and was disable by default before that on Linux.
I see.
I had
At 13:25 +1000 9/9/03, Daniel Kasak wrote:
Paul DuBois wrote:
At 12:00 +1000 9/9/03, Daniel Kasak wrote:
It's been suggested that I add 'enable-locking' to the [mysqld]
section of my.cnf.
You might want to reconsider. It's disabled by default on all systems
as of MySQL 4, and was disable by
Conceptually, SERIALIZABLE just adds LOCK IN SHARE MODE to every SELECT
query. Other than that there is not much difference.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Bill Todd [mailto:[EMAIL PROTECTED]
Sent: Monday, September 08, 2003 7:13 PM
To: [EMAIL
Sure, use the --all-databases option instead of $DBNAME
http://www.mysql.com/doc/en/mysqldump.html
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: René Mølsted [mailto:[EMAIL PROTECTED]
Sent: Monday, September 08, 2003 11:51 AM
To: [EMAIL PROTECTED]
Subject: Backing
And will you be making your deadline? ;)
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Sent: Monday, September 08, 2003 10:38 AM
To: [EMAIL PROTECTED]
Subject: Re: Innodb multiple tablespaces
Sean,
I am at this very moment programming them :). The deadline
Well, I saw your message.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Monday, September 08, 2003 7:46 AM
To: [EMAIL PROTECTED]
Subject: Has the list gone down...
I haven't gotten any e-mails from the list in
Well Scott, you're not done installing the Server yet.
Go to the Doc sub_dir of your MySQL root dir. and brows the
*manual_toc.html* file. You will find the info you need to get started
there.
Just a suggestion, don't use the winmysqladmin.exe GUI, or any other GUI
tool for now, get used to the
On Mon, Sep 08, 2003 at 10:42:33PM -0500, Paul DuBois wrote:
See:
http://www.mysql.com/doc/en/System.html
Note the part about Linux.
Paul, you might update that page. It's extoling the virtues of the
2.2 kernel and SMP. But 2.4 is clearly superior in that department.
And the 2GB file
I try to improve the security on the mysql and now I can't get into it.
I get this massage.
Access denied for user: '@localhost' to database 'mysql'
Is the same throw webmin or phpMyAdmin
Can anybody please help
Im runnin Redhat 7.3 and mysql 3.23.56
/harly
--
MySQL General Mailing List
Hi all!
A group of friends and I are looking to build a funky piece of software
that we plan to release under the dual-licencing model that MySQL AB and
Innobase Oy use.
My question, of course, relates to libraries for MySQL access. The code
will be in either C or C++ (which means either the
I have one master and one slave which I am upgrading to 4.0.14 from
4.0.12. To start the upgrade I stopped the slave, took a snapshot of it's
data directory, cleared it's binary logs, and switched to the 4.0.14
binaries. I then restarted the slave thread to get it caught up with the
master.
Eric,
Please read http://www.mysql.com/doc/en/Using_stack_trace.html and
follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
please use the resolve_stack_dump program in combination with the
80 matches
Mail list logo