Mysql copy database files new server

In most cases, an organization's data is its most critical asset. Therefore, we do not want database backups laying around in our servers unprotected, as they can mistakenly leak or even worse, get stolen by hackers.

Therefore, at the first chance you get, let's compress and encrypt the file and delete the original file. To encrypt the file to a compressed file in Linux operating systems, use this command:. Now that we have an encrypted dump file, let's transfer it over the network to the new server, using SCP:.

Once the file is imported, remember to delete the dump file both for storage and security reasons. To import the file, use the following command:. Now that we have the database imported on the new server, we need a way to make sure that the data is actually there and we didn't lose anything. We recommend to start with running this query on both the old and new databases and compare the results. The query will count the rows on all tables, which will provide an indication on the amount of data in both databases.

In addition, we recommend to check for MIN and MAX records of columns in the tables, to make sure the data itself is valid and not only the amount of data.

Also, before migrating the application itself, we recommend to redirect one application instance to the new database and confirm that everything is working properly. Colin We are in the process of reviewing this article based on feedback like this. Many thanks. I need to transfer all databases from one server to another and start replication as well..!

Will this help me out..? Please help with it Reply. Agreed with Jordan Sorenson on rhel Sorin Okay, we will cross check this, thanks for the feedback. Sorin, Thanks, corrected in the article.. Got something to say? Join the discussion. Cancel reply Have a question or suggestion? Comment Name Email Save my name, email, and website in this browser for the next time I comment.

How to Copy Mysql Database to Another Server Using Command The following tutorial will show you how to export MySQL database from the old server, safeguard it, copy and import it to the new server then make sure it is there. Notes 1. Please make sure there is the same version of MySQL running on two servers with the same contribution.

Execute the —single-transaction flag to avoid database lock during the data exporting. Step 1: Exporting MySQL using mysqldump utility The Oracle built-in tool called mysqldump allows users to export database to a dump file.