migrate mysql and its users

Neozac

Member
Feb 4, 2021
12
2
3
mexico
cPanel Access Level
Root Administrator
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

Well-Known Member
PartnerNOC
May 22, 2020
244
80
28
Australia
cPanel Access Level
Root Administrator
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

Jurassic Moderator
Staff member
Oct 19, 2014
4,251
534
273
cPanel Access Level
Root Administrator
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

Member
Feb 4, 2021
12
2
3
mexico
cPanel Access Level
Root Administrator
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

Jurassic Moderator
Staff member
Oct 19, 2014
4,251
534
273
cPanel Access Level
Root Administrator
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?