backup w/ rsync or by copying mysql folder

  • guiminha

    (@guiminha)


    19 years, 5 months ago

    Hi there,

    I am backing up my WP blog by simply copying (via rsync) my /var/lib/mysql/wordpress folder to another machine.
    Is this enough? I mean, if I have to restore by copying this folder back to the server, will it work? Or, because the files are databases, do I need some special or particular to MySQL way of backing them up?

    Sorry if this has been answered before, but i searched and did not found a good answer.

    Regards,

    G

Viewing 4 replies - 1 through 4 (of 4 total)
  • Chris_K

    (@handysolo)

    19 years, 5 months ago

    You probably want to do a “proper” database backup. One option is that plugin that comes with your base install (wp 2.x).

    Here’s some more reading WordPress_Backups

    Thread Starter guiminha

    (@guiminha)

    19 years, 5 months ago

    Thanks, I am aware of that link and the plugin.

    But, in fact, I don’t want to do another backup, since this simple copy/rsync system is backing up a whole lot of other data from my server (but only the WP/blog is database/Mysql).

    So, do i **have** to do a “proper” database backup, or my file copy one should work fine?

    Regards

    Chris_K

    (@handysolo)

    19 years, 5 months ago

    What happened when you tried a restore with your backup method? That’s really the true test.

    I’m not a mysql expert, but I’ve been a DBA in the past. Now, perhaps mysql is magical and doesn’t do ANY caching, but in my experience with other RDBMS… just grabbing some physical files and calling it a backup didn’t work.

    Again though, I’m not a mysql expert.

    Now, if your blog has no activity, then the backup/restore via rsync may work. No activity, no caching, no open files.

    Ok, in retrospect I’m taking entirely too long to just say, “I personally would do a proper backup. That’s my opinion.”

    Thread Starter guiminha

    (@guiminha)

    19 years, 5 months ago

    Never did a restore, that’s why I am bothering this forum… Anyway, I see your point and will probably set up a proper mysql backup (get the wp-cron/wp-backup plugins to do it).

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘backup w/ rsync or by copying mysql folder’ is closed to new replies.

Tags