Hi,
Here is a tutorial:
=>
/*1. Kill the mysqld that may be running (not with -9):
kill `cat /var/lib/mysql/hostname.pid`
2. Restart MySQL in safe mode:
/usr/bin/safe_mysqld --skip-grant-tables&
3. Connect to MySQL:
/usr/bin/mysql
4. Use the mysql database:
use mysql;
5. Run the upda
--
from [EMAIL PROTECTED]
Hi Robb,
Your table setup is correct. In the third table the two ID fields together
form the Primary Key. This makes sure that you cannot add the same keyword
twice to the same image. If you use MySQL Administrator to create your
tables then you just add both columns to the primary key index.
Prog
Dustin Krysak <[EMAIL PROTECTED]> wrote on 11/25/2005
05:28:12 PM:
> IS there a way to reset a lost mysql root password?
>
>
You obvously didn't research the issue very well. Next time search the
archives and the manual (it also has a search function):
http://dev.mysql.com/doc/refman/4.1/en/r
At 04:16 PM 11/25/2005, you wrote:
Hello all! I was going through my forums yesterday, when suddenly I got a
critical error. The message was 'could not connect to database' so I went
to restart MySQL by going into /usr/local/mysql/var/ and sending a kill
`cat mydomain.com.pid`. and then backed
IS there a way to reset a lost mysql root password?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello all! I was going through my forums yesterday, when suddenly I got
a critical error. The message was 'could not connect to database' so I
went to restart MySQL by going into /usr/local/mysql/var/ and sending a
kill `cat mydomain.com.pid`. and then backed up into the /bin/ and sent
a './mys
On Fri, 25 Nov 2005 10:44:44 -0800, Johan wrote:
>> Option One
>> Related tables. Table one (clipart pieces) contains ClipartID and
>> ClipartName fields. Table two (keywords) contains KeywordID, ClipartID and
>> Keyword fields. This option will create an incredibly large related table
>> (keyword
On Friday 25 November 2005 01:44 pm, Johan wrote:
> > Option One
> > Related tables. Table one (clipart pieces) contains ClipartID and
> > ClipartName fields. Table two (keywords) contains KeywordID, ClipartID
> > and Keyword fields. This option will create an incredibly large related
> > table (ke
> Option One
> Related tables. Table one (clipart pieces) contains ClipartID and
> ClipartName fields. Table two (keywords) contains KeywordID, ClipartID and
> Keyword fields. This option will create an incredibly large related table
> (keywords) with each piece of clipart having tens of related fi
- Original Message -
From: "Robb Kerr" <[EMAIL PROTECTED]>
To:
Sent: Friday, November 25, 2005 11:59 AM
Subject: Seeking Opinions
I'm building a new clipart site. I need to have keyword searching. I'm
seeking opinions about table design. Here are my proposed options. If
anyone has a
Michael Immerman <[EMAIL PROTECTED]> wrote on 11/25/2005 11:52:47 AM:
> I have a query that works perfectly in version 4.1.10a-nt however it
> fails in version
>4.0.24. If someone has any ideas on how to fix the query to run
> in 4.0.24, I would really appreciate it! Thanks - code below:
>
Robb Kerr <[EMAIL PROTECTED]> wrote on 11/25/2005 11:59:48 AM:
> I'm building a new clipart site. I need to have keyword searching. I'm
> seeking opinions about table design. Here are my proposed options. If
> anyone has any other suggestions, please make them.
>
> Option One
> Related tables. Ta
Hello.
>but when I use FORCE INDEX (idx_uid_del) then it is ok and takes
>0.01seconds.. how can I manage that mysql use this index without force
Have you run ANALYZE TABLE for you tables? See:
http://dev.mysql.com/doc/refman/5.0/en/analyze-table.html
Marko Knezevic <[EMAIL PROTECTE
Hello.
>dump, it just cannot restore it back.
Please provide exact actions which you're doing
to restore a backup.
"Sandeep Raul" <[EMAIL PROTECTED]> wrote:
>Hi,
>
>Need your help in restoring mysqldump from version 4.1 to 5.0
>
>We wanted to update our mysql server from version
Hello.
> I have mysql 3.23.55 without innodb and it has one process, with innodb
> it starts with 16 processes.
Information about MySQL threads is available here:
http://dev.mysql.com/doc/internals/en/threads.html
You version of MySQL is very old, I strongly recommend you to upgrade.
Hello.
>innodb_log_file_size=10M
>innodb_log_buffer_size=1M
These variables have too small values, increase them. Follow
other recomendations from:
http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html
Andrew stolarz <[EMAIL PROTECTED]> wrote:
>
>hello, here are my cu
Hello.
> I've seen the 'PURGE MASTER LOGS TO 'mysql-bin.0XX';'
The complete syntax is available at:
http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html
If you have replication you check that SLAVE has read binary logs
which you want to remove.
Luke Vanderfluit wrote:
>
I have a query that works perfectly in version 4.1.10a-nt however it fails in
version
4.0.24. If someone has any ideas on how to fix the query to run in 4.0.24,
I would really appreciate it! Thanks - code below:
Select
ibiBillMth,ibiBillYear,meter,ibiTotChg,id,userid,ibiDaysInBilling
Gleb:
Aha. OK, we tried using OPTIMIZE instead of ANALYZE, and that does
indeed update the Cardinality of the index, the way you would expect.
Thanks very much for figuring this out! I really appreciate the help.
Thanks again!
Allan
"Gleb Paharenko" <[EMAIL PROTECTED]> wrote in message new
I'm building a new clipart site. I need to have keyword searching. I'm
seeking opinions about table design. Here are my proposed options. If
anyone has any other suggestions, please make them.
Option One
Related tables. Table one (clipart pieces) contains ClipartID and
ClipartName fields. Table tw
I have a number of Perl programs running on a Linux system, all using MySQL.
I have to keep track of programs, so I know which ones are working with which
set of data, so programs check in when they start by creating a table entry
and log out when they end by removing that table entry, but ALSO
Hi Scott, all!
Scott Fletcher wrote:
Hi!
I am in the process of upgrading the machine with everything
to a newer versions. This time, I'm getting rid of the IBM DB2 as it
won't be there. So, I downloaded the MySQL 64 bits for the AIX and
extracted it there. The AIX server us
"Peter Lauri" <[EMAIL PROTECTED]> wrote on 11/25/2005 04:43:50 AM:
> Hi,
>
> I have two databases. Database A is located on a server that I run my
web
> hosting from. The other database B is located on a computer with a fixed
IP.
> How can I configure database B so I can access database B from
If you have MySQL > 5.0.3 then you could use this storage engine:
http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html
It is only a recomendation.
Regards!
-Mensaje original-
De: Peter Lauri [mailto:[EMAIL PROTECTED]
Enviado el: Viernes, 25 de Noviembre de 2005 03:44 a.m
using the a sql statement like ds:
select *, match(url, title, comment) against ('movies') as score from dir
where match(url, title, comment) against ('movies')
where dir is a fulltext table of url, titlke and comment
i however found out that if the comment column is empty it will return an
Hi,
is it possible to control how many processes/therads mysqld starts at
startup?
I have mysql 3.23.55 without innodb and it has one process, with innodb
it starts with 16 processes.
MySQL manual:
Section 2.12.1.1. Linux Operating System Notes
...
When using LinuxThreads, you should see a m
When under 5.0 you need to export your data doing a character set translation to
latin1 or iso-8859-1. You also need to adjust the export for compatibilty with
older versions (some SQL verbs used in 5.0 are not understood by older
versions)
Jacques Brignon
You can do that either with mysqldump or
AmirBehzad Eslami <[EMAIL PROTECTED]> wrote on 24/11/2005 18:36:25:
> On 24/11/2005, Alec worte:
>
> > I think this is your problem: MySQL does not properly support
Unicode
> > until version 4.1. I am successfully using FullText with MySQL
> 4.1 to sort
> > UTF-8 encoded Japanese text.
Hi,
I have two databases. Database A is located on a server that I run my web
hosting from. The other database B is located on a computer with a fixed IP.
How can I configure database B so I can access database B from my web
server? From my A system I would like to be able to do INSERT, SELECT and
Hmm ... I'll see what I can do then.
Thanks.
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
>I tri
>
> >I have following query:
> >
> > SELECT SQL_NO_CACHE users.user_name assigned_user_name, accounts.* FROM
> > accounts LEFT JOIN users ON accounts.assigned_user_id=users.id where
> > (accounts.assigned_user_id='1') AND accounts.deleted=0 ORDER BY
> > phone_office asc LIMIT 620300,20
> >
> > In
Hi!
InnoDB does not work on a read-only file system. It needs to write to data
files and ib_logfiles. For example, the transaction id advances also with
SELECT queries, and we need to write it to the files.
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locki
33 matches
Mail list logo
