SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Hybrid View

  1. #1
    SitePoint Member
    Join Date
    Feb 2011
    Posts
    14
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    which files to back up for MySql to work properly after a crash?

    Hi,

    I'm fairly new to MySQL, but I got it to run properly on my Windows 7 machine. Im developing joomla templates and small php-snippets utilizing MySQL.

    My Question concerns the separation of the installation files and the data onto different partitions. I installed and set up MySQL on my C:\ partition and configured MySQL to store the innodb on D:\. On D:\ MySQL creates 1 file called "ibdata1". I was thinking that this was probably a closed data file which MySQL uses during operation.
    But every time I recover my Partition C:\ from a backup, I cannot reconnect to my databases. With phpMyAdmin I can see, that all my previous databases are gone even though I did not touch the D:\ibdata1 file. So there must be other files that store information or even whole databases...

    Question: Which files do I have to back up in order for MySQL to work properly after a system crash?
    And is there a way to store all these files together on a partition different from the installation partition?


    thanks
    AO

  2. #2
    SitePoint Member
    Join Date
    Feb 2011
    Posts
    14
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I think I found the solution myself:
    I copied the "data" folder from the installation path at C:\ to D:\ as well and changed the data directory path in the my.ini on line 77 accordingly.
    Will this help?

  3. #3
    SitePoint Member
    Join Date
    Jul 2012
    Location
    kolkata
    Posts
    6
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i think import ur .sql file in mysql databse and restore that .sql file whenever u necessary

  4. #4
    SitePoint Member
    Join Date
    Feb 2011
    Posts
    14
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi jeet25,

    well you are probably right.
    But that takes an extra step in my backup-routine.
    I did some thorough testing and it seems that my method does suffice for my needs...

    so long
    AO


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •