MySQL export with users?

Question

MySQL

There was a task to move on other VDS. ISPManager is installed on both machines, but it refuses to import the user - constantly errors. I decided to do it manually, but I really don’t want to create MySQL users again, then write them in scripts and do other related things.
Is it possible to somehow export all databases along with users, saving their passwords?

Answer 1

phpMyAdmin cost?? if it is, it has an export function to .sql; if not, then you can run something like this through the console to the server or with cron (taking into account your database location):
mysqldump -h localhost -u DB_NAME -pservice!579_ -d lialbiz_service > /_mybackups/lialbiz_db_service.sql

Answer 2

Update tar - import errors will disappear (more on the ispsystem forum)

Answer 3

If the MySQL versions are identical on both servers, and the same OS, then just copy /var/lib/mysql completely from one to the other, and no problem.