Documentation:Backup/de
From OCS Inventory NG
Sicherung / Wiederherstellung der OCS Inventory NG-Datenbank
Sie können Programme wie phpMyAdmin oder MySQL Administrator zur Sicherung oder Wiederherstellung von MySQL-Datenbanken verwenden.
Allerdings bietet der MySQL-Server Standard-programme für die Kommandozeile.
Sicherung der OCS Inventory NG-Datenbank
Tool “mysqldump” allows you to dump all content of a Datenbank to a single file. These tool is available in directory “INSTALL_PATH\xampp\mysql\bin” where INSTALL_PATH is the Installation oath you choosen for OCS Inventory NG Server für Windows, and generally can be directly called under Linux.
Simply run the following command to backup OCS Inventory NG database:
Mysqldump --add-drop-table --complete-insert --extended-insert --quote-names --host=localhost --user=”root” --password=”root password” ocsweb > mysqldump_ocsweb.sql
This will save database content of OCS Inventory NG database “ocsweb” into file “mysqldump_ocsweb.sql”.
Wiederherstellung der OCS Inventory NG-Datenbank
Tool “mysql” allows you to launch SQL queries on a database. These tool is available in directory “INSTALL_PATH\xampp\mysql\bin” where INSTALL_PATH is the installation oath you choosen for OCS Inventory NG Server for Windows, and generally can be directly called under Linux.
Just run MySQL command line interpreter to import saveset previously created “ocsweb”-Datenbank.
-
Mysql –u root –p ocsweb -
Source “path_to_saveset” -
exit
Hinweis: You will be prompted for root Passwort. If you haven’t yet set root Passwort, do use use –“p” Kommandozeilenschalter.
