Skip to main content

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?

Comments

4 comments

Date Votes
  • 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.
    0
  • cPRex Jurassic Moderator
    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.
    0
  • 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
    0
  • cPRex Jurassic Moderator
    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?
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post