Databases not found problem
-
Hi, You can check the below link to map the DB.. Database Map Tool - Version 68 Documentation - cPanel Documentation 0 -
A backup copy has been uploaded to all accounts " ROOT" All database users are Not found in all accounts
RESTORE: 1 completed, 1 had warnings, and 0 failed. The system failed to grant privileges on the database "djrap_vb" to the user "djrap_vb" because of an error: (XID rqvrz3) The system user "djrap" does not control a MySQL user named "djrap_vb". The system failed to grant privileges on the database "djrap_vb" to the user "djrap_vb" because of an error: (XID 43y8qk) The system user "djrap" does not control a MySQL user named "djrap_vb". The system failed to grant privileges on the database "djrap_vb" to the user "djrap_vb" because of an error: (XID y8vgfg) The system user "djrap" does not control a MySQL user named "djrap_vb". MAXPASSENGERAPPS: The key "MAXPASSENGERAPPS" is unknown, so the system will not restore this key. ----------------------------------------------------------------------- Mysql Preparing MySQL restore " Databases owned by "djrap" will be overwritten on conflict. Restoring MySQL databases Restoring the database "djrap_vb" as "djrap_vb" " The system has created a new database named "djrap_vb". Granting "djrap" access to "djrap_vb" with temporary password " Spawning restoration subprocess for "djrap_vb" " Connecting to MySQL server as "djrap" in order to restore "djrap_vb" " Releasing objects in preparation for database restore for "djrap_vb" " Cleaning up in preparation for database restore for "djrap_vb" " Disabling InnoDB strict mode for database restore for "djrap_vb" " Restoring database data for "djrap_vb" " The database restoration subprocess for "djrap_vb" is running " The database restoration subprocess for "djrap_vb" has opened the SQL archive. The database restoration subprocess for "djrap_vb" has closed the SQL archive. The database restoration subprocess for "djrap_vb" has ended. The system has restored the contents of the database "djrap_vb". Restoring MySQL database mappings Restoring MySQL privileges Database users owned by "djrap" will be overwritten on conflict. Restoring MySQL grants The system failed to grant privileges on the database "djrap_vb" to the user "djrap_vb" because of an error: (XID rqvrz3) The system user "djrap" does not control a MySQL user named "djrap_vb". The system failed to grant privileges on the database "djrap_vb" to the user "djrap_vb" because of an error: (XID 43y8qk) The system user "djrap" does not control a MySQL user named "djrap_vb". The system failed to grant privileges on the database "djrap_vb" to the user "djrap_vb" because of an error: (XID y8vgfg) The system user "djrap" does not control a MySQL user named "djrap_vb". Restoring MySQL access hosts Storing MySQL Grants Mysql
How much your DB SQL size? If your DB size is too larger, it's better to use SSH command import, will take long few minutes or one hour to complete.0 -
I ordered it to delete using the command /scripts/restorepkg How much your DB SQL size? If your DB size is too larger, it's better to use SSH command import, will take long few minutes or one hour to complete.
0 -
Hello @hamza bel, Can you verify the version of cPanel & WHM installed on the server where the backup was generated, and on the server where the backup was restored? EX: cat /usr/local/cpanel/version
Thank you.0 -
The old server from which the backup was pulled: cat /usr/local/cpanel/version 11.68.0.38 The new server: cat /usr/local/cpanel/version 11.70.0.48 0 -
Hello @hamza bel, Can you verify if skip-name-resolve is enabled through the /etc/my.cnf file on either server? This is an unsupported option and is known to result in the error message you provided. Thank you. 0 -
/etc/my.cnf [mysqld] performance-schema=0 # # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock performance-schema=0 # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 performance-schema=0 log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid innodb_file_per_table=1 default-storage-engine=MyISAM max_allowed_packet=268435456 open_files_limit=16000 What should you do to solve the problem 0 -
The old server or The new server send 0 -
The old server or The new server send
Hello, You can use the new server's credentials and then add the source server credentials once the ticket is opened. Thanks!0
Please sign in to leave a comment.
Comments
10 comments