yum install mysql-server<\/code><\/pre>\n<\/p>
It’s recommended to use the same version of MySQL<\/b>. However, using a newer version is also possible. <\/p>
\n<\/p>
After the MySQL server is installed, it’s time to stop it<\/b> to add to the data folders: <\/p>service mysql stop<\/code><\/pre>\n<\/p>
Step 2 – Copy the data <\/h2>
Use the following command to copy your old MySQL data to the new MySQL server data files’ location: <\/p>
cp -rf \/mnt\/var\/lib\/mysql\/* \/var\/lib\/mysql<\/code><\/pre>\n<\/p>
After the command is executed, verify that the files are owned by the MySQL user. by changing the files’ ownership<\/b>: <\/p>chown -R mysql:mysql \/var\/lib\/mysql<\/code><\/pre>\n<\/p>
When all is good to go, start your MySQL server<\/b>:<\/p>service mysql start<\/code><\/pre>\n<\/p>
Step 3 – Final checks and export<\/h2>
Check and repair all the database tables <\/b>to ensure no data is corrupted: <\/p>mysqlcheck -rA<\/code><\/pre>\n<\/p>
NOTE<\/b><\/p>\n- \n
Depending on the version of MySQL you are running, you should run MYSQLCHECK<\/p>\n<\/li>\n<\/ul>
Lastly, export the databases<\/b>: <\/p>mysqldump --all-databases > all_databases.sql<\/code><\/pre>\n<\/p>
That’s it. Now, your databases have been fully recovered!<\/p>\n","protected":false},"excerpt":{"rendered":"
Recovering MySQL databases from MySQL data files \/var\/lib\/mysql<\/p>\n","protected":false},"author":581,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"include_on_kodee":true,"footnotes":""},"categories":[199],"tags":[],"class_list":["post-1155","post","type-post","status-publish","format-standard","hentry","category-vps-management"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/4635603-how-to-recover-mysql-databases-from-mysql-data-files-in-vps-at-hostinger\/","default":1},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/support\/4635603-como-recuperar-bases-de-datos-mysql-de-archivos-de-datos-mysql-en-vps\/","default":0},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/support\/4635603-comment-recuperer-des-bases-de-donnees-mysql-a-partir-de-fichiers-de-donnees-mysql-dans-un-vps-chez-hostinger\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/4635603-bagaimana-cara-memulihkan-database-mysql-dari-data-file-mysql-di-vps-di-hostinger\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/br\/support\/4635603-como-recuperar-bancos-de-dados-mysql-de-arquivos-de-dados-mysql-em-vps-hostinger\/","default":0},{"locale":"uk-UA","link":"https:\/\/www.hostinger.com\/ua\/support\/4635603-----mysql---\/","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1155","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/users\/581"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/comments?post=1155"}],"version-history":[{"count":0,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1155\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/media?parent=1155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/categories?post=1155"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/tags?post=1155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}