MySQL Forums
Forum List  »  Backup

Backup of accounts/passwords/permissions
Posted by: Alex Croton
Date: February 15, 2005 11:35AM


I'm looking for the 'best' way to backup the security details for my MySQL 4.1.9-nt database.

I currently use mysqldump to back up the databases, but I'm concerned regarding the advisabililty of using a dump created in this manner to restore the security information.

Looking at the output of mysqldump, it uses a "drop, recreate and populate" approach - this seems a little dangerous particularly with respect to the root account.

From a pure DR point of view, if something goes wrong and the server is locked out - you can simply rebuild (as I presume you would have just done), but I am currently running with copies of a database on my laptop and on my home PC - and need to ensure that the security parameters can be kept in synch.

For the miniscule databases that I am talking about - and due to the developmental nature of what I am doing - I want to be in complete control of the databases, so replication is not the answer.

What I _want_ to be able to do is to take incremental-style backups of the accounts, passwords and permissions - to be able to apply them to the other machine.

Is there a simple way of doing this, that I'm just too dumb to see?


Alex Croton

Options: ReplyQuote

Written By
Backup of accounts/passwords/permissions
February 15, 2005 11:35AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.