Are you trying to restart the master server, or 'reseting' the master?
my master server always shutdown daily, and the slave happily catch up
the next day, it's been goin for some 6 months with heavy traffic
it's a different story if you want to reset the master, you should
capture the master and
Dear All,
When I register a new user in my (php4.1 & MySQL 4) application, using:
$insertSQL = "INSERT INTO tblusers (uname, usurname, uusername, upassword)
VALUES ('$name', '$surname', '$username', password('$password'))";
an asteriks (*) is posted with the encrypted password to the password fi
Hi Gleb,
I understand that the replication shouldn't break, but restarting master
means losing the updates made to the master database, which we can't
afford to do that.
TA
>
>Hello.
>
>Why are you afraid of shutting down the server for a while?
>Is it so critical? If yes, send more detailed de
Hello,
I'm running mysql 4.0.12
I have a bookings database in which I'm having problems pulling out the
available accomodation.
Tables are:
Accomodation - accomid (primary key), town, address, contactnumber etc
student_accom - studentaccomid (primary key), accomid, studentid
My query is as follo
Actually, many people use the term "subselect" where you prefer "subquery";
I've heard "subselect" quite a bit in 20+ years of working with relational
databases. Not the MySQL people perhaps but it is a reasonable term to use
in a search
Rhino
- Original Message -
From: "Jasper Bryan
I am trying to populate a table using the archive
engine that I estimate will take up ~ 8gb of disk
space when finished. Right now I am crashing the
server as soon as my file gets to the 2gb mark. OS is
linux and there are other files on the same filesystem
that are 30gb+ so I know the fs has sup
Hello everybody,
I use a table for caching, the table is quite simple there is "id"
field which is a md5 on some attributes of an object, a timestamp field
and a text field for storing the data.
| id char(32) | timestamp | data (text) |
We clean the table every 2 mins for data older that 10
Scott Haneda wrote:
Google this:
subselect site:dev.mysql.com
And I get mostly non English stuff, limiting to english and I get a whopping
37 pages, none of which seem to help me much.
Try googling for "subquery", considering that's what they're called...
Jasper
--
MySQL General Mailing List
Hi,
(mysql server 5.0.15 running under linux)
I suppose this is a classic task. I just hope MySQL 5.0 is able to give
the right result.
I would like to select top three from different parts in the same table,
e.g. for the following data set:
id,value
1,10
1,20
1,30
1,40
1,50
2,10
2,20
2,30
2,40
Hello, with the release of 5, I seem to have all dead links to my old docs
for mysql 4. The way they keep changing the urls is a little maddedning :-)
Can someone step me through this, how, on the mysql site, do I find out
about subselects, and more specifically, what version of mysql they were
a
At 18:33 -0800 11/16/05, Scott Haneda wrote:
Sometimes I paste in something in mysql CLI and it just does this:
"> WHERE products.ship_status != 1
"> );
"> /c
"> \c
"> \c;
">
I tried all the \c commands and nothing will get me out of it, I can ^c and
it will get me o
On 11/16/05, Scott Haneda <[EMAIL PROTECTED]> wrote:
> Sometimes I paste in something in mysql CLI and it just does this:
>"> WHERE products.ship_status != 1
> "> );
> "> /c
> "> \c
> "> \c;
> ">
>
> I tried all the \c commands and nothing will get me out of it, I can
On Wed, Nov 16, 2005 at 06:33:40PM -0800, Scott Haneda wrote:
> Sometimes I paste in something in mysql CLI and it just does this:
>"> WHERE products.ship_status != 1
> "> );
> "> /c
> "> \c
> "> \c;
> ">
>
> I tried all the \c commands and nothing will get me out of
Sometimes I paste in something in mysql CLI and it just does this:
"> WHERE products.ship_status != 1
"> );
"> /c
"> \c
"> \c;
">
I tried all the \c commands and nothing will get me out of it, I can ^c and
it will get me out, but then I have to login again, which is a
Ryan,
Try to use this date functions.
* DATE_ADD(date,INTERVAL expr type) , DATE_SUB(date,INTERVAL expr type)
These functions perform date arithmetic. date is a DATETIME or DATE value
specifying the starting date. expr is an expression specifying the interval
value to be added or subtracte
> Hi! It is a common error, have a look here:
> http://dev.mysql.com/doc/refman/5.0/en/old-client.html
>
> I have had the same error.
Tbanks. I found that -- eventually -- in the manual. It took several
searches to find it but it seems to work now, not only for my Tcl
application but for MySQL
Hi! It is a common error, have a look here:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html
I have had the same error.
++
| ISC Edwin Cruz García |
| IT Manager |
| Transportes Medel Rogero SA de CV
I'm trying to upgrade MySQL from v4.x to v5.0 under an existing
Tcl-based application that uses MySQLTcl and I'm getting:
mysqlconnect/db server: Client does not support authentication
protocol requested by server; consider upgrading MySQL client
Is there something I can do to MySQL v5 server
Hi,
Does the current latest MySQL 5.0 support:
1. column based triggers
2. trigger restriction
3. multiple triggers of same type of the table
4. triggers reference another table
And any information on in which release they will be supported?
Thanks,
Jenny
Hi folks,
You might be amazed getting answers that link right to the MySQL
documentation. The documentation is fabulous, but of course we cannot
memorize it! One tip I picked up in a MySQL course (which was worth
the $$ of the course itself), which is IMMENSELY useful, is the
following:
If you
"Kraer, Joseph" <[EMAIL PROTECTED]> wrote on 11/16/2005 04:17:17 PM:
> First let me say that I'm a newbie and that I've seen a few instances of
> this error in the list, but I haven't seen my case.
>
> I'm running WAMP5, v. 1.4.4. I'm trying to restore an Eventum v. 1.4
> backup done with mysqld
Hi Again Bjorn,
Further to my thoughts below, I had a look at the source (5.0.13 -
sql/sql_insert.cc) and the last_insert_id is set for each iteration of the
INSERT loop. There would be three inserts for the three values that you
proposed INSERTing and the last_insert_id seems to be set each ti
First let me say that I'm a newbie and that I've seen a few instances of
this error in the list, but I haven't seen my case.
I'm running WAMP5, v. 1.4.4. I'm trying to restore an Eventum v. 1.4
backup done with mysqldump in a LAMP machine. The restoration process
invariably stops at line 517. I
Hello.
> If I try to run mysqlshow, I see:
>
> C:\Documents and Settings\Chris>mysqlshow sql
> mysqlshow: Access denied for user 'ODBC'@'localhost' (using
password: NO)
ODBC is default username that is used on Windows. Create a new user
account and use it to connect to the MySQL se
Hi,
I just downloaded MySQL Administrator 1.1.0 for Mac OS X. When I run it,
I can see the connection dialogue, when I click to connect, it crashes.
MySQL Query Browser, also latest version, just installed, too, works
perfectly with the same (and only) connection. Crash report from OS X is
attached
Morning Bjorn,
I would have throught the insert would translate as three separate inserts to
the internals of MySQL. As this is really a convenient shorthand to allow us to
bunch up a lot of inserts.
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 50
Logan, David (SST - Adelaide):
> It looks like the LAST_INSERT_ID() is returning the id of the last
> auto_increment INSERT, this seems to be in line with the documentation.
>
>
>
> The ID that was generated is maintained in the server on a per-connection
> basis. This means that the value which t
vishal wrote:
i am sending the files.
all details are in the source code
what you have to do is to create a database name test2 and have to set the
password of the server.
the code will automatically create a table name test2 with two double fields
and it will reture the error while adding the
i am sending the files.
all details are in the source code
what you have to do is to create a database name test2 and have to set the
password of the server.
the code will automatically create a table name test2 with two double fields
and it will reture the error while adding the record through r
Michael,
Thanks for the detailed response.
First off, it's a network connection, but I forgot to
show the -h in my example. Sorry for the lack of
clarity there.
The error message that I'm getting is:
ERROR 1045: Access denied for user
'myuser'@'host.mydomain.com' (using password: YES)
So then,
David Lombardi would like to recall the message, "What does MIN_ROWS table
option do?".
Hello list,
I compiled I special mysql-5-1-2 with the following configuration:
./configure --with-ndbcluster
--prefix=/mycomputer/mysql-5.1.2-binary --with-partition
--with-row-based-replication --without-innodb --without-berkeley-db
--enable-thread-safe-client --enable-shared
Afterwards
Gleb,
Thanks; using REPLACE(), as I understand it, would require me to list ALL
non-alpha characters, and assuming just ASCII characters, approx (127 - 52)
nested calls to REPLACE()...
select
REPLACE(
...REPLACE(
REPLACE(
REPLACE(
text,'~',''),
Dear All
It happens after these condition
InnoDB: ## Diagnostic info printed to the standard error stream
InnoDB: Warning: a long semaphore wait:
--Thread 1103972416 has waited at ../include/btr0btr.ic line 28 for
369.00 seconds the semaphore:
S-lock on RW-latch at 0x88cdd6b8 created in fi
Scott Haneda <[EMAIL PROTECTED]> wrote on 11/16/2005 05:44:05 AM:
> Some of these tables are rather large, I would put the schema in there,
but
> I think it just adds to the mess.
>
> Tables
> `users` field id is auto inc pk
> `orders` field id is auto inc pk
> `products` field id is auto inc pk
Hello.
MySQL AB recommends a gradual upgrade. See:
http://dev.mysql.com/doc/refman/4.1/en/upgrade.html
http://dev.mysql.com/doc/refman/5.0/en/upgrade.html
Cedric Gavage wrote:
> Hi all,
>
> A little question...
>
> Can I upgrade directly a server with MySQL 3.23.x version whi
Hello.
According to the manual "Unix timestamp (seconds since '1970-01-01
00:00:00'", so, in my opinion UNIX_TIMESTAMP is not designed for
obtaining microseconds. Have a look here, if you haven't done this
yet:
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
Ryan
Hello.
Why are you afraid of shutting down the server for a while?
Is it so critical? If yes, send more detailed description of your
situation. Replication shouldn't break. From:
http://dev.mysql.com/doc/refman/5.0/en/replication-features.html
"It is safe to shut down a master server and
Hello.
Really, in my opinion, it contradicts with the manual. Please, send me
the bug id in case you'll report the bug.
Björn Persson wrote:
> Gleb Paharenko:
>
>>Could you provide a repeatable test case for you problem?
>
>
> I don't know how repeatable this is. As I said I have
I have MySQL with about 12 billion rows
when i try to create 2 process, each select count(*) on the same
table after a long time about 30 minutes
it crashed :(
ANy information?
Log file :
051116 20:27:22InnoDB: Assertion failure in thread 2366216768 in file
srv0srv.c line 1873
InnoDB: W
I've just installed MySQL v5.0.15 on my 'Windows XP system and most ways
I want to connect to it fail. I don't see what I'm doing wrong. I've
searched the manual, the web, and the forums without seeing anything
that clearly addressed my problem. Help, please!
If I navigate through Programs / MySQL
Hi all,
A little question...
Can I upgrade directly a server with MySQL 3.23.x version which has some
MyISAM databases (no problem with it) and some InnoDB databases towards
MySQL 4.1.x? Or have I to do a dump and restore instead of re-use databases?
wdyt?
--
Cedric Gavage - [EMAIL PROTECTED]
Hello.
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/symbolic-links.html
>I am new to Mysql, and we are using Mysql as the backend database in >out
>data server, and I wonder if how I create a symbol link under the Mysql
>data
>directory to link to a database under another di
Hi listers,
[EMAIL PROTECTED]:~> rpm -qa |grep -i mysql
MySQL-server-4.1.14-0
MySQL-shared-4.1.14-0
MySQL-client-4.1.14-0
[EMAIL PROTECTED]:~>
[EMAIL PROTECTED]:~> uname -a
Linux myhost 2.6.5-7.108-default #1 Wed Aug 25 13:34:40 UTC 2004 i686
i686 i386 GNU/Linux
[EMAIL PROTECTED]:~>
on 12.
Hi Ryan,
On Wed, 2005-11-16 at 19:16 +0800, Ryan Escarez wrote:
> is it possible to get the the given (unix)timestamp in milliseconds
> since the epoch?
No, it is not possible. However this is on the roadmap.
This is also reported as Bug #8523:
http://bugs.mysql.com/bug.php?id=8523
Regards,
Pe
is it possible to get the the given (unix)timestamp in milliseconds
since the epoch?
tia!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Some of these tables are rather large, I would put the schema in there, but
I think it just adds to the mess.
Tables
`users` field id is auto inc pk
`orders` field id is auto inc pk
`products` field id is auto inc pk
`order_items` field order_id is the key for hooking up order_items to
orders, al
is possible to get UNIX timestamp with microseconds
when i try the following it just give 10 digits
mysql>SELECT unix_timestamp('20051114095641'+ INTERVAL 0 HOUR) as ts;
output :
1131933401 <--- 10 digits
any tips?
tia!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
48 matches
Mail list logo
