Re: Correct way to start new .MYD & .MYI files
TRUNCATE? http://dev.mysql.com/doc/refman/5.0/en/truncate.html DELETE? http://dev.mysql.com/doc/refman/5.0/en/delete.html eugene - Eugene Mah, M.Sc., DABR euge...@ix.netcom.com Medical Physicist/Misplaced Canuckmah...@musc.edu Department of Radiology eugene...@gmail.com Medical University of South Carolina "For I am a Bear of Very Little Charleston, South Carolina Brain, and long words Bother http://www.netcom.com/~eugenem/me." Winnie the Pooh http://blog.imabug.net/ PGP KeyID = 0x1F9779FD, 0x319393F4 PGP keys available on request ICQ 3113529 O- - On 09/25/2009 04:04 PM, Michael Dykman wrote: Alas, none that I am aware of, but if you can successfully run 'SHOW CREATE TABLE `ApplicationLog`' before you drop the table, it will give you the DDL you need to recreate that table *exactly*. - michael On Fri, Sep 25, 2009 at 3:47 PM, Jones, Keven wrote: I don't want to lose the table structure just wish to get rid of the old data in the .MYD and .MYI files. If I drop the table I will need to recreate the table with the existing structure. So is there a way to just clear out the ApplicationLog.MYD and ApplicationLog.MYI files? Thx again -Original Message- From: Michael Dykman [mailto:mdyk...@gmail.com] Sent: Friday, September 25, 2009 3:42 PM To: Jones, Keven Subject: Re: Correct way to start new .MYD& .MYI files If you are prepared to accept that any data associated with those tables is *LOST*, it's pretty simple. First try, the nice way. USE; DROP TABLE ApplicationLog; If this fails, complains about curruption, whatever, go to the next step safely: shutdown mysql (os-specific), then go ahead and delete those files. Startup will happen normally and those tables will be gone. Caution: you *might* be running an application that is expecting to use those tables... now that they are gone, that application might begin to fail. Be prepared to create a new empty table with that name having the same structure,... if you really don't want the data but are only doing it to make your app happy, consider the black-hole database engine. - michael dykman On Fri, Sep 25, 2009 at 3:33 PM, Jones, Keven wrote: Hello, I am new to MySQL.I have a disk space issue and I have found that 3 files are the cause. The files are ApplicationLog.MYD and ApplicationLog.MYI I would like to purge these files and basically get rid of the data that is in them. What is the proper Way to accomplish this? Does anyone have a procedure to follow that will allow me to archive these files and Then start new ones so I can get my disk space back? Thanks in advance. -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: about the username and hostname
Check the properties of your shortcut to see what user name is specified in the command options Eugene Weiqi Wang wrote: > Dear everyone: > > I start mySQL by a shotcut in windowsXP so that I don't have to input my > username, just password is required. That brings in a problem: I don't know > my user name(I suppose it to be "root") and the server host, etc. Is there > anyway I can find it out? (I suppose the server host is the localhost but I'm > not sure) > > Thanks very much for any help! > -- --------- Eugene Mah, M.Sc., DABR [EMAIL PROTECTED] Medical Physicist/Misplaced Canuck[EMAIL PROTECTED] Department of Radiology [EMAIL PROTECTED] Medical University of South Carolina "For I am a Bear of Very Little Charleston, South Carolina Brain, and long words Bother http://www.netcom.com/~eugenem/me." Winnie the Pooh http://radinfo.musc.edu/~eugenem/blog/ PGP KeyID = 0x1F9779FD, 0x319393F4 PGP keys available on request ICQ 3113529 O- - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [inbox] Re: Breaking Up Tables
[EMAIL PROTECTED] wrote: -Original Message- From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thu, 1 Mar 2007 10:00 AM Subject: Re: Breaking Up Tables It's nothing to do with mysqldump - it's part of the SELECT syntax for regular queries. Then I'm confused as to what you're suggesting I do. I need to create mysqldump files of *parts* of a table in a database, because the entire table is just too big to move under the current circumstances. So, the end result should be a bunch of little mysqldump files that are each a part of this table in this database. Then I need to be able to rebuild the table by inserting the parts. Can you suggest a way to do that? TIA, Tony if you have shell access on the server, why not just use split? Create your big dump file, split it into smaller chunks and use cat on the other end to reassemble the pieces. if you don't, just have someone at your host provider who does do it. Eugene -- --------- Eugene Mah, M.Sc., DABR [EMAIL PROTECTED] Medical Physicist/Misplaced Canuck[EMAIL PROTECTED] Department of Radiology [EMAIL PROTECTED] Medical University of South Carolina "For I am a Bear of Very Little Charleston, South Carolina Brain, and long words Bother http://www.netcom.com/~eugenem/me." Winnie the Pooh http://radinfo.musc.edu/~eugenem/blog/ PGP KeyID = 0x1F9779FD, 0x319393F4 PGP keys available on request ICQ 3113529 O- - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL to Excel ?
At 08:01 01-05-02 -0500, Jay Blanchard wrote: >Howdy, > >I need to write some data out to Excel spreadsheets for some of our managers >to muddle with for projections. The query works fine... If you're into Perl, I believe there are at least a couple of modules that will write out data into Excel files. Otherwise I would go the ODBC route and make Excel connect to the DB via macros or VBA. Eugene -- --------- Eugene Mah, M.Sc., DABR [EMAIL PROTECTED] Medical Physicist/Misplaced Canuck[EMAIL PROTECTED] Department of Radiology "For I am a Bear of Very Little Medical University of South Carolina Brain, and long words Bother Charleston, South Carolina me." Winnie the Pooh http://home.netcom.com/~eugenem/ PGP KeyID = 0x1F9779FD, 0x319393F4 PGP keys available on request ICQ 3113529 O- - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Difficulties between OS versions
At 07:55 10-04-02 -0500, Lee, Tom J wrote: >When we tried >to install the same software on a SUN Sparc 20 running Solaris 2.6 errors >were encountered. Something about a missing file 'librt.so.1'. We thought >the OS version was 2.7. Not correct! I downloaded the binary MySQL version >3.22.32 from the archive area on the website and it installed. However, the >same 4 tables that are working under Solaris 2.8 are presenting errors under >Solaris 2.6. The error message states that there is no field information >available for any of the 4 tables. Am I doing something wrong. If I'm not mistaken, binaries are only available for Solaris 2.7 and up. If you want to run on Solaris 2.6, you'll need to compile from the sources. I've gone through several versions running on a Sparc 20 under Solaris 2.6 without any issues or problems building. Eugene -- --------- Eugene Mah, M.Sc., DABR [EMAIL PROTECTED] Medical Physicist/Misplaced Canuck[EMAIL PROTECTED] Department of Radiology "For I am a Bear of Very Little Medical University of South Carolina Brain, and long words Bother Charleston, South Carolina me." Winnie the Pooh http://home.netcom.com/~eugenem/ PGP KeyID = 0x1F9779FD, 0x319393F4 PGP keys available on request ICQ 3113529 O- - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL unix vs WinXP case sensitivity
I seem to be having issues with the way MySQL names the table files under Unix and WinXP. I'm not sure if it's a mysql issue or a windows issue. Normally, when I create tables in MySQL, I like to capitalize the first letter. Under unix, it all works fine and dandy. But under WinXP, the table name gets converted to all lowercase, which consequently messes up my php files when I try to go back and forth between unix and windows. I suppose I could switch to all lower case, but old habits die hard and I sometimes forget when I'm typing away some PHP code. The MySQL I installed is from the download page at mysql.com. anybody else run into this issue? Eugene -- --------- Eugene Mah, M.Sc., DABR [EMAIL PROTECTED] Medical Physicist/Misplaced Canuck[EMAIL PROTECTED] Department of Radiology "For I am a Bear of Very Little Medical University of South Carolina Brain, and long words Bother Charleston, South Carolina me." Winnie the Pooh http://home.netcom.com/~eugenem/ PGP KeyID = 0x1F9779FD, 0x319393F4 PGP keys available on request ICQ 3113529 O- - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 127.0.0.1 problem
I would check the grant tables to see if host 127.0.0.1 has permission to access the DB. Even though they are the same thing, I don't know if mysqld treats them as the same thing. Eugene At 03:15 AM 11/09/2001 -0800, you wrote: >Hello, > >Are there any obvious reasons why > >mysql -h localhost >works and >mysql -h 127.0.0.1 >does not. > >It says : ERROR 2003: Can't connect to MySQL server on '127.0.0.1' >(110) > > >/etc/hosts contain : >127.0.0.1 localhost > >as a first line. > > -- To put my contact info into your Palm device, click here: http://signature.coola.com/?[EMAIL PROTECTED] Personal Signature Coolet ----- Eugene Mah, M.Sc., DABR [EMAIL PROTECTED] Medical Physicist/Misplaced Canuck[EMAIL PROTECTED] Department of Radiology "For I am a Bear of Very Little Medical University of South Carolina Brain, and long words Bother Charleston, South Carolina me." Winnie the Pooh http://home.netcom.com/~eugenem/ PGP KeyID = 0x1F9779FD, 0x319393F4 PGP keys available on request ICQ 3113529 O- - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
database documentation
What tools do people use to document their databases? Are there graphical tools that will generate relational diagrams of a database (like in Access)? One of the databases I've been developing is starting to grow as I add additional tables to hold different pieces of data. At the moment, my documentation comes from adding comments and CREATE statements to the result of an earlier mysqldump file. Back when I only had 7 or 8 tables, this was fine, but now my database is starting to approach 25 tables, so some of the relationships are starting to get a little hard to keep track of. Many thanks Eugene -- To put my contact info into your Palm device, click here: http://signature.coola.com/?[EMAIL PROTECTED] Personal Signature Coolet - Eugene Mah, M.Sc., DABR [EMAIL PROTECTED] Medical Physicist/Misplaced Canuck[EMAIL PROTECTED] Department of Radiology "For I am a Bear of Very Little Medical University of South Carolina Brain, and long words Bother Charleston, South Carolina me." Winnie the Pooh http://home.netcom.com/~eugenem/ PGP KeyID = 0x1F9779FD, 0x319393F4 PGP keys available on request ICQ 3113529 O- - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Sending data from Excel to MySQL
I was wondering if someone could direct me to some resources where I could teach myself how to export data from Excel to a MySQL database. I have a number of spreadsheets I use for data collection, and have recently set up a MySQL database to stash the data in. I've managed to figure out how to copy/paste blocks of data into an HTML form and have PHP stick the data into the database. I'm looking for a way I can do it from within Excel now, since there are more blocks of data I need to store which are scattered throughout the spreadsheet. I'd like to automate the process a little more and go beyond the copy/paste thing. I've looked at MyODBC a little bit, but not enough to see how I can use it for this task (one of the things on my to do list). I expect I'll end up learning some VB for doing this. Many Thanks Eugene -- To put my contact info into your Palm device, click here: http://signature.coola.com/?[EMAIL PROTECTED] Personal Signature Coolet --------- Eugene Mah, M.Sc., DABR [EMAIL PROTECTED] Medical Physicist/Misplaced Canuck[EMAIL PROTECTED] Department of Radiology "For I am a Bear of Very Little Medical University of South Carolina Brain, and long words Bother Charleston, South Carolina me." Winnie the Pooh http://home.netcom.com/~eugenem/ PGP KeyID = 0x1F9779FD, 0x319393F4 PGP keys available on request ICQ 3113529 O- - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php