mysql question dumb database of a user

strycnine · 04-14-2010, 07:25 AM

Hi
Is there a way to dumb all the databases owned by a specific user?

Exe: I am root, and I want to dumb all the database of the user user01.

thx

centosboy · 04-14-2010, 08:06 AM

Quote:

Originally Posted by strycnine

Hi
Is there a way to dumb all the databases owned by a specific user?

Exe: I am root, and I want to dumb all the database of the user user01.

thx

you mean dump right??
well in that case you would dump these the same way you would dump any other dbs

Code:

Usage: mysqldump [OPTIONS] database [tables]
OR     mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
OR     mysqldump [OPTIONS] --all-databases [OPTIONS]
For more options, use mysqldump --help

example

Code:

mysqldump -h hostname -u user -ppassword db1 table > dump.sql

strycnine · 04-14-2010, 11:15 PM

with mysqldumb I must loggin with a user passwd. I 'm trying to say if there is a way to dumb all databases of user x, while I'm logged with root(in mysql).

I'm triying to do mysqldumb -u x -p --all-databases > db.sql but from root user.

centosboy · 04-15-2010, 03:32 AM

Quote:

Originally Posted by strycnine

with mysqldumb I must loggin with a user passwd. I 'm trying to say if there is a way to dumb all databases of user x, while I'm logged with root(in mysql).

I'm triying to do mysqldumb -u x -p --all-databases > db.sql but from root user.

shutdown mysql.

add this

Code:

skip-grant-tables

to my.cnf, under [mysqld] section, then restart mysql.
then you can run mysqldump without a password.

Remember to remove the skip-grant-tables and restart mysql when you are done.