MySQL files location in RH9 Linux
Posted on 2004-10-21
I have MySQL running on my windows XP system - installed by a package called Foxserv. In windows for every mysql db there is a folder, named the same as the database name, that contains 3 files for every table - tblname.frm; tblname.MYD; tblname.MYI. To back up my database all I have to do is to save this files -> this is my testing environment.
My Live environment is a Linux Box - Red Hat 9 - running apache server with plesk. The question that I have is - do the same files exist on the Linux server and if they do:
1) where are the located
2) is it possible to download them and use them on a windows XP system.
Please bear in mind that I am a complete novice with Linux - I have just about managed to access my server with SSH and navigated around a little. Please don't start spouting off reams of linux commands as it will go completely over my head. I am willing to learn if there is some good resource to help me I would appreciate that.