Restore single mysql DB

Restore individual mysql db

It is necessary to be very careful when you go to restore individual mysql DB. databases in mysql.

I present a case: you have a db on your personal development, or on your local network and you want to reproduce the production environment that you have online.

Dangerous recovery attention

We run a serious risk: If the backup contained a full dump of the db, done with the Dumping Data in SQL Format with mysqldump, and you do a restore “non-selective”, upon completion you will have restored all the db contained in the backup, including users, passwords and access permissions from various hosts.

Take conscience, could be dangerous.

To restore a single database catalog:
# mysql-u root-p[root_password] [database_name]< dumpfilename.sql

Better yet, open the file in an editor and select, reduce the dump, the only part that you want to restore.

backup, mysql, restore, SQL

Lascia un commento

Il tuo indirizzo email non sarà pubblicato. I campi obbligatori sono contrassegnati *

Un progetto da realizzare?

Start up, think tank, idee da sviluppare in sistemi e software ...

© ICT360. All rights reserved. Powered by ICT360.