Online Chat
 Call Us: 
1-877-744-1221
Browse Submit a Ticket
 
Advanced Search
Tools
Rss Categories

Database backup and restore via command line

Author: Edward Hardin Reference Number: AA-00611 Views: 13793 Last Updated: 09/27/2011 09:11 AM 0 Rating/ Voters

You can use your favorite database backup/restore tools to dump KMP database, but the best way to do this is to use command line (it works on Windows as well as on Unix-like systems).
Use this command to dump the database:

mysqldump -u mysql-username -p kmp-database > dump.sql

Before restoring the database, open it in a database administration tool, e.g. phpMyAdmin or HeidiSQL and drop all tables from this database (i.e. select all tables and click "Drop Tables" button, which means "delete tables").

Then use this command to restore the database (if needed):

mysql -u mysql-username -p kmp-database < dump.sql

Custom Fields
This article applies to the following versions of Knowledgebase Manager Pro:5.1.1 and earlier, 5.2, 5.2.1, 5.2.2, 5.3.*, 5.4
Applicable to these operation systems:Linux/Unix, Windows, Apple/Macintosh
Database type:MySQL