query
takes 0.2 seconds and uses a different method of returning results from the
original query in 1)
6) restart mysql
7) execute query
takes 2 minutes
Here's the SQL I used to produce the behaviour:
mysql> select phantom_products.id FROM phantom_products LEFT OUTER JOIN
phantom_l
to the title attribute on the dev machine, my query was
reduced from 2 minutes to virtually instantaneous (since the query is sorted
by title). But when executing the query on the production machine, the
query doesn't use the indexed title attribute. Here's what explain says:
DEV MACHI
On 1/24/08, Chris <[EMAIL PROTECTED]> wrote:
>
> mysql mysql wrote:
> > Thanks for the response Chris, although I can't seem to reproduce the
> > problem now, but I'm sure you're right.
> >
> > There's something else strange that I've e
Hi,
I have a file which has Creation of tables and views.
How can I run the file in mysql prompt.
-mysql
__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
--
MySQL General Mailing List
For list archives: http
Hi,
I am new to mysql. I have installed, created a database and also some created tables.
Now any one who can login to the host are able to drop the table or also the database.
How do I protect it?
-mysql
-
Do you Yahoo!?
New Yahoo! Photos - easier uploading
Hi All,
I have newly installed mysql 3.23.54 in Red Hat 9 (The one which was bundled with the
OS). And default the data storage file location went to /var/lib/mysql, how do I
change the location to /mysql, I have also tried modifying my.cnf it didn't help.
Any suggestion.
-
Just installed mssql and in the end of the installation I receive the
message taht now is the time to change root password for the db using
mysqladmin using the following synthax:
/usr/bin/mysqladmin -u root -p password 'new password'
So issued the following command:
/usr/bin/mysqladmin -u root -p
ion using the mysqladmin
processlist statement. If you have the SUPER privilege, you
can see all threads. Otherwise, you can see only your own
threads (that is, threads associated with the MySQL account
that you are using). See Section 13.5.5.3, KILL Syntax. If
you do not use the FULL keyword, o
(x86, glibc-2.2, "standard" is static, gcc)
Standard5.0.20 30.3M Pick a mirror
MD5: 5b0471380db88b03267bbabde500b7e0 | Signature
For each server you want to run, install a copy of the above
distribution into a seperate base directory.
eg.
/usr/local/mysql-5.0.20-srv1
On Sat, 15 Apr 2006, Mohammed Abdul Azeem wrote:
> To: [EMAIL PROTECTED]
> From: Mohammed Abdul Azeem <[EMAIL PROTECTED]>
> Subject: Re: ~ How to install 3 instances of mysql~
>
> Hello Keith,
>
> Thank you very much for your guidence.
>
> This is my exi
.
Does shell:/ # rpm -qv mysql return anything at all on your
system?
If your system uses RPM, you should get something like this
for the installed packages.
karsites:/ # rpm -qv mysql
mysql-3.23.x.rpm
karsites:/ #
Keith
In theory, theory and practice are the same;
in practice they are not.
On
it keeps doubling the tax and the credit amounts and results look like
this
1 | Delta Hotel | 100.00 | 34.00 | 234.00
is there a way to execute this query without this happening?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Well I have wondered about this as well.
I guess you could do this, but if you want the MySQL
databases to be updateable, then as the CD-ROM is read-only,
the databases would have to remain somewhere on the hard
drive. If you put the databases on the CD-ROM this would
make them read-only and
ing the mysqladmin
processlist statement. If you have the SUPER privilege, you
can see all threads. Otherwise, you can see only your own
threads (that is, threads associated with the MySQL account
that you are using). See Section 13.5.5.3, KILL Syntax. If
you do not use the FULL keyword, only
h.
> >
> > may be of interest too:
> >
> > 13.5.4.16. SHOW PROCESSLIST Syntax
> >
> > SHOW [FULL] PROCESSLIST
> >
> > SHOW PROCESSLIST shows you which threads are running. You
> > can also get this information using the mysqladmin
> >
Using MySQL 5.0.18
mysql> use test1;
Database changed
mysql> show tables;
+-+
| Tables_in_test1 |
+-+
| t1 |
+-+
1 row in set (0.00 sec)
mysql> show create table t1 \G
* 1. row *
Table:
TECTED]>
> Subject: [SPAM] Re: describe table : improvement
>
> COLUMN COMMENTs are not the same as TABLE COMMENT...
>
> For TABLE COMMENT you should use:
>
> SHOW TABLE STATUS LIKE 'table_name'
>
> *Gilles *(the starter of the thread) wanted COLUMN CO
heory and practice are the same;
in practice they are not.
On Fri, 21 Apr 2006, Nicolas Verhaeghe wrote:
> To: 'Mike Blezien' <[EMAIL PROTECTED]>,
> 'MySQL List'
> From: Nicolas Verhaeghe <[EMAIL PROTECTED]>
> Subject: RE: Older version MySQL
>
nition, as documented in the manual
> <http://dev.mysql.com/doc/refman/5.0/en/create-table.html>.
>
> column_definition:
> col_name type [NOT NULL | NULL] [DEFAULT default_value]
> [AUTO_INCREMENT] [UNIQUE [KEY] | [PRIMARY] KEY]
> [COMMENT 'string'] [reference
AST_INSERT_ID() in a
statement that updates a table. Setting this variable does
not update the value returned by the mysql_insert_id() C API
function.
Eg.
mysql> select @@last_insert_id;
+--+
| @@last_insert_id |
+--+
|0 |
+
Hi Luis.
It sounds like your script may not be initialising those
two variables correctly.
Are the variables being set properly in your script before
sending the insert query to mysql?
MySQL will quite happily insert an empty string value, ''
into a char field without generatin
not.
On Tue, 2 May 2006, Rob Munsch wrote:
> To: forum mysql
> From: Rob Munsch <[EMAIL PROTECTED]>
> Subject: Re: Have You Seen My CV?
>
> Anago Chima wrote:
>
> > Tired of spam? Yahoo! Mail has the best spam protection around
> >
> >
> Oh
different versions of the .tar.gz
distro's on one machine, and run each mysql server on the
same machine for testing your upgrades, by using a different
port, socket pid-file and database (even a snapshot of your
live data for testing purposes that you can throw away later).
Each mysql version
>On Thu, 4 May 2006, Shivaji S wrote:
>
> To: [EMAIL PROTECTED], mysql@lists.mysql.com
> From: Shivaji S <[EMAIL PROTECTED]>
> Subject: Re: Mysql on Production Servers
>
>
> Keith Roberts thanks for the input ,i have few doubts on your reply.
>
> 1.when i am
This is right off the top of my head so I might be wrong!
Does myisamchk not return the mysql version that the table
was created with, if you use a very verbose option to check
the *.MYI files?
You could make a copy of your tables and experiment with
myisamchk on the copies, see if that
live
database itself.
Do you have the show create table xyz /G output for the tables
you want to alter please?
Regards
Keith Roberts
In theory, theory and practice are the same;
in practice they are not.
On Tue, 9 May 2006 [EMAIL PROTECTED] wrote:
> To: mysql@lists.mysql.com
> From:
I am stumped by a table lock issue. First, some details.
I am running MySQL 5.0.22 on an AMD 64 machine.
mysqld -V outputs:
/usr/local/libexec/mysqld Ver 5.0.22-debug-log for unknown-linux-gnu
on x86_64 (Source distribution)
uname -a:
2.6.8-11-amd64-generic #1 Wed Jun 1 00:42:47 CEST 2005
change to do that, and i still need to be
able to select distinct rows when making a join.
Why does it no longer work?
Thanks.
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.10.9/416 - Release Date: 8/10/2006
--
MySQL General
-Original Message-
From: Jesse [mailto:[EMAIL PROTECTED]
Sent: 30 August 2006 11:55 PM
To: MySQL List
Subject: Mass E-mail Options
-- SNIP
http://www.mailenable.com
If SMTP is all you really want and win32 is your base, then it is freeware
and a rock solid option. Actually you will
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 receivin
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
&
>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(*)
->
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 v
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
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 are
;
> > I'd like to know too if posible :)
> >
> > On 01/02/06, 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.
&
ibutes, 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
>
> H
();
insert into answer set
answer_text = 'Random Access Memory',
status = 'right',
questionID = @questionID;
insert into answer set
answer_text = 'Read Access Memory',
questionID = @questionID;
insert into answer set
answer_text = 'Read And M
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.
It
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 ha
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
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
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
:
> To: MySQL general mailing list
> 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
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 the
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 is that
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
t too
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_sa
ail_addr, last_name)
> );
primary key login_id (login_id),
key email_addr (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
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
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 databa
// process a valid result
$row = mysql_fetch_array($res)
if (mysql_num_rows($res) == 1)
{
// the user id and password match,
print("User id on db");
}
else
{
//$errorMessage = 'Sorry, wrong user id / password';
print("Sorry, wrong user id / password");
}
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.
>
> > $
2006, 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
he OR operator outside an if
statement.
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.
&
t;
> > > Why? There's nothing wrong with the above statement.
> >
> > I've never seen logic like that before. It looks to me like fbsd_user
> > is trying to use the OR operator outside an if statement.
> >
> > Is the mentioned in the php manual so
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
ce 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
&
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 existin
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:
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
ubject: Re: E/R Tool
>
> 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 MySQ
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
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 curren
le.
Keith
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,
>
&g
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
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
>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
theory, theory and practice are the same;
in practice they are not.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 "m
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' tab
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
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, Jorri
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...
>
first 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.mysq
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 modif
ith
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 D
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 updating
To: mysql
> 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 e
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 t
Use SELECT DATEDIFF('new_date', 'old_date');
mysql> SELECT DATEDIFF('2006-04-01','2006-04-01');
+-+
| DATEDIFF('2006-04-01','2006-04-01') |
+-
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 ins
ndering 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.
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
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 upda
t; >
>
> Keith,
> Your method won't guarantee that there are no rows where the combination
> of the values in those four columns fails to repeat in any other row. To
> do that would require an EXTRA four-column unique index of type UNIQUE.
> Your proposal would actua
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 reco
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 sho
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
t copy MYD & FRM file * MYI files 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 ter
inserting, updating,
or deleting on them. The downside is that no thread can
update a READ-locked table (including the one holding the
lock) and no thread can access a WRITE-locked table other
than the one holding the lock.
The reason some MyISAM operations are faster under LOCK
TABLES is that MySQL
Hi Mark.
On Fri, 7 Apr 2006, Mark Sargent wrote:
> To: mysql@lists.mysql.com
> From: Mark Sargent <[EMAIL PROTECTED]>
> Subject: Syntax Error
>
> Hi All,
>
> am trying to get up to speed on cli syntax again,
>
> mysql> show open tables from osc
> ->
ld work ok.
The RPM version is the easiest to install, but IMO using the
non-RPM version will give you the most flexibility if you
want to upgrade to a later version of mysql. I guess you
could try and install the RPM version first, and then try
the non-RPM version later on if you want to upgrade
from the mysql 5.0.18 manual
section 13.1.5. CREATE TABLE Syntax
If a PRIMARY KEY or UNIQUE index consists of only one column
that has an integer type, you can also refer to the column
as _rowid in SELECT statements.
Regards
Keith
In theory, theory and practice are the same;
in practice
Hi Jim - see this for your answers.
1.4.4. How Large MySQL Tables Can Be
http://dev.mysql.com/doc/refman/5.0/en/table-size.html
Regards
Keith
In theory, theory and practice are the same;
in practice they are not.
On Tue, 11 Apr 2006, Jim wrote:
> To: mysql@lists.mysql.com
> Fro
1 - 100 of 711 matches
Mail list logo
