31,028
edits
Restores: Difference between revisions
Jump to navigation
Jump to search
m
no edit summary
Tag: 2017 source edit |
mNo edit summary Tag: 2017 source edit |
||
| Line 43: | Line 43: | ||
Dolibarr offers a command line to launch to restore the database. Click on "Show the full command". | Dolibarr offers a command line to launch to restore the database. Click on "Show the full command". | ||
For example, you will have : | For example, you will have : | ||
< | <syntaxhighlight lang="bash"> | ||
mysql mydatabase -h localhost -u databaseuser -pdatabasepass < mybackupfile.sql | mysql mydatabase -h localhost -u databaseuser -pdatabasepass < mybackupfile.sql | ||
</ | </syntaxhighlight> | ||
Open a command line shell (DOS Command line with Windows). | Open a command line shell (DOS Command line with Windows). | ||
| Line 66: | Line 66: | ||
Eg: Add FOREIGN_KEY_CHECKS in headers and footers: | Eg: Add FOREIGN_KEY_CHECKS in headers and footers: | ||
< | <syntaxhighlight lang="sql"> | ||
-- SQL Dump | -- SQL Dump | ||
-- Server version: 5.5.8 | -- Server version: 5.5.8 | ||
| Line 90: | Line 90: | ||
SET FOREIGN_KEY_CHECKS=1; | SET FOREIGN_KEY_CHECKS=1; | ||
</ | </syntaxhighlight> | ||
==PostgreSql== | ==PostgreSql== | ||