Solved

MySQL files location in RH9 Linux

Posted on 2004-10-21
282 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
Question by:ismfa
    5 Comments
     
    LVL 40

    Accepted Solution

    by:
    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
    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
    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
    Isn't it a Windows program - front end to a windows mysql database?
    0
     

    Expert Comment

    by: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

    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    SSH (Secure Shell) - Tips and Tricks As you all know SSH(Secure Shell) is a network protocol, which we use to access/transfer files securely between two networked devices. SSH was actually designed as a replacement for insecure protocols that sen…
    The purpose of this article is to demonstrate how we can use conditional statements using Python.
    Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
    Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…

    856 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now