Hi,

I'm trying to restore a database in another computer/server that was
dumped as:
mysqldump -u $USER -p${KEY} --master-data=2 --all-databases > dump_file

But the restore procedure complains that one user (that has all grants
in all databases) does not exist.
ERROR 1449 (HY000) at line 28978: The user specified as a definer
('px2'@'%') does not exist

The command for restoration is:
mysql -uroot -p < dump_file

Clearly, since I ran the mysql_install_db and mysql_secure_installation,
the user 'px2'@'%' is not in the new server.
Wasn't the 'all-databases' supposed to bring the users with their
privileges for the new server?

What can I do? There is at least other admin account and several other
accounts with different privileges.


--


Luis P. Mendes

luislupeXXX (AT) gmailXXX (DOT) com (L M) wrote:
What statement in the dump file yields this error?
Probably a VIEW definition?

It should be created when you load the dump. But:

$mysqldump --help
....
--flush-privileges Emit a FLUSH PRIVILEGES statement after dumping the mysql
database. This option should be used any time the dump
contains the mysql database and any other database that
depends on the data in the mysql database for proper
restore.

You need this. Whitout this option the loaded (from the
dump) MySQL accounts won't be enabled.

If you are running a very old version of MySQL (specifically:
of mysqldump) then you might be affected by this bug:

http://bugs.mysql.com/bug.php?id=21424

As a workaround you can dump the `mysql` database separately
from the other databases (use the --databases option).
Then load the `mysql` database first and run FLUSH PRIVILEGES
manually. Then load the other dump.


PS: looks like --flush-privileges defaults to false. IMHO it
should be set to true when --all-databases is used. Maybe you
should file a feature request for this.


XL

Axel Schwenke <axel.schwenke (AT) gmx (DOT) de> wrote:

--


Luis P. Mendes