In this post, we will cover changing from SQLite3 to MySQL and updating files.
So nothing good comes from surfing the web. The FSD Web Penguin was made aware of the latest version of ownCloud version 7. Here is the process that was finally developed to avoid a few pitfalls. Do this AT YOUR OWN RISK!!!! Lucked out here and had several servers and started on the test server not caring if it was destroyed.
- Backup your ownCloud folder
- The FSD Web Penguin maintains the data folder separate from the server script files. So back up both.
- Backup your ownCloud folder
-
- The FSD Web Penguin maintains the data folder separate from the server script files. So back up both.
- You catch that I mentioned that two times??
-
- Copy the following files to a local location.
- /config/config.php
- /data/owncloud.db
- Dump the SQLite3 database
- sqlite3 owncloud.db .dump > dump.sql
- Restructure SQLite3 dump to MySQL two sources got me on the right trail:
http://paulasmuth.com/blog/migrate_sqlite_to_mysql/
http://fabianpeter.de/cloud/owncloud-migrating-from-sqlite-to-mysql/#comment-5964(Update: Broken as of 20150701)- Open dump.sql into a reliable text editor.
- Delete the first two lines down to BEGIN TRANSACTION;
- delete the last line COMMIT;
- Find (“) and replace (`) that was a double quote and the accent mark you never use to the left of 1 on my Model M keyboard.
- Find (autoincrement) and replace with (auto_increment)
- find (CLOB) and replace (LONGTEXT)
- edit your config.php
- change dbtype to mysql from sqlite
- add the following
- ‘dbname’ => ‘database name here,
- ‘dbhost’ => ‘database location’,
- ‘dbtableprefix’ => ‘oc_’,
- ‘dbuser’ => ‘database username’,
- ‘dbpassword’ => ‘database password’,
- Overwrite your config file on your server.
- Import the edited SQL into MySQL
- Erase all other files (not config and data) and extract the latest ownCloud
- Go to your ownCloud server and run update
UPDATE: This seemed to break some of my calendars on CALDAV using Thunderbird and Lightning. The solution was pretty easy. Go to the web interface and download the ICS file. Create a new calendar from the web interface. From Thunderbird re-import the calendar to the newly created calendar. 14 years of calendar seemed to be intact.