Import a database in MySql using console

Many times I have to back up and recover databases, and most times these exports are not usually lighter (and we’re talking around gigas).

To import this information, the best way is to run from the MySql console, the command to import the information from an sql file.

Next, this is form for import data from file

View Code SHELL
1
# mysql -u{usuario} -p{contraseƱa} --database={nombre-de-la-base-de-datos} < {ubicaciĆ³n-del-fichero-sql-a-importar}

Leave a Reply

Your email address will not be published. Required fields are marked *