migrate mysql and its users

[Neozac]

I am migrating a cpanel account to another server,
I already migrated the databases, but the problem, how can I migrate the users of the databases with their passwords? in which folder do I find this file or how can I do it?

 

[ZenHostingTravis]

Hi @Neozac,

It sounds like you're transferring the files and database separately?

If you transfer the full account (with root access to both servers) or restore the .tar.gz backup file after transferring it via FTP (we prefer to use SFTP), you won't have to recreate the users of the databases and their passwords.

This information is, if it's a Wordpress site, in the wp-config file if you need to create the users using cPanel.

Hope that helps.

 

[cPRex]

The database users themselves are created in the mysql.user table on the machine, which wouldn't be migrated as part of an individual table export. It would likely be easiest (and more automated) to move the entire account to the destination machine and then delete the portions you don't want. You could also choose to skip the home directory contents of the domain, which would still move all the databases and users.

 

[Neozac]

Gracias por tus respuestas,

la cuenta de origen no tengo acceso a root, solo tengo una copia de seguridad completa que hice desde cpanel y la pasé al nuevo servidor usando FTP,
He descargado el archivo de respaldo completo a mi PC, pero no puedo encontrar los archivos de las tablas de usuario o en qué carpetas se encontrarán.

¿Cómo podría solucionarlo?

Saludos

 

[cPRex]

No esperaría que la tabla de usuarios se incluyera en ninguna copia de seguridad de usuario de cPanel. Sin embargo, cuando se restauran los datos en la máquina, los datos se escriben en la tabla de usuario. Si intentas una restauración completa de la cuenta, ¿funciona?

*********************************

I would not expect the user table to be included in any cPanel user backup. However, when the data is restored on the machine, data gets written to the user table. If you try a full restore of the account does that get things working?