?
Solved

MySQL files location in RH9 Linux

Posted on 2004-10-21
8
Medium Priority
?
303 Views
Last Modified: 2013-12-06
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.
0
Comment
Question by:ismfa
5 Comments
 
LVL 40

Accepted Solution

by:
jlevie earned 252 total points
ID: 12377315
You really don't want to be backing up the DB files unless you are willing to shutdown MySQL before the backup. There's no assurance that the DB files will reflect the current state of the DB if MySQL is running at the time of the backup. For a web server shutting down MySQL is, at the least inconvient, and will stop the site from working during the backup.

However, there are alternatives that will produce a static image of the DB contents. This subject is covered quite well at http://jeremy.zawodny.com/mysql/mysql-backup-and-recovery.html

The DB file content for a standard RH 9 MySQL will in in /var/lib/mysql.
0
 

Assisted Solution

by:clau
clau earned 248 total points
ID: 12380190
Here is a very simple way to backup mysql data:

http://www.cgi-interactive-uk.com/mysql_dump.html

It uses mysqldump to create sql statements that can be used to restore a database, in any mysql server (even on windows)
0
 
LVL 2

Expert Comment

by:ITG-SSNA
ID: 12383378
There's a much more simple and robust solution...

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

Regards,

~K Black
0
 

Expert Comment

by:clau
ID: 12383552
Isn't it a Windows program - front end to a windows mysql database?
0
 

Expert Comment

by:omphs_XXXX
ID: 12388551
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

0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Virtualization software lets you run different versions of Windows, Ubuntu Linux and other versions of Linux all at the same time, rather than running each one directly from your computer's hard drive.
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Suggested Courses
Course of the Month6 days, 17 hours left to enroll

593 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question