Recently, I got the following error. I found the solution to solve
the problem by increasing the log file size. However, I want to know
why this error will happen. I can't find the explanation for that
error. Anyone can give me some information about the error?
070321 16:38:41 InnoDB:
Hello All,
I have a MYISAM table (employment_summary) with over 6 Lac records. I use it
to do fast keyword searches on employments and want to retrieve the results
grouped by the executive. The executive table is also a huge INNODB table
and has over 6 Lac records. If I do any join operations
hi
when i try and do a mysqldump of the databases it exites with this error
[EMAIL PROTECTED] diaendomet]# mysqldump -ucojjohealth -p --all-databases
alldatabases.sql
Enter password:
mysqldump: Got error: 29: File '../diaendomet/users.MYD' not found
(Errcode: 2) when using LOCK TABLES
so i ran
NOW() returns the current time, as known by the Linux server, in the
time_zone set for the connection. By default, this seems to be system,
meaning whatever time zone the server picked up from the system at the time
it was started. In Linux, this would be the environment variable TZ. If you
change
Assuming you have a database, let's call it DAT1 which contain all MyISAM
tables,
you could make a copy of an entire database to DAT2
On host2 create DAT2 using
CREATE DATABASE DAT2;
Then copy all data from DAT1 to DAT2 like this.
mysqldump -hhost2 -u... -p... --triggers --routines DAT1 |
Thank you.
I have made some tests, and I have inserted 1 records in a MyISAM table,
in a InnoDB table, and in an InnoDB table using a transaction.
I have seen that the insert in an InnoDB table without using a transaction
takes much much more than in a MyISAM table.
I knew that it will
- Stop you mysql server
- change working directory to $MYSQL_DATA_DIR
- run myisamchck with */*.MYD
This will run a check on all your table files
-Original Message-
From: Gregory Machin [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 22, 2007 8:41 AM
To: mysql@lists.mysql.com
Is there some quick way to do the following in MySQL? (I know I can
use PHP to search through the result set, but I wanted to see if
there's a quick way using some sort of query)
Let's say I know that Joe is from Maine.
I want to do a query of all employees from Maine, ordered by hiring
it gives
the following errors for all the databases ..
myisamchk: error: './diaendomet/users.MYD' is not a MyISAM-table
myisamchk: error: './diaendomet/users.MYD' is not a MyISAM-table
phpmyadmin reports the tables as being MyISAM..
any sugetions
On 3/22/07, Jean-Sebastien Pilon [EMAIL
I want to do a query of all employees from Maine, ordered by hiring date,
and figure out where Joe falls in that list. (i.e. which record number
is he?)
If 'Joe' is a unique name LOL...
SELECT 1 + COUNT(*)
FROM employees
WHERE name 'Joe' AND state = 'MA' AND hiredate datevalue;
PB
James
This may sound a little cheesy, but hear me out.
Create a temp table in memory holding the result of the your employee query
like this:
CREATE TEMPORARY TABLE tmpEmpFromState
(
EMPNAME VARCHAR(60),
HIRED DATE,
ID INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY (ID),
KEY OrderOfHire(HIRED,ID)
)
Remember
ME is Maine
MA is Massachusettes
- Original Message -
From: Peter Brawley [EMAIL PROTECTED]
To: James Tu [EMAIL PROTECTED]
Cc: MySQL List mysql@lists.mysql.com
Sent: Thursday, March 22, 2007 12:32:41 PM (GMT-0500) Auto-Detected
Subject: Re: Finding a record in a result set
I
I don't think that will work. If there are 1,000 records that qualify but
none for Joe, then it will return 1,001. If Joe is in record 1 of the
retrieved record set, and there are 999 other people who match the WHERE
clause, then it will retrieve 1,000.
Am I missing something?
Regards,
Jerry
Sorry it is */*.MYI instead of */*.MYD
-Original Message-
From: Gregory Machin [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 22, 2007 12:02 PM
To: Jean-Sebastien Pilon
Cc: mysql@lists.mysql.com
Subject: Re: database corruption ? how to fix ?
it gives
the following errors for
Thank you for everyone's suggestions.
I did run the flush privileges after creating the user too.
I recently added an iSCSI network drive to my system and copied the
databases on the network drive. I mounted the network drive in the same
place that the mysql databases previously were
On Thursday 22 March 2007 18:14, [EMAIL PROTECTED] wrote:
To confirm that you would like
[EMAIL PROTECTED]
removed from the mysql mailing list, please click on
the following link:
http://lists.mysql.com/u/mysql/4602b972c92bc308/julius.junghans=gmx.de
This confirmation serves two
Hello.
I know that when a timestamp field has default current_timestamp on update
current_timestamp, it will be updated for each update. Question: I have a
slave server which replicate this field (The master is deployed Europe and the
slave in Brazil). The time of fly to replicate the query
Greetings Brent;
Many thanks for your input. I decided that I would indeed create the table
from scratch, making certain to apply the 'proper' settings, and then
reload all of the data. This completed yesterday, with the following
results:
Row_format: Dynamic
Rows: 18866709
The path myisamchk is reporting do look a bit funny...is this you
own users table or the mysql users table?
You might want to check you my.cnf file to see if different data
directories have been specified under the various tools headings.
- michael
On 3/22/07, Jean-Sebastien Pilon [EMAIL
Addendum;
On Thu, 22 Mar 2007, JP Hindin wrote:
Zero improvement. I used the following CREATE:
MAX_ROWS=10;
At first I thought I had spotted the obvious in the above - the MAX_ROWS I
used is smaller than the Max_data_length that resulted, presumably MySQL
being smarter than I
I have, after further googling, discovered that the 4.2 billion figure
that MySQL uses as 'max_rows' is, indeed, max_rows and not a max database
size in bytes. In theory I have solved my problem, and wasted however many
peoples bandwidth by putting all these eMails to the MySQL list.
Mea culpa,
This table size is based on your filesystem limits. This is a limit of
the OS, not MySQL.
-Micah
On 03/22/2007 01:02 PM, JP Hindin wrote:
Addendum;
On Thu, 22 Mar 2007, JP Hindin wrote:
Zero improvement. I used the following CREATE:
MAX_ROWS=10;
At first I thought
Micah;
In the first eMail I mentioned that I had excluded filesystem size limits
by manually producing a 14GB tar file. If it was only that simple :)
On Thu, 22 Mar 2007, Micah Stevens wrote:
This table size is based on your filesystem limits. This is a limit of
the OS, not MySQL.
-Micah
Oh, I didn't see the first comment. My mistake. It's likely a 32bit
integer size limit of some sort then. 32bit = 4gbytes
-Micah
On 03/22/2007 02:08 PM, JP Hindin wrote:
Micah;
In the first eMail I mentioned that I had excluded filesystem size limits
by manually producing a 14GB tar file. If
You can try changing the myisam_data_pointer_size setting, but the
max_rows/avg_row_length should have worked.
Unless it's your OS restricting the mysql user to a 4GB file size. You can use ulimit or getrlimit to determine OS limits for a
user. If a user hits a limit imposed by the OS, I think
You wrote, Actually the way to do this would be as follows:
When you have created a new database, click on the SQL tab and the use
the following to create the user and password:
GRANT ALL PRIVILEGES ON databasename.* TO [EMAIL PROTECTED] IDENTIFIED
BY 'password'
Hit the submit button and you
When I run the following query:
SELECT RIGHT(CONCAT('000',RoomNo),3),LastName,FirstName
FROM ConfHotelDet
WHERE ChapterID=358 AND RoomNo IS NOT NULL
ORDER BY RIGHT(CONCAT('000',RoomNo),3), LastName, FirstName
I get the following result:
001AndersonKayla
002BartonGreg
003
make an alias for the field you want as sort key and use that. you
don't need to do the calculation twice. I would not be surprised if
the sort started to behave.
SELECT RIGHT(CONCAT('000',RoomNo),3) AS theroom,LastName,FirstName
FROM ConfHotelDet
WHERE ChapterID=358 AND RoomNo IS NOT NULL
28 matches
Mail list logo