Import user of database into backup

5 posts / 0 new
Last post
#1 Sun, 12/08/2013 - 09:27
josse34

Import user of database into backup

Hi!

Into Virtualmin, i import all my database and backup work nice.

But i create user into PHPMYADMIN and this user is not imported with database into backup, how to solve this?

Thanks!!

Mon, 12/09/2013 - 10:50
josse34

Hi! Nobody have idea?? You re-create each MySQL user after restore????!!!! Thanks!!

Mon, 12/09/2013 - 10:53
Locutus

Virtualmin backups naturally won't include users (system or MySQL users) that you create outside the scope of Virtualmin; it cannot, because Virtualmin does not know about them.

You either need to create the user for your DBs through Virtualmin, or recreate them manually after restoring a backup.

Mon, 12/09/2013 - 11:24
josse34

Thanks Locutus, For creating user through Virtualmin, it's FTP user or another user, where to create him?? Thanks!!!

Mon, 12/09/2013 - 11:43
Locutus

You can do either or, and then under "Other user permissions" assign them access to the DB.

Topic locked