asked on

MySQL files location in RH9 Linux

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.

ASKER CERTIFIED SOLUTION

jlevie

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

clau

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ITG-SSNA

There's a much more simple and robust solution...

Have a look here -->
http://www.mysqlfront.de/

Regards,

~K Black

clau

Isn't it a Windows program - front end to a windows mysql database?

omphs_XXXX

there is gui tool for database back on mysql database download the mysqladministrator for microsoft windows at http://dev.mysql.com/downloads/administrator/index.html and install on
onr microsoft box.
backup file are save as .sql
you can backup you linuxr box or microsoft box using this tool and you can also manage you mysql server