Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
systems:mysql_database_administration [2018/05/03 11:39] smayr [Resetting Root Password] |
systems:mysql_database_administration [2018/07/27 16:40] (current) smayr [Restore a database] |
||
|---|---|---|---|
| Line 148: | Line 148: | ||
| * Select compression: | * Select compression: | ||
| * Press <Go> button. This unpacks and runs the SQL statements stored in that gzipped file. | * Press <Go> button. This unpacks and runs the SQL statements stored in that gzipped file. | ||
| + | * Include the following statement in an SQL file that has constraints and fails to import: <code sql>SET SESSION FOREIGN_KEY_CHECKS=0;</ | ||