No, with the default transaction isolation level, REPEATABLE READ,
that's how it is supposed to work. You've started a transaction in
Window B, so Window B is immune to changes made in Window A until you
finish the transaction in Window B. See the manual for details
Hello.
Yesterday I try to migrate a database from mysql version is '4.1.5-gamma' to
mysql version 3.23.45 using mysqldump:
.
loki# mysqldump clasificados /usr/backup/clasificados.sql
You should remove column and table options. Some of
Hello.
Program options can be specified in different ways, check them
all. See:
http://dev.mysql.com/doc/mysql/en/program-options.html
What name does the hostname program reports?
Tedy Aulia [EMAIL PROTECTED] wrote:
Hi All,
I have found that the binlogfiles have changed their
Shaun [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
[EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Shaun [EMAIL PROTECTED] wrote on 08/31/2005 04:56:23 PM:
[EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Shaun [EMAIL PROTECTED] wrote on 08/31/2005
Hello All,
I have a strange situation while doing Bulk upload (using LOAD DATA
FILE). I have a database which has 60 records, when I try to insert
1 more records it is taking around 50-55 seconds to complete the task
(I feel this is much higher than the normal timings). I notice
Hi Folks!
I have a problem with a subquery using MySQL 4.1.12 (Fedora Core 4). I
will include the SHOW CREATE TABLE for the two tables involved. Please,
forgive me if I include this information in my original language (Spanish)
but I wish to keep the field names as is to avoid any mistake.
Hi all,
Ive read this link http://dev.mysql.com/doc/mysql/en/gone-away.html;
hoping
this has something to do with the error...
Ive already checked based on the page the list of roots of error to
produce
gone-away.. w/c i hope leads to Lost connection to MySQL server during
Hello!
I've heard that LIMIT is a MySQL specific, and cannot be used in any other
DBMS. Is there any portable alternative to LIMIT? I'd like to create a
portable PHP pager for a web site, but all the tutorials that I've found,
contain solutions based on the LIMIT usage.
Thanks!
--
Good
Hi,
mysql SELECT criterio, idSite
- FROM dominios_propios_completos
- WHERE criterio NOT IN (
- SELECT criterio_pub
- FROM sites_criterios
- );
Empty set (0.05 sec)
Do you have NULL values in sites_criterios.criterio_pub ?
--
Pooly
Webzine Rock :
Vladimir B. Tsarkov wrote:
Hello!
I've heard that LIMIT is a MySQL specific, and cannot be used in any other
DBMS. Is there any portable alternative to LIMIT? I'd like to create a
portable PHP pager for a web site, but all the tutorials that I've found,
contain solutions based on the
Hi Pooly!
mysql SELECT criterio, idSite
- FROM dominios_propios_completos
- WHERE criterio NOT IN (
- SELECT criterio_pub
- FROM sites_criterios
- );
Empty set (0.05 sec)
Do you have NULL values in sites_criterios.criterio_pub ?
Yes Pooly, certainly it
2005/9/1, Vladimir B. Tsarkov [EMAIL PROTECTED]:
Hello!
I've heard that LIMIT is a MySQL specific, and cannot be used in any other
DBMS. Is there any portable alternative to LIMIT? I'd like to create a
portable PHP pager for a web site, but all the tutorials that I've found,
contain
Hi,
what is the error in your error log ?
Does your server crash for every query it makes ? Or only some ?
Are you using the official binary from MySQL or the one used for you
distro vendor ?
Are you using UDF ?
... We need more inputs ;-)
2005/9/1, JM [EMAIL PROTECTED]:
Hi all,
Ive
Hi List
I look up on the online manual for directions for this kind of upgrade
but i found nothing.
Is there something I have to do extra or the upgrade so smoth?
Osvaldo Sommer
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database:
It does not seem fine to me, mysql seems to really get slow once you
break about the 3 gig myd size, or 1.5 gig myi size
not sure why, I've changed every setting, but nothing seems to help
Matt
Clyde Lewis wrote:
Matt,
Looking at how the database if currently configured, do you have any
Osvaldo Sommer wrote:
Hi List
I look up on the online manual for directions for this kind of upgrade
but i found nothing.
Is there something I have to do extra or the upgrade so smoth?
Osvaldo Sommer
See http://lists.mysql.com/mysql/186726
--
Nuno Pereira
--
MySQL General Mailing List
David Griffiths wrote:
No, with the default transaction isolation level, REPEATABLE READ,
that's how it is supposed to work. You've started a transaction in
Window B, so Window B is immune to changes made in Window A until you
finish the transaction in Window B. See the manual for details
Shaun [EMAIL PROTECTED] wrote on 09/01/2005 05:38:01 AM:
big snip -- see earlier posts in this thread for details
The corrected query should read:
SELECT m.name as month, YEAR(b.Booking_Start_Date) as year,
COUNT(b.Booking_ID) AS Num_Bookings
FROM monthList m
LEFT JOIN Bookings b
JM [EMAIL PROTECTED] wrote on 09/01/2005 06:01:57 AM:
Hi all,
Ive read this link http://dev.mysql.com/doc/mysql/en/gone-away.
html hoping
this has something to do with the error...
Ive already checked based on the page the list of roots of error
to produce
gone-away.. w/c i
Vladimir B. Tsarkov [EMAIL PROTECTED] wrote on 09/01/2005 06:16:12 AM:
Hello!
I've heard that LIMIT is a MySQL specific, and cannot be used in any
other
DBMS. Is there any portable alternative to LIMIT? I'd like to create a
portable PHP pager for a web site, but all the tutorials that
[EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Shaun [EMAIL PROTECTED] wrote on 09/01/2005 05:38:01 AM:
big snip -- see earlier posts in this thread for details
The corrected query should read:
SELECT m.name as month, YEAR(b.Booking_Start_Date) as year,
COUNT(b.Booking_ID) AS
__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: cannot create database
Description:
I have already set the path to c:\mysql\bin
Thanks, but that link is for 4.1.x and not for 4.0.x
Osvaldo Sommer
-Original Message-
From: Nuno Pereira [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 01, 2005 7:38 AM
To: Osvaldo Sommer
Cc: mysql@lists.mysql.com
Subject: Re: Upgrade from 4.0.12 to 4.0.25
Osvaldo Sommer wrote:
Martijn Tonies wrote:
I wonder how I'll get a div-function in SQL?
I dunno, maybe by looking in the manual? From [1]:
Division:
mysql SELECT 3/5;
- 0.60
[1] http://dev.mysql.com/doc/mysql/en/arithmetic-functions.html
Gustav is looking for the DIV-function.
But it is there
|DIV|
dEeZAcK SweETtY wrote:
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
From: [EMAIL PROTECTED]
To: [EMAIL
MySQL on Palm.
It's possible? Anyone have just tried?
Any suggestion will be appreciated.
Paolo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
dEeZAcK SweETtY [EMAIL PROTECTED] wrote on 09/01/2005 10:27:28
AM:
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: cannot create
Hello.
Have a look here:
http://dev.mysql.com/doc/mysql/en/dns.html
You may want to start mysqld with the --skip-name-resolve option.
Hi,
Thanks for the reply. I did see that page before, but
I guess my bigger question is why if the DNS is broken/slow, why
does the entire
(please, either top-post or bottom-post but don't mix it up)
One way to bypass a broken DNS server is to create complete HOSTS files on
your servers. That way you can keep using your hostnames but avoid the
problems of actual DNS server negotiations going sour as all hostname to
IP address
Hi,
(Lets not get into top/bottom/mixed post discussions. :) )
I'm not sure why putting in hosts would make a difference.
Doesn't the --skip-name-resolve bypass any sort of name resolution,
be it /etc/hosts or resolver? Or are you telling me to change
nsswitch.conf from hosts:
I don't know how your OS does it or what you need to do to use it, but if
I have a file called HOSTS in my (c:\winnt\system32\drivers\etc\ directory
(each OS has a similar location for this file)) that contains a list of
hostname - IP address pairs then whenever I attempt to do a hostname
We are running mysql 4.1.13 on solaris 9 box. Everything was fine until
someone accidentally deleted the mysql directory where the application was
installed. I had to retrieve it from our backup tape. I then stopped and
started mysqld daemon. Please note that we had installed mysql with the
I believe you - I'm just a but surprised. I guess I had a singular view
of how a session should work based on Oracle. I would have expected that
until you execute SQL that requires a commit or a rollback, you wouldn't
be in a transaction. Unfortunately, if you have connections that are
read
If you are NOT in autocommit mode, your connection (or the server, it
doesn't matter which) starts a transaction *when you issue your first
command*. Every command you issue on that connection is in that initial
transaction until you EXPLICITLY commit or rollback (or do something else
that
Hey all,
Trying to upgrade MySQL from 3.23 to 4.0.16 on a new fedora core3
system.
I keep getting the following when I run the servers-standard rpm...
Preparing...###
[100%]
1:MySQL-server-standard
Yah, I tested in SQL*Plus - one window could see inserts, updates and
deletes that had been committed in another window (in which a commit or
rollback had not been issued). I ran the test again - delete data from a
table in one window and commit the change, and a select in the other
window
Does anyone know of a straght forward approach to migrate a
mysql(4.1.11) Schema to Oracle(9i release 2).
Also, please provide any best practices.
Thanks in advance.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Is it just me or are there no RPMS for x86 64bit? Does this mean I
am stuck using the 32bit version? This machine has 16gigs of ram
and the 32bit version won't be able to make use of all of it.
thanks,
M
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Mayuran Yogarajah wrote:
Is it just me or are there no RPMS for x86 64bit? Does this mean I
am stuck using the 32bit version? This machine has 16gigs of ram
and the 32bit version won't be able to make use of all of it.
thanks,
M
Sorry Ignore this, Intel EM64T rpm works just fine.
M
--
You need to talk to Oracle, or look on an Oracle mailing list. People
here are more concerned about migrating from Oracle to MySQL, rather
than the other way around.
There are probably lots of commercial tools out there that will do it
(and compared to your Oracle licensing costs, they are
Does anyone know if it is possible to populate values
into an Excel spreadsheet from a MySQL database? Can I
do this directly in Excel or do I need to create an
external program to do the work (i.e. in VB).
Thanks
-Nick
__
Do You Yahoo!?
Tired of
Hello,
I have 200-300 kb slow log daily with fulltext queries only :-( All
queries using fulltext indexes. I use huge mysql cofig (huge.cfg).
What can I change in the mysql configuration for better performance?
Sincerely,
Michael,
http://xoib.com/ http://3d2f.com/
http://qaix.com/
Automatically populate??
Not that _I_ know of, but of course there are those on this list that know
much more than I.
I do know that you can export the values into tab delimited format and then
import it into Excel.
I think that you may want to do this via ASP or PHP. It would make life a
lot
Nick Jones wrote:
Does anyone know if it is possible to populate values
into an Excel spreadsheet from a MySQL database? Can I
do this directly in Excel or do I need to create an
external program to do the work (i.e. in VB).
Thanks
-Nick
__
Do
Look at http://www.ispirer.com
It is free and very good tool to do it. I did it from Oracle to MySQL, but
you can do it from Mysql to oracle. Good luck!
-Original Message-
From: David Griffiths [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 01, 2005 2:17 PM
To:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Today mysql 4.1.8 has a segmentation fault (signal 11), and crashed.
In the process one table was left corrupted, when it started back up.
An application continued to call insert...select on the corrupted table
as it wasn't realized this happened.
Vladimir,
Is there any portable alternative to LIMIT? I'd like
to create a portable PHP pager for a web site ...
No, there's not a 'super SQL' which all SQL engines understand. To hide
the details of LIMIT | TOP from your apps, you can write a PHP funcion
which applies or updates the
--- J.R. Bullington [EMAIL PROTECTED] wrote:
Automatically populate??
Not that _I_ know of, but of course there are those
on this list that know
much more than I.
I do know that you can export the values into tab
delimited format and then
import it into Excel.
I think that you
Nick Jones [EMAIL PROTECTED] wrote on 09/01/2005 03:18:39 PM:
--- J.R. Bullington [EMAIL PROTECTED] wrote:
Automatically populate??
Not that _I_ know of, but of course there are those
on this list that know
much more than I.
I do know that you can export the values into
Nick Jones wrote:
--- J.R. Bullington [EMAIL PROTECTED] wrote:
Automatically populate??
Not that _I_ know of, but of course there are those
on this list that know
much more than I.
I do know that you can export the values into tab
delimited format and then
import it into Excel.
I
Hi,
I'm running FreeBSD 5.4 on the system in question. It was
my understanding on newer Unixes that things like a call to gethostbyname(3)
would cause it to go against the nsdispatch(3) in libc and determine
what method to perform its various lookups. Right now its set to
read
Here's a little heads-up, as you will need some XML coding to make it look
right.
PLEASE NOTE: I'm an ASP programmer, so PHP is a little foreign to me. You
will need to do some conversion.
Here is the way to do it:
1) Define your recordset and connection strings.
2) Write PHP strings to add
--- Partha Dutta [EMAIL PROTECTED] wrote:
Nick Jones wrote:
--- J.R. Bullington [EMAIL PROTECTED]
wrote:
Automatically populate??
Not that _I_ know of, but of course there are
those
on this list that know
much more than I.
I do know that you can export the values into
Clyde,
Does anyone know of a straght forward approach to migrate a
mysql(4.1.11) Schema to Oracle(9i release 2).
Also, please provide any best practices.
Check out our database development IDE (running on Windows):
Database Workbench - works with Oracle, MySQL, Firebird,
InterBase and MS SQL
I'm running MySQL 4.0.23-standard, and trying to create a stored function.
Am I doing something wrong, or can I not create a stored function in 4.0.23?
What I want is a stored function to take an int from a column and alter it
(mask off the low 16-bits).
SQL-query :
CREATE FUNCTION hello(
s
Start your day with Yahoo! - make it your home page From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: cannot create database
Description:
How to get the promt mysql?
Usually i will follow the steps at the command prompt:
1.cd..
2.cd
Thanks for your reply Gleb,
I understand that we can setup the binlogfile name in 'my.cnf' file, but
I am sure that there is no change in the 'my.cnf'.
The hostname program reports the machine name correctly i.e. foo.
Cheers,
Tedy
-Original Message-
From: Gleb Paharenko
Thanks for your reply Gleb,
I understand that we can setup the binlogfile name in 'my.cnf' file, but
I am sure that there is no change in the 'my.cnf'.
The hostname program reports the machine name correctly i.e. foo.
Cheers,
Tedy
-Original Message-
From: Gleb Paharenko
Mysql 4.0.18-standard
revoke all on *.* from 'deleteatanytime'@'localhost';
mysql revoke all on *.* from 'deleteatanytime'@'localhost';
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
mysql revoke all on *.* from [EMAIL PROTECTED];
ERROR 1045: Access denied for
Its pretty simple for me to audit my databases and see what ones are old,
and can be dropped or whatever, is there some way to get a list of users
that are not hooked into any databases, so I can delete those, since they
are no longer needed?
--
60 matches
Mail list logo