Documentation:Backup/de

From OCS Inventory NG
Jump to: navigation, search

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.

[[Image:]]


[[Image:]]