Database Related - Backup w. Export/Import to from SQL-File (1 Viewer)

A

Anonymous

Guest
Perhaps anyone want to backup Settings from MP to SQL-Files.

Small Tutorial ....


1.
Download bkp_to_sql.rar from http:\\www.buerdel.ch\mp\bkp_to_sql.rar
2.
Create a DIR called "backup" in your [Media_Portal_Home]\database - Directory.
3.
Extract bkp_to_sql.rar to [Media_Portal_Home]\database\backup
4.
Hit export.cmd and all MP Tables from the 6 Databases are backuped to [Media_Portal_Home]\database\backup\[TABLE_NAME]

bkp_to_sql.rar includes:
export.cmd - Run's export.sql on the different SQLite Databases
sqlite.exe - Command-Line SQLite-Database-Client
export.sql - Generate Temporary-SQL-Script from Database-Data-Dictionary to know what tables are inside the database
sqlitebrowser.exe - SQLite Database Browser 1.1 for Import,View,Modify Data in Tables

Greetz from Switzerland - http://www.buerdel.ch/?cat=5
 

Users who are viewing this thread

Top Bottom