is that MySQL does not flush the key cache for the
locked tables until UNLOCK TABLES is called. Normally, the
key cache is flushed after each SQL statement.
/snip
Regards
Keith Roberts
In theory, theory and practice are the same;
in practice they are not.
--
MySQL General Mailing List
For list
? Or is this a contradiction in terms?
Regards
Keith
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
:
To: mysql@lists.mysql.com
From: Nico Schefer [EMAIL PROTECTED]
Subject: Undelete rows with .MYD-File?
Hi!
Today i've dropped a MySQL-table and realized seconds later that i've
dropped the wrong one.. I've saved the .MYD-File and tried to recover it
with a tool (MySQLRecovery 1.5), but it just
I have downloaded the table files and this is what I get:
mysql use swissmade;
Database changed
mysql show tables;
+-+
| Tables_in_swissmade |
+-+
| shop_item |
+-+
1 row in set (0.00 sec)
mysql select * from shop_item \G
IIRC there may be a hidden field in each table row that
mysql uses to mark that row as deleted.
I'm not sure if you can use some mysql utility program such
as myisamchk to undelete the rows.
This may be possible.
Regards
Keith
In theory, theory and practice are the same;
in practice
Recordlength: 295
It looks like someone has packed this table with myisampack,
which means it's read only. Did you use myisampack on the
table before it got dropped Nico?
Also, did mysql die when the table was in use?
I have tries to run myisamchk -r shop_item.MYI but this sets
As my server does not get alot of traffic I tend to shutdown
mysql, and do an OS copy of the complete /var/lib/mysql
directory to another partition on another drive. Then
restart mysql again.
This may not be a feasable option on a busy server.
Obviously each person has their way of doing
to
another data ditrectory.
Try to take a dump or try using snapshot your datadirectory.
If it is a less MB database you can user as:
In mysql prompt.
flush tables with read locks
dont exit you mysql terminal
Open an another terminal tar -cvzf you mysql old datadirectory and then
after doing so
Do you have some sort of visual process manager for Mac OS X
that can tell you at a glance if mysqld_safe and mysql
server are actually running in memory?
Under linux I use a program called qps.
http://www.student.nada.kth.se/~f91-men/qps/
You may already have a similar utility to view
Here are some screen snapshots of qps showing mysql server
running on my machine.
I tries to post these to the list, but they went over the
file size limit for the mailing list.
Showing mysql running in memory without using mysqld_safe script:
http://www.karsites.net/KAR/websites/pub
On Sun, 2 Apr 2006, Chris Kantarjiev wrote:
To: mysql@lists.mysql.com
From: Chris Kantarjiev [EMAIL PROTECTED]
Subject: Re: stunningly slow query
The problem with Load Data is the larger the table, the
slower it gets because it has to keep updating the index
during the loading
:
To: mysql mysql@lists.mysql.com
From: Octavian Rasnita [EMAIL PROTECTED]
Subject: searching for words with special chars
Hi,
Is it possible to create a query that searches for records which contains
words with special chars and with their english correspondents?
For example, if a user searches
I'm just wondering if it would be possible to use several
apache servers on different ports and using virtual servers,
that would each talk to a different instance of mysql, each
running on different unix sockets?
The main apache server listening on port 80 could then
redirect requests
Use SELECT DATEDIFF('new_date', 'old_date');
mysql SELECT DATEDIFF('2006-04-01','2006-04-01');
+-+
| DATEDIFF('2006-04-01','2006-04-01') |
+-+
| 0
I'm not saying it is an apache issue Gary.
I was just suggesting a way you might be able to implement
several different mysql server instances, and still have one
apache instance for your users to connect to via port 80.
Each mysql server instance could be bound to an apache
server instance
if you are running out of file handles,
which would make mysql wait untill there are enough file
handles free, for mysql to do it's job.
quote
open_files_limit
The number of files that the operating system allows mysqld
to open. This is the real value allowed by the system and
might be different
ALTER TABLE requires a table name for the current database.
You can specify:
ALTER TABLE db_name.tbl_name MODIFY col_name ...
or
mysql alter table test1.t1 modify test1.t1.set1 varchar(30);
Query OK, 0 rows affected (0.05 sec)
Records: 0 Duplicates: 0 Warnings: 0
but you cannot modify
with
references. See Section 1.9.5, MySQL Differences from
Standard SQL.
You cannot add a foreign key and drop a foreign key in
separate clauses of a single ALTER TABLE statement. You must
use separate statements.
InnoDB supports the use of ALTER TABLE to drop foreign keys:
ALTER TABLE tbl_name DROP
Quote
If you use ALTER TABLE on a MyISAM table, all non-unique
indexes are created in a separate batch (as for REPAIR
TABLE). This should make ALTER TABLE much faster when you
have many indexes.
This feature can be activated explicitly. ALTER TABLE ...
DISABLE KEYS tells MySQL to stop
there are
any errors in the table.
Keith
In theory, theory and practice are the same;
in practice they are not.
On Wed, 29 Mar 2006, Sander Smeenk wrote:
To: mysql@lists.mysql.com
From: Sander Smeenk [EMAIL PROTECTED]
Subject: Re: MySQL 5.0.19-2 and repair problems...
Quoting Kishore Jalleda
row, then deleting the first row from the
table?
Would that work?
Keith
In theory, theory and practice are the same;
in practice they are not.
On Thu, 30 Mar 2006, Daniel Kasak wrote:
To: Stanton, Brian [EMAIL PROTECTED],
'mysql@lists.mysql.com' mysql@lists.mysql.com
From: Daniel Kasak
On Tue, 28 Mar 2006, Áquila Chaves wrote:
To: mysql@lists.mysql.com
From: Áquila Chaves [EMAIL PROTECTED]
Subject: error: 'Can't connect to local MySQL server through socket
'/tmp/mysql.sock'
- When I execute the command mysqld_safe:
[EMAIL PROTECTED] mysql]# bin/mysqld_safe
On Tue, 28 Mar 2006, Brian Erickson wrote:
To: mysql@lists.mysql.com
From: Brian Erickson [EMAIL PROTECTED]
Subject: Customer Recommendation Query
snip
We are using MySQL version 3.23. There are approximately
500 unique rows in the 'actions' table and 2,000,000 rows
in the member_actions
On Tue, 28 Mar 2006, Jorrit Kronjee wrote:
To: mysql@lists.mysql.com
From: Jorrit Kronjee [EMAIL PROTECTED]
Subject: Re: Random 'select permission denied' since upgrade to 5.0.18
snip
Could this message appear when, for instance, a maximum amount of threads
has been spawned or MySQL has
On Tue, 28 Mar 2006, Jorrit Kronjee wrote:
To: mysql@lists.mysql.com
From: Jorrit Kronjee [EMAIL PROTECTED]
Subject: Re: Random 'select permission denied' since upgrade to 5.0.18
[EMAIL PROTECTED] wrote:
On Tue, 28 Mar 2006, Jorrit Kronjee wrote:
To: mysql@lists.mysql.com
From
functionality of the database.
So, if one starts out by designing a database (and it's
server(s)) with optimum performance and upgradability as
design goals, you won't go to far wrong.
Just my 2c.
Keith Roberts
In theory, theory and practice are the same;
in practice they are not.
--
MySQL General
Take a look at these links Charles.
http://dev.mysql.com/doc/refman/4.1/en/privilege-system.html
http://dev.mysql.com/doc/refman/4.1/en/user-account-management.html
You don't need to fully understand the mysql privilege
access system to set up users, but it would help in the long
term
On Tue, 21 Mar 2006, Áquila Chaves wrote:
[ERROR]
/usr/local/mysql/bin/mysqld: Can't create/write to file
'/var/run/mysqld/mysqld.pid' (Errcode: 13) 060321 12:12:22
[ERROR] Can't start server: can't create PID file:
Permission denied 060321 12:12:22 mysqld ended
Check the directory
From the 5.0.x manual
How to create user accounts:
The next examples create three accounts and give them access
to specific databases. Each of them has a username of custom
and password of obscure.
To create the accounts with GRANT, use the following
statements:
shell mysql --user=root
In theory, theory and practice are the same;
in practice they are not.
On Mon, 20 Mar 2006, Martijn Tonies wrote:
To: mysql@lists.mysql.com
From: Martijn Tonies [EMAIL PROTECTED]
Subject: Re: Discussion: the efficiency in using foreign keys
Hi,
This is a fundamental concept in RDBMS
IMHO I think you will find that there is a balance between
the speed of opening and reading/writing several related
smaller tables connected by FK's, rather than one mega-sized
gigantic table.
How do you normalise a table without using FK's.
Your right, MySQL does not currently do any
If you upgrade to mysql 5.0.x there are also the
The INFORMATION_SCHEMA tables that return meta information
about tables.
AFAIK they may not be available in pre 5.0 versions.
Keith
In theory, theory and practice are the same;
in practice they are not.
To unsubscribe from this list, please see
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Re: E/R Tool
Date: Mon, 13 Mar 2006 22:40:34 + (GMT)
OK TY Peter.
I have downloaded both DBDesigner and MySQL Workbench.
Looking forward to workbench reaching GA status.
Regards
Keith
In theory
this - but it looks like you are mixing sending the
mysql query and testing for the result of the query at the same time,
which AFAIK is not possible.
You should try it. It works just fine, and isn't the problem. The
problem is that you cannot treat the result of an UPDATE as if it were
.
Is the mentioned in the php manual somewhere Michael?
I've not tested this - but it looks like you are mixing
sending the
mysql query and testing for the result of the query at the
same time,
which AFAIK is not possible.
You should try it. It works just fine, and isn't
option files. If given, this option must be first.
More options are found in
/usr/local/mysql-5.0.18/man/man1/mysqld_safe.1
I found this behaviour very annoying at first. But I now use
this to my advantage.
I have split my my.cnf file like this:
/etc/my.cnf only has parameters used by mysql client
are the same;
In practice they are not.
On Mon, 13 Mar 2006, Vinay wrote:
To: mysql@lists.mysql.com
From: Vinay [EMAIL PROTECTED]
Subject: E/R Tool
Hello ,
Is there a mysql or any other tool that generates a E/R diagram using an
existing mysql database.
Thank You
Vinay
--
MySQL
wrote:
To: mysql@lists.mysql.com
From: Peter M. Groen [EMAIL PROTECTED]
Subject: Re: E/R Tool
On Monday 13 March 2006 17:37, Vinay wrote:
Hello ,
Is there a mysql or any other tool that generates a
E/R diagram using an existing mysql database.
Thank You
Vinay
Try fabforce
OK TY Peter.
I have downloaded both DBDesigner and MySQL Workbench.
Looking forward to workbench reaching GA status.
Regards
Keith
In theory, theory and practice are the same;
In practice they are not.
On Mon, 13 Mar 2006, Peter Brawley wrote:
To: [EMAIL PROTECTED]
From: Peter Brawley
In your global /etc/my.cnf fle, you should be able to split
that into sections for each client program that you want to
set specific options for.
Eg.
# /etc/my.cnf
# MySQL client program configuration file
# last updated 2006-03-05
# mysqld server configuration file lives in
# /usr/local
I get the same results as you do using this:
karsites:/usr/local/mysql-5.0.18/bin # ./my_print_defaults mysqld
karsites:/usr/local/mysql-5.0.18/bin # ./my_print_defaults client
--socket=/var/lib/mysql/mysql.sock
--port=
karsites:/usr/local/mysql-5.0.18/bin #
It seems like the last parameter
)
{
// the user id and password match,
print(User id on db);
}
else
{
//$errorMessage = 'Sorry, wrong user id / password';
print(Sorry, wrong user id / password);
}
I've not tested this - but it looks like you are mixing sending the
mysql query and testing for the result of the query
Maybe I need to read the copy of php pocket reference I have
to David - LOL.
Keith
On Sun, 12 Mar 2006 [EMAIL PROTECTED] wrote:
To: mysql@lists.mysql.com
From: [EMAIL PROTECTED]
Subject: Re: Checking for good update
looks a bit strange to me.
$result = mysql_query($query) or die
, David Blomstrom wrote:
To: mysql@lists.mysql.com
From: David Blomstrom [EMAIL PROTECTED]
Subject: MySQL Debuggers
I recently discovered that all my websites were wrecked. I spent several
hours trying to troubleshoot it, until I finally discovered that my database
was missing. I asked my
It's not on the mysql site yet Greg.
From [EMAIL PROTECTED] Sat Mar 4 23:00:04 2006
To: [EMAIL PROTECTED]
From: Alfredo Kengi Kojima [EMAIL PROTECTED]
Subject: ANNC: MySQL Workbench 1.0.5 beta released
MySQL Workbench 1.0.5 beta has been released.
MySQL Workbench is a database design tool
Mary, you need to know 100% that mysql is actually running
and what port or socket it is listening on for connections,
before you even try and connect to it.
If you call mysqld directly with a script something like:
#! /bin/sh
# start-mysql-5.0.18
#
# start the MySQL database server
/usr
(email_addr),
key last_name (last_name)
);
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, 8 Mar 2006, clint lenard wrote:
To: mysql@lists.mysql.com
From: clint lenard [EMAIL PROTECTED]
Subject: Need help with a Basic Query.
Hey Guys,
I was wondering if I could get some assistance with building a
Simple Import Script using PHP and MySQL. Basically I'm trying to pull
info
The web applications below will allow you to connect to and
monitor and administer MySQL databases.
http://www.phpmyadmin.net/home_page/index.php
Check out the DEMO link in the top menu bar, RHS.
Or there is the MySQL Administrator at:
http://www.mysql.com/products/tools/administrator
helpfull when trying to connect to the server.
I also found it very usefull to know if mysqld was actually
running.
Sometimes, I would start mysql via mysqld_safe. But I
noticed using qps that mysqld_safe was running, but it
failed to start the mysqld!
I don't bother using mysqld_safe anymore
Still a mystery about your missing InnoDB database files
Rithish.
I seem to remember there is an option that will allow you to
store InnoDB files in their own seperate directory safely,
and not in the /var/lib/mysql default directory.
One of the many things I like about MyISAM tables
I do not use Innodb tables at the moment, so all this is
pure speculation.
Is/was the server connected to a UPS when the power failure
happened?
If so, did the UPS function properly and do you have any UPS
logs to match against the mysql error log?
Things to check for would be the time
:
To: MySQL general mailing list mysql@lists.mysql.com
From: Rithish Saralaya [EMAIL PROTECTED]
Subject: RE: error 1016 : cant open ibd file even though it exists
Hello.
The tables were working perfectly fine a week back. The database was created
from a sql file generated through
First you need to make sure that you have a running mysql
server for the client mysql program to connect to. If the
server is not runing, you will obviously not be able to
connect to it.
I find the following utility very helpfull - been messsing
around with it today.
http
You will not have access to the extra functionality in MySQL
5.0 if you are connecting to it via a php4 client API, as
the php4 API does not know about the extra functionality in
MSQL 5.0.
You could try downloading and compiling Apache 2.0.55, or
2.2.0, MySQL standard linux statically linked
If you have not installed MySQL before, you must create the
MySQL grant tables:
shell scripts/mysql_install_db --user=mysql
Keith
In theory, theory and practice are the same;
In practice they are not.
On Tue, 14 Feb 2006, Ravi Kumar wrote:
To: Imran Chaudhry [EMAIL PROTECTED]
From: Ravi
If you are running MySQL on Windows, then I'm wondering
whether you are having a problem with running out of
available ports, for clients to connect to MySQL on.
This may be your problem:
From the manual, 2.3.16. MySQL on Windows Compared to MySQL
on Unix
***
MySQL for Windows has proven
. When you use GRANT and
REVOKE, this isn't necessary.
--df
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
do # my_print_defaults mysqld
--port=3306
--socket=/var/lib/mysql/mysql.sock
--skip-locking
--key_buffer=16M
--max_allowed_packet=1M
--table_cache=64
--sort_buffer_size=512K
--net_buffer_length=8K
--myisam_sort_buffer_size=8M
--server-id=1
To give you the defaults for your mysqld server
, Scott Hamm [EMAIL PROTECTED] wrote:
I've been trying to google to no avail for English dictionary (with
definitions) in any format that I can download and import into MySQL.
Do anyone know where I can find it?
There is a lot of effort that goes into creating and
maintaining all
, such as hardback or paperback.
HTH
Keith
In theory, theory and practice are the same;
In practice they are not.
On Wed, 1 Feb 2006, John Meyer wrote:
To: mysql@lists.mysql.com
From: John Meyer [EMAIL PROTECTED]
Subject: Kinda OT: Book database question
Hi, I'm trying to develop my own book database
Access Memory',
questionID = @questionID;
insert into answer set
answer_text = 'Read And Memorise',
questionID = @questionID;
/* data truncated here for brevity */
/* end of data */
and then load it into mysql from the mysql command
prompt with:
mysql \. general-quizdata.sql
This may
, and their associated pid numbers.
I was then able to stop the running apache with:
$ kill 12345, where 12345 was the process number of the
apache.
There may be a similar command under windows that will
enable you to get the PID of the mysql you want to kill.
HTH
Keith
In theory, theory and practice
Hi Philip. I'm wondering if you have mysql server version
3.23.49 still running on your machine?
If so, version 5 would not start up, as it would not
be allowed access to port 3306.
Try doing
my_print_defaults mysqld
and my_print_defaults client mysql
from a root shell and see what values
Hi Jochen.
An alternative approach could be to pull all the values out
of the database using select * from ..., and then build the
tree-structure in your application logic. Insert the
relevant values returned from mysql in the appropriate
places of the tree-structure in the app code.
Keith
into the
Postcodes table, and the associated coordinates you want to
match on.
HTH
Keith
In theory, theory and practice are the same;
In practice they are not.
On Mon, 23 Jan 2006, Shaun wrote:
To: mysql@lists.mysql.com
From: Shaun [EMAIL PROTECTED]
Subject: Postcode Search
Hi,
We have
From the MySQL 4.1 manual
12.10.1. GROUP BY (Aggregate) Functions
COUNT(expr)
Returns a count of the number of non-NULL values in the rows
retrieved by a SELECT statement.
COUNT() returns 0 if there were no matching rows.
mysql SELECT student.student_name,COUNT(*)
-FROM
the query carefully, that in fact poor
MySQL needs to query and actually sort all 400,000 records (was it not for the
account id), before it can give you your batch of 30. If MySQL does not have
enough ram allocated, may this even entail disk swapping for a NxMb table.
This is of course the case
I'm using mysql 4.1.14 rpm's on Fedora Core 4.
I've setup max_heap_table_size to allow for 500M heap tables. Currently I
use roughly 435M in heap by about 16 different tables. Some use btree,
other's use default hash.
The problem is, over time mysql looks like this in top:
PID USER PR NI VIRT
Hallo Thorsten,
Op 14 Sep 05 schreef Thorsten Moeller aan MySQL Mailinglist:
TM i am trying to load a csv file with LOAD DATA INFILE. This File
TM contains columns with decimal values with the german comma instead of
TM the dot as separator (e.g. 3.20 is 3,20). Is there an option to handle
Hallo,
I would like a single row in a table, and not more than one, to be
used as a preferred value in another application.
Is this possible, and, if yes, how?
Groetjes,
Hans.
--- GoldED+/LNX 1.1.5/050823
* Origin: The Wizard is using MBSE/Linux (2:280/1018)
--
MySQL General
Hallo Jasper,
Op 29 Aug 05 schreef Jasper Bryant-Greene aan mysql:
I would like a single row in a table, and not more than one, to be
used as a preferred value in another application.
JBG add a column 'preferred', tinyint(1) NOT NULL.
Thank you!
Groetjes,
Hans.
--- GoldED
(id_of_preferred_row);
But this method is much more elegant. I wonder why I couldn't think of it
myself...
Thank you very much!
Groetjes,
Hans.
--- GoldED+/LNX 1.1.5/050823
* Origin: The Wizard is using MBSE/Linux (2:280/1018)
--
MySQL General Mailing List
For list archives: http
Salutations!
I am relatively new to the MySQL flavor of database server
and now have run into a situation on my hosting that I
don't seem to be able to resolve.
I installed a new query using TEMPORARY tables via the
PHP 4 interface on a production database and suddenly
began receiving PHP
Hallo,
Op 30 Jun 05 schreef blackwater dev aan mysql@lists.mysql.com:
bd 1,23,345,45;
bd 34,4,444,1er;
bd Load data local infile '/httpd/htdocs/sql/loader.sql' into table
bd vehicles fields terminated by ',' enclosed by ' lines terminated by
bd ';'
I think it should be: enclosed
Hello Mike,
On 27 Jun 05, mos wrote to mySQL list:
How can I prevent duplicate entries when I fill the data base with
load data? I tried ignore, but that has no effect.
m Ignore/Replace will only work on Unique keys and I bet your key is
m not unique. If you make it unique, then Ignore
Hallo Anoop,
Op 22 Jun 05 schreef Anoop kumar V aan Jigal van Hemert [EMAIL PROTECTED],:
AkV Alternatively, you can parse the text files using application logic
AkV (java, c++, etc) and then after extracting (and cleaning) your data
AkV insert them into mysql.
I had been thinking about
` = NULL WHERE `v_amount` IS NOT NULL;
Perfect! Thank you very much.
Groetjes,
Hans.
jdh punt beekhuizen bij duinheks punt xs4all punt nl
--- GoldED+/LNX 1.1.5/040412
* Origin: The Wizard is using MBSE/Linux (2:280/1018)
--
MySQL General Mailing List
For list archives: http
* Origin: The Wizard is using MBSE/Linux (2:280/1018)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
,
Hans.
--- GoldED+/LNX 1.1.5/040412
* Origin: The Wizard is using MBSE/Linux (2:280/1018)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello Anoop,
On 22 Jun 05, Anoop kumar V wrote to All:
AkV Are u saying that u have data in a text file and you need to parse
AkV this and insert them into mysql?
That's what I Ntried to say, yes :) The main problem is the decimal comma
in the amounts.
Regards,
Hans.
jdh dot
Hallo Peter,
Op 30 May 05 schreef Peter aan [EMAIL PROTECTED]:
P http://dev.mysql.com/doc/mysql/en/load-data-local.html
P #
P If LOAD DATA LOCAL INFILE is disabled, either in the server or the
P client, a client that attempts to issue such a statement receives the
P following error
Hallo,
I'm using MySQL 4.0.23a as found in the SlackWare 10.1 distribution.
As I'm totally new to MySQL I tried tom follow the tutorial from the
manual. When I tried to fill the data base using a text file with the
command
load data local infile '~/temp' into table huisdier;
I got
ERROR 1148
INTO heartbeat_counts set received_responses=1,
device_response=12951 ;
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Hi there,
I have a problem connecting to the mysql server. I installed a new server with
mysql 4.1.9, apache2, php4 on freebsd5.3 and have some websites running on it
using the mysql server. Last friday I had a crash of one off my other servers
and I copied the websites and db's to this new
would be
disastorous! Is there any type of undo function with MySQL?
[/snip]
You'll want to read this
http://dev.mysql.com/doc/mysql/en/COMMIT.html
And try:
$ mysql --i-am-a-dummy
that makes it refuse deletes without 'where'
Good luck,
Harmen
of
open_file_limits with such statement:
show variables like '%open_f%';
You can find some recommendations for SuSe Linux at:
http://dev.mysql.com/doc/mysql/en/Linux-post-install.html
Mysql user [EMAIL PROTECTED] wrote:
Hi..
I've got an ISP, and all of our customers have databases
Hi..
I've got an ISP, and all of our customers have databases in our mysql
system.
My backup command is:
mysqldump --force --opt -A -p' | gzip -c
/var/sqlbackup/mysqldump-`date +\%A`.sql.gz
This has worked fine for some time.
Now, however, I get an error message:
mysqldump: Got
Frank,
my experience MySQL returns the the rows in the order that you inserted them
This is true, if, and only if you have never deleted a record from the table.
Like most SQL servers, MySQL leaves deleted records' space in the physical
table unoccupied, but still available. When you insert
Hi Jim,
Your advice is indeed correct for the access denied problem. For your own
problem, you might consider taking a look at max_allowed_packet variable of
MySQL, as this error is common when you are sending a large blob update and the
variable is too small for the update SQL, i.e
tablename TYPE=MYISAM;
one by one)
I see that ISAM support is in the codebase but not built by default, I
guess I would rather migrate up to a DB type that isn't considered to be
'legacy' .
--
Mark P. Hennessy
[EMAIL PROTECTED]
I have a MySQL DBMS running with a mysql DB that apparently
I have a MySQL DBMS running with a mysql DB that apparently is an InnoDB
DB, all other DBs in this DBMS are MyISAM. When I try to upgrade, I get
the following output:
041215 16:41:53 mysqld started
InnoDB: Resetting space id's in the doublewrite buffer
041215 16:41:57 InnoDB: Started; log
Mike,
The newest MySQL uses SHA1 in combo with random generated 20 byte session hash
values. The procedure is irreversible and therefore why it is not possible to
obtain the original password. MySQL is thus very secure and only vulnerable to
a bruteforce attack. You can partially secure
Hi,
How can I check all duplicated rows out from a large table?
The values are not keys so they may have more than one occurrence.
Thanks for your help.
Regards, CHAN
Chan, what about using DISTINCT in the select?
.. or am I missing something?
Kind Regards
SciBit MySQL Team
CopyPaste and DragDrop functionality for copying/backing up and
restoring databases, tables, queries, scripts and report MySQL objects. Now
includes Outlook-style Move to/Copy to dialogs.
3. Simplied folder view for all the Mascon fans.
4. Full range of data editors for every MySQL column type
Hi,
In my system my.cnf is in
/etc/ directory.
Bye.
On Fri, 10 Dec 2004 Hiu Yen Onn wrote :
hi,
i compiled mysql-4.1.7 from source. actually, i want to configure a mysql
cluster. from the documentation, i need to add some flag into a file called
my.cnf. i searched through the files
Hi,
After I installed rpm packages on my system, I am unable to connect to the
databse. I have installed in the following order
1)Server
2)Client
3)Devel
4)Shared Compat
After starting the databse with:
/etc/rc.d/init.d/mysql start
I am unable to login as:
/usr/bin/mysqladmin -u root
Hi Ady,
See your OLD_PASSWORD MySQL option in your MySQL Docs. Or the following
articles:
http://dev.mysql.com/doc/mysql/en/MySQL_4.1_Nutshell.html
http://forum.scibit.com/viewtopic.php?t=195
Kind Regards
SciBit MySQL Team
http://www.scibit.com
MySQL Products:
http://www.scibit.com/products
Hi Luciano,
Not that this reply will solve your problem, but let it serve as a notice. It
is NEVER a good idea to use a FLOAT/BLOB column in your where clause as MySQL
can not uniquely identify the record. Especially not with floats because of
the inherent floating point error made between
I need to move one database with 5 tables to another box. What files I
should copy?
I use MYSQL 3.23.58.
TH
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
201 - 300 of 684 matches
Mail list logo
