473,395 Members | 2,222 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

R: myisamchk -R

Thnks a lot

Patrizio

-----Messaggio originale-----
Da: Egor Egorov [mailto:eg*********@ensita.net]=20
Inviato: luned=EC 21 luglio 2003 14.02
A: my***@lists.mysql.com
Oggetto: Re: myisamchk -R

"PaT!" <pa******@tiberconnect.it> wrote:
=20
I need a hint how to use myisamchk
=20
I use this syntax in a shell but it doesn't work=20
=20
myisamchk -R=3DID \mysql\data\db\mytable.myi
=20
ID is the index name I want to use to sort the table
=20
I'm using mysql 4.0.13 on Win 2K server


myisamchk -Rindex_number /path/to/the/index/file/table_name.MYI

Index number you can see using SHOW INDEX command. For example:

myisamchk -R1 /var/lib/mysql/mydatabase/table1.MYI

--=20
For technical support contracts, goto
https://order.mysql.com/?ref=3Densita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ Eg*********@ensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com


--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=3...iberconnect.it

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 1736

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: PaT! | last post by:
------=_NextPart_000_00E2_01C34DE9.4541BA40 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Hi, I need a hint how to use myisamchk I use this syntax in a...
0
by: Jeff McKeon | last post by:
Hello, When I run a script to issue myismchk against the tables in my database, I get the following.. # ./check_mysql_tables myisamchk: MyISAM file /var/lib/mysql/telaurus/Admin.MYI...
0
by: Paul Mahon | last post by:
Hello, I recently managed to corrupt a table pretty badly. I read the sections in the documentation about recovering after a crash. None of the methods worked. All give output similar to the...
0
by: Stephen Crowley | last post by:
Are there any known issues with table corrouption on 4.0.14-standard-log? I'm getting recurring problems with a single table becoming corrupted, does mysql handle disk full problems gracefully or...
0
by: Luc Foisy | last post by:
Last week many of our server and client servers had a power problem. Not = quite sure how the servers were handled, wasn't on site, but I don't = think some of these servers got shut down...
0
by: Luc Foisy | last post by:
Would anything happen to the database if I ran "myisamchk --silent = /usr/data/mysql/*/*.MYI" when I havent run "FLUSH TABLES" first? As it states in the documentation: If mysqld is running, you...
0
by: nospam | last post by:
I have a ~ 38 GB table (MyISAM) and am using myisamchk -r to recover it. Its been running for several days now (Win2k). When I go to check it, it seems to have slowed down (sometimes hangs...
0
by: AJ | last post by:
I'm about to compress a number of tables using myisampack utility. The admin guide recommends running the following command after doing so: myisamchk -rq --sort-index --analyze tbl_name.MYI I...
12
by: grace | last post by:
i am wondering why my database retrieval becomes too slow...we set up a new server (ubuntu, breezy badger) machine where we transferred all our files from the old server.. Our new server uses Asus...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.