How do I do that? Is it possible? If it's not possible in phpmyadmin then can you tell me some alternative to achieve the same thing (putting a password to the mysql database that is being exported for backup)?
A:
Passwords and permissions are stored in the database named mysql. If you need to copy passwords you can dump and restore that database, but it will likely cause you problems, you can line by line restore from the database for tables that contain specific info.
MindStalker
2010-02-23 12:54:42