Is there any problems using the jdbc-driver to connect to a mysql database from a
windows CE device?
Any recommentations?
-Jon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi!
On Sep 09, 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
- Original Message -
From: "Jeremy Zawodny"
Sent: Monday, September 08, 2003 11:33 PM
Subject: Re: --skip-locking and 'enable locking' in my.cnf
> On Mon, Sep 08, 2003 at 10:42:33PM -0500, Paul DuBois wrote:
> >
> > See:
> >
> > http://www.mysql.com/doc/en/System.html
> >
> > Note the par
Bill,
- Original Message -
From: ""Bill Todd"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, September 09, 2003 4:27 AM
Subject: Do InnoDB rollback segments expand dynamically?
> Using InnoDB with an autoextend tablespace, if I start a transaction that
> results
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 my
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.
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 MySQ
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
I’m runnin Redhat 7.3 and mysql 3.23.56
/harly
--
MySQL General Mailing List
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 f
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 com
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
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 d
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: Back
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 PROT
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 d
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
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++ a
> 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]
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
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 Gen
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 start-sto
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 /etc/in
> 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 I
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?
t
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 Ma
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: h
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 M
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
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 have
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 already
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
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 dumpin
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 lit
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, Yaho
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
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]
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
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
modi
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 li
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
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 questio
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
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 d
To whom it may concerned,
I am a web development support person working for North Carolina A&T 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
"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 heav
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
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
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 ro
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"
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 r
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" | g
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 http://www.mys
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 Corpor
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 Gen
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 k,kurs_hu
"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
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 rows
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.
"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 WHE
> >
> 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
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 Ha
* 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.
> 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:http:/
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 - http://www.mysql.com/doc/en/ANSI_diff_Subqu
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 al
Gustavo,
Prefix them with 'SELECT ;' (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 i have to add
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 t
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.
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]
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 queri
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 j
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
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 L
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 att
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 the
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 t
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 t
On Fri, 5 Sep 2003 11:54:13 -0400, <[EMAIL PROTECTED]> wrote:
What is the best version of PHP to use with MySQL on Win32 to
interact with the MySQL database in web-enabled forms with submit
button?
Use latest _stable_ release - http://php.net/download
Also read http://www.php.net/manual/en/instal
"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
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 Netherl
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 Fire
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 gra
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.
>
83 matches
Mail list logo