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
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
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
/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 following;
1. I kill the mysqld-process on the server.
2. I start
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 above, put
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 that you are using a pre-4.1 client with a post-4.1 server?
Do
exactly
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 'cause I
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
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's Oracle programmers in
regards
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:
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 of what I sent to Vasanthsena x
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 MS
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
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 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:
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
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:
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 Sep 9 12:10 /lib/libc-2.2.4.so
-rw-r--r--1 root root 27336078 Sep 9 11:48 /usr/lib/libc.a
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
# 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
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
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 doesn't matter. The query
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
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
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
Fernando,
Te sugiero que veas la pgina 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 cdigo
donde se resulve este problema.
Maximiliano.
- Original Message
wing,
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: submitter ID[EMAIL PROTECTED]
Originator:Jack Summanen x
Or
h_pos: info: keynr: 27 offset: 0.441176 max_keynr: 40 nod: 3 flag: 1
_mi_search_pos: info: keynr: 75 offset: 1 max_keynr: 169 nod: 0 flag: 1
_mi_search_pos: info: keynr: 27 offset: 0.447059 max_keynr: 40 nod: 3 flag: 1
mi_records_in_range: info: records: 1
Used quick_range on key: 0 (other
35 matches
Mail list logo