- Thank you received: 0
SecurityCheck Pro - Has both MySQL tables and MYD files - What I did
- todd.herman@toddherman.com
- Topic Author
- Offline
- New Member
-
Also note - there are a few more tables than MYD files.
See snip - pls ignore the 2 likeme MYD files at top of list.
QUESTION - is this behavior normal, or can I delete the MYD and MYI files named todj36_securitycheckpro* ?
Thanks,
Todd Herman
Please Log in or Create an account to join the conversation.
- Jose
-
- Offline
- Administrator
-
- Thank you received: 344
To be honest, I don't know anything about your question as I usually work on LAMP environments and I don't navigate to database folders. This is what Mysql's official site says about those files: dev.mysql.com/doc/internals/en/myisam-introduction.html
When you say:
CREATE TABLE Table1 ...
MySQL creates files named Table1.MYD ("MySQL Data"), Table1.MYI ("MySQL Index"), and Table1.frm ("Format"). These files will be in the directory:
/<datadir>/<database>/
For example, if you use Linux, you might find the files in the /usr/local/var/test directory (assuming your database name is test). if you use Windows, you might find the files in the \mysql\data\test\ directory.
So IMO you should not delete them.
Regards,
Jose
Please Log in or Create an account to join the conversation.
- todd.herman@toddherman.com
- Topic Author
- Offline
- New Member
-
- Thank you received: 0
Here's what I did - and before I did either, I used VMware to take a snapshot of my Joomla VM.
First, I downed IIS, deleted the MYD and MYI files, and then restarted IIS - result was site that would not start, so rolled back to VMware snapshot.
Second, I uninstalled SecurityCheck Pro, downed IIS, deleted any remaining tables in InnoDB, deleted the MYD/MYI/FRM files from the server's drive, restarted IIS, and reinstalled SecurityCheck Pro. This time, there were ONLY tables in InnoDB and NO MYD/MYI/FRM files, and that was my goal - to get rid of all the ISAM stuff and have everything inside the InnoDB.
Thanks for your help!
Best, Todd
Please Log in or Create an account to join the conversation.
- Jose
-
- Offline
- Administrator
-
- Thank you received: 344
Thank you very much for sharing your solution here.
Regards,
Jose
Please Log in or Create an account to join the conversation.
In order to provide you with the best online experience this website uses cookies.
By using our website, you agree to our use of cookies.
This site is not affiliated with or endorsed by the Joomla! Project. It is not supported or warranted by the Joomla! Project or Open Source Matters. The Joomla! logo is used under a limited license granted by Open Source Matters, the trademark holder in the United States and other countries.
We may collect your IP address and your browser's User Agent string while using our site for security reasons. This information is retained only until we check you're not trying to hack our website.