jrapin Posted January 19, 2007 Share Posted January 19, 2007 Hello.I'm trying to remove a corrupt file from our MySQL data base using the myadmin (rather than the command line client).Question is; "How do I remove the file when I find it?" I have the "drop option" at the top tab along with:export, structure, browse, SQL, search, insert, export, operations and empty.Please help.jrapin Quote Link to comment Share on other sites More sharing options...
SharkBait Posted January 19, 2007 Share Posted January 19, 2007 What do you mean a corrupt file? Do you mean a corrupt database entry? as in a line item in a table is corrupt?Drop is a way of getting rid of a table, Empty allows you to delete the contents while keeping the structure. Quote Link to comment Share on other sites More sharing options...
jrapin Posted January 19, 2007 Author Share Posted January 19, 2007 Correct, the file contains html code and keeps pritning the last line of text twice and displays a small graphic at distorted proportions.I prefer drop. Quote Link to comment Share on other sites More sharing options...
micmania1 Posted January 19, 2007 Share Posted January 19, 2007 Find the row that is corrupt and click the little red cross on tht line and it is gone.You may want to take more safety measueres to deal with html entered into forms.when dealing with your form, use the htmlspecialchars() function.http://www.php.net/manual/en/function.htmlspecialchars.php Quote Link to comment Share on other sites More sharing options...
Jessica Posted January 19, 2007 Share Posted January 19, 2007 You only want to delete one row, not the whole table. You're using PHP MyAdmin? Find the row and click the X like micmania said. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.