We have copied the mysql dump of ABC database from host1 around 6 months back and restored on host2 working with the same data in ABC internally. However, since its been too long thought of getting the latest dump and reload on same database. Options looked for is rename the DB, but since it is not a best practice we have ignored that. Not interested to drop the database and recreate nor will be able to restart the DB instance for any reason. Finally thought of taking the mysql dump from host1 and restore on host2 without any changes. Please let me know will there be any issues while restoring or at a later point of time when trying to extract the data as per our work demands!
No announcement yet.
Mysql dump overwrite on the same DBPage Title Module
Move Remove Collapse