thanks
may you point out which chapter says?
From manual I get the following answer agaist to my result(my server
version 5.0.45),
For |InnoDB| before version 5.0.3, |TRUNCATE TABLE| is mapped to
|DELETE|, so there is no difference. Starting with MySQL 5.0.3, fast
|TRUNCATE TABLE| is availab
Running on our systems, we have had the replica load data and then
started. The longest delta was about 28 hours behind the master. The
slave status faithfully reported how far behind the master it was, when
the slave was started, even as it was loading its relay-logs from the
master which
I'm attempting to add an index to a table with 70
million rows.
DB server running on a reasonably fast Intel Mac on a
relatively slow drive.
Should this take hours to complete ?
So far it's taken 5 hours and counting. I'm afraid
it's going to destroy my drive !
___
Nice time of the day.
I apologize I am writing on this address because didn't find START NEW THREAD
on mailing lists page.
The problem is this: I have the freshest version of Gentoo Linux, and mysql
within it. Just didn't modify /etc/mysql/my.cnf, commenting only one line:
skip-innodb.
Have re
I wrote; mysql> UPDATE mysql.user SET
Password=OLD_PASSWORD('the_new_password') WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> \quit
Then; shell> mysql -u root -p
Enter password: the_new_password
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
Is this 'caus
On Apr 5, 2005 10:49 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> X y <[EMAIL PROTECTED]> wrote on 04/05/2005 03:51:02 PM:
>
>
> > On Apr 5, 2005 9:06 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > >
> > > Could it be t
On Apr 5, 2005 9:06 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Could it be that you are using a pre-4.1 client with a post-4.1 server? Do
> exactly what you did before except try this:
>
> UPDATE mysql.user SET
> Password=OLD_PASSWORD('my_new_password') WHERE User='root'
Did the abov
sec)
According to http://dev.mysql.com/doc/mysql/en/resetting-permissions.html
I should now be able to login using "my_new_password*, but this
doesn't happen.
What is the next step?
Thank you.
N.P.
On Apr 5, 2005 6:11 PM, X y <[EMAIL PROTECTED]> wrote:
> I do the fol
I do the following;
1. I kill the mysqld-process on the server.
2. I start mysqld_safe by typing; "mysqld_safe --skip-grant-tables &"
3. Logged in as root, I type this shell> mysqladmin -u root
flush-privileges password "my_wanted_password"
4. I try to login as root to the MySQL-server, by
I tried the flush-privileges command and got the following;
mysqladmin flush-privileges
mysqladmin: reload failed; error: 'Access denied. You need the RELOAD
privilege for this operation'
-
So, how can I set full access-rights to root the easiest way?
(thank you)
N.P
-
Over on http://forums.mysql.com/read.php?10,20058,20058#msg-20058 I
posted a msg connected to me having trouble to login to my MySQL
database handler.
I might save some space here in your email by asking you to go to the
above forum-thread, and my last post in the thread goes;
Ok, so I did the fo
SQL DBA by night)
On Tue, 22 Mar 2005 10:48:53 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Z X C V <[EMAIL PROTECTED]> wrote on 03/21/2005 08:32:24 PM:
Hello,
Are there any good rfcs or other documents that would assist in the
discussion I'm having with our organization'
Hello,
Are there any good rfcs or other documents that would assist in the
discussion I'm having with our organization's Oracle programmers in
regards the following:
Oracle DB -> MySQL
They recommend:
~ col~col ~col~ col'",~col
NOTE::I placed the '" in for a reason.
I am looking for:
"col","col"
that solution doesnt work.if you are working on Xpyou
could a system restore.thats what I did.and then I
installed mysql again.
S.
--- "Tam, Michael" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I forgot to reply to the list instead.
>
> This is a recap
Hi,
I tried to uninstall mysql from win Xp.however it did
not remove everything completely.I tried to remove the
files manually but specifically it does not let me
delete mysqld.exe.it says access denied.
Can anyone help me?I would to reinstall mysql.
S.
yes, it should work, but should not be 1,1 ?
or simply:
UPDATE RemoteStation SET company=LEFT(ID, 4); ?
"gerald_clark" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> How about:
> update RemoteStation set company=substring(ID,1,1);
>
> Jeff McKeon wrote:
>
> >Damn fat fingers and
Hi, i have a problem with getting the right return values from field purrdato.
All records exept a few are set with date and the rest is NULL. The field allows Null
values. when using: DATE_FORMAT(purrdato, '%d.%m.%Y') AS purrdato ...it even
returns '00.00.' on null values.
Is there a wa
Hi all,
Can I link two fields in two tables, in the way that if I add a new value
into a table in the other table the value is added automatically, or Do
I need to add the values one time for every table?
Thanks for helping me.
Pedro
--
MySQL General Mailing List
For list archives: http://li
Hi all,
I have to create a database where the elements of a table are related to
elements on the same table. What is the best (optimised) way to do that?
I came with the model:
CREATE TABLE locations(
location_id int(11) auto_increment,
location_name varchar(50) NOT NULL default '',
Hi there,
Is there a way to upload a saved script file into the GUI window to
execute? On the GUI interface, there are SAVE, EXECUTE buttons. But I
cannot find anything for uploading, even copying functions.
Thanks for the help.
Regards,
Sean Tang
Hi, I just got involved into a project that uses MySQL. My team leader told
me that most likely we have to change the file inside the source code of
MySQL in order to use GSS API.
However, I am totally new to this area. I am wondering if there is any
resource that I can find on the internet or
Hmmm, this genereated the error message, "Parse error: parse error in
/directory/connect.php on line 12" - Line twelve is the first "printf..."
line.
Any suggestions?
Chris
-Original Message-
From: Ferhat Can [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 06, 2003 7:04 AM
To: [EMAIL PRO
Hi There,
Just reciently (after no changes) my MySQL database is automatically
incrementing timestamps by one day.
Timestamp format is timestamp(14).
An example date would be 20021021143513
when I use command such as:
INSERT INTO MyTable SET timestamp = 200210211143513;
and then:
ed Hat Linux 7.2 2.96-108.7.2)
Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx1 root root 13 Oct 7 07:43 /lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x1 root root 1285884 S
Hello people,
mysqldump not dumps MERGEd tables structure
it writes TYPE=MERGE and then UNION() with empty parenthesis
so this """dump""" can not be used.
--
Best regards,
Pedro mailto:[EMAIL PROTECTED]
---
I am just getting my feet wet in PHP and MySQL.
I'm using PHPMyAdmin to administer my databases online, and I'm having
trouble importing data from a textfile over the Internet. It imports
one record perfectly and then stops. It gives me no errors.
I have checked access privileges, and indeed
> # httpd
> /usr/libexec/ld.so: httpd: libmysqlclient.so.10.0: No such file or
directory
>
> but I can locate the file at these tree places at the server, so where do
i
> have to place the file before the server can see it does exist. ?
>
> /usr/local/lib/mysql/libmysqlclient.so.10.0
>
/usr/ports/
Hi there,
I'm running into problems with functions "floor/ceiling" when I use
Visual Basic to talk to mySQL through myODBC.
My code looks like this:
sSQL = "select floor(3.2)"
Set rs = MySQL_conn.Execute(sSQL)
I got rs.eof = true after execution of the query. However the following
codes works f
cation and
does not prevent MySQL from being my favourite cup of database tea :)
Thanx!
George
- èçõîäíî ñúîáùåíèå -
Îò: Sinisa Milivojevic <[EMAIL PROTECTED]>
Òåìà: Re: Re: distinct / limit optimization
>X Gogo writes:
>> Well, the order in which the queries are made do
well :)
George
- èçõîäíî ñúîáùåíèå -
Îò: Gerald Clark <[EMAIL PROTECTED]>
Òåìà: Re: distinct / limit optimization
>Because it wasn't in system cache yet?
>
>X Gogo wrote:
>
>> Hi,
>>
>> I've tried the folowing query:
>> SELECT DIS
Hi,
I've tried the folowing query:
SELECT DISTINCT column1 FROM table1 LIMIT 10;
and got the result for 0.23 sec.
Then I've tried the same query without limit:
SELECT DISTINCT column1 FROM table1;
and got the result for 0.01 sec. which is some 23 times
faster. There are about 1 rows i
Well, Jeff you are right! I've just taken the
wrong line from .mysql_history file. It was one
of my thousands of tries to make the ORDER BY work
with UPDATE. What I really try to do is ORDER BY
the 'received' column, which is a timestamp.
The point is if I have plenty of alarm messages
which are n
Hi!
The MySQL manual states that you can use ORDER BY in combination with the
UPDATE statement.
So I tried to use it, but it didn't work. Here is the sql query that's causing
the trouble:
mysql> UPDATE alarms SET is_parsed=1 WHERE is_parsed=0 ORDER BY is_parsed LIMIT
1;
ERROR 1064: You have a
Hello people,
Anyone know how can I _useful_ (without data loss) link
database with tables contains unsigned short columns
thru MyODBC for ugly systems like M$ Access ???
I send this message to MyODBS list, but have no answer...
--
Best regards,
Pedro mailto:[EMA
Fernando,
Te sugiero que veas la página http://mmmysql.sourceforge.net/ por un JDBC y
en su docs vas a encontrar ejemplos de como resolver tu problema.
Si necesitas mayo ayuda, no tengo problema en enviarte porciones de código
donde se resulve este problema.
Maximiliano.
- Original Message -
following,
you should set your directories to the aprpriate values:
./configure --prefix=/ss5/mysql/ --localstatedir=/ss5/mysql/data
--with-unix-socket-path=/ss5/mysql/mysql.sock
>Fix:
None known yet...
>Submitter-Id: [EMAIL PROTECTED]
>Originator:Jack
to scan table: 2213
_mi_search_pos: info: keynr: 31 offset: 1 max_keynr: 112 nod: 0 flag: 0
_mi_search_pos: info: keynr: 41 offset: 0.283186 max_keynr: 61 nod: 3 flag: 1
_mi_search_pos: info: keynr: 32 offset: 1 max_keynr: 112 nod: 0 flag: 1
_mi_search_pos: info: keynr: 41 offset: 0.2920
37 matches
Mail list logo
