Reply to thread

Message

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

<blockquote data-quote="Anonymous" data-source="post: 2356">Perhaps anyone want to backup Settings from MP to SQL-Files.Small Tutorial ....1.&nbsp; &nbsp; Download bkp_to_sql.rar from <a href="http://http:\\www.buerdel.ch\mp\bkp_to_sql.rar" target="_blank">http:\\www.buerdel.ch\mp\bkp_to_sql.rar</a>2.&nbsp; &nbsp; Create a DIR called &quot;backup&quot; in your [Media_Portal_Home]\database - Directory.3.&nbsp; &nbsp; Extract bkp_to_sql.rar to [Media_Portal_Home]\database\backup4.&nbsp; &nbsp; 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 Databasessqlite.exe - Command-Line SQLite-Database-Clientexport.sql - Generate Temporary-SQL-Script from Database-Data-Dictionary to know what tables are inside the databasesqlitebrowser.exe - SQLite Database Browser 1.1 for Import,View,Modify Data in TablesGreetz from Switzerland - <a href="http://www.buerdel.ch/?cat=5" target="_blank">http://www.buerdel.ch/?cat=5</a></blockquote>

[QUOTE="Anonymous, post: 2356"] Perhaps anyone want to backup Settings from MP to SQL-Files. Small Tutorial .... 1. Download bkp_to_sql.rar from [url]http:\\www.buerdel.ch\mp\bkp_to_sql.rar[/url] 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 - [i]Run's export.sql on the different SQLite Databases[/i] sqlite.exe - [i]Command-Line SQLite-Database-Client[/i] export.sql - [i]Generate Temporary-SQL-Script from Database-Data-Dictionary to know what tables are inside the database[/i] sqlitebrowser.exe - [i]SQLite Database Browser 1.1 for Import,View,Modify Data in Tables[/i] Greetz from Switzerland - [url]http://www.buerdel.ch/?cat=5[/url] [/QUOTE]