only allowing root access

[pauline_neave]

Hi-ya,
I want to be able to only allow root access while I dump the databases,
thus locking out all non-root users ( even remote logins) then allow
all normal users back in after the dump has been done.
How would I go about this please.
thanz..

Pauline...

[Wayne Smallman]

On 2005-01-02 14:13:49 +0000, pa***********@btinternet.com said:

I want to be able to only allow root access while I dump the databases,
thus locking out all non-root users ( even remote logins) then allow
all normal users back in after the dump has been done.
How would I go about this please.

However you do this, it's not going to be graceful.

Will these users be aware that you're locking them out?

If you're going to do something like that, it would be far easier to
just change the name of the database first, then do the dump. Then no
one can get at the database whatever their level of access is.

I do this from time to time with some web-based graphical front end
like phpMyAdmin.

That way, you're not messing around with the likes of GRANT and REVOKE
which can be lethal in the wrong hands.

Hope that helps?
--
wayne smallman ][ octane interactive

[Bill Karwin]

pa***********@btinternet.com wrote:

I want to be able to only allow root access while I dump the databases,
thus locking out all non-root users ( even remote logins) then allow
all normal users back in after the dump has been done.

Are you doing this to ensure that no updates to data are done during
your database dump?

You could use the "mysqldump --single-transaction" option, available if
you are using InnoDB tables in MySQL 4.0.2 or later.

You could use the "mysqldump --lock-all-tables" option, available if you
are using MySQL 4.1.8 or later.

Also read up on the mysqlhotcopy command, to see if this does what you need.

These options don't necessarily restrict access to root, but they do
help to ensure that the backup represents a consistent snapshot of the
database.

Regards,
Bill K.