{"id":2001,"date":"2015-02-24T15:42:43","date_gmt":"2015-02-24T14:42:43","guid":{"rendered":"http:\/\/sdubois.evolix.net\/blog\/?p=2001"},"modified":"2015-02-24T15:42:43","modified_gmt":"2015-02-24T14:42:43","slug":"owncloud-7-or-8-migrating-from-sqlite-to-mysql-or-pgsql","status":"publish","type":"post","link":"https:\/\/sdubois.fr\/blog\/2015\/02\/owncloud-7-or-8-migrating-from-sqlite-to-mysql-or-pgsql\/","title":{"rendered":"owncloud 7 or 8 : migrating from sqlite to mysql (or pgsql)"},"content":{"rendered":"<p>Before Owncloud 6, one used solution was to use sqlite3 to generate an .sql (and then import this .sql in the database configured for Owncloud after using a conversion <a title=\"sqlite3-to-mysql.py\" href=\"http:\/\/www.redmine.org\/attachments\/download\/6239\/sqlite3-to-mysql.py\">script in python<\/a>) [as explained on <a title=\"http:\/\/fabianpeter.de\/cloud\/owncloud-migrating-from-sqlite-to-mysql\/\" href=\"http:\/\/fabianpeter.de\/cloud\/owncloud-migrating-from-sqlite-to-mysql\/\">http:\/\/fabianpeter.de\/cloud\/owncloud-migrating-from-sqlite-to-mysql\/<\/a>)<\/p>\n<p>Now, it&rsquo;s an option integrated in owncloud (&gt;7.0.0) with this syntax (in your ownCloud root folder with your web user for owncloud (\/var\/www\/owncloud\/ and www-data in the case of an installation with Debian packages)):<\/p>\n<blockquote><p>php occ db:convert-type &#8211;all-apps mysql oc_mysql_user 127.0.0.1 new_db_name<\/p><\/blockquote>\n<p><em>What is the database password?<\/em><br \/>\nCreating schema in new database<br \/>\nThe following tables will not be converted:<br \/>\noc_clndr_calendars<br \/>\noc_clndr_objects<br \/>\noc_clndr_repeat<br \/>\noc_clndr_share_calendar<br \/>\noc_clndr_share_event<br \/>\noc_contacts_addressbooks<br \/>\noc_contacts_cards<br \/>\noc_contacts_cards_properties<br \/>\noc_gallery_sharing<br \/>\noc_lucene_status<br \/>\noc_media_albums<br \/>\noc_media_artists<br \/>\noc_media_sessions<br \/>\noc_media_songs<br \/>\noc_media_users<br \/>\noc_permissions<br \/>\noc_pictures_images_cache<br \/>\noc_queuedtasks<\/p>\n<p><em>Continue with the conversion (y\/n)? [n] y<\/em><\/p>\n<p>The step \u00ab\u00a0oc_filecache\u00a0\u00bb may be long \ud83d\ude09<\/p>\n<p>At the end, your config.php is upgraded and you can see :<\/p>\n<p>&lsquo;dbtype&rsquo; =&gt; &lsquo;mysql&rsquo;,<\/p>\n<p>\ud83d\ude42<\/p>\n<p>More information on :<\/p>\n<p><a title=\"http:\/\/doc.owncloud.org\/server\/7.0\/admin_manual\/maintenance\/convert_db.html\" href=\"http:\/\/doc.owncloud.org\/server\/7.0\/admin_manual\/maintenance\/convert_db.html\">http:\/\/doc.owncloud.org\/server\/7.0\/admin_manual\/maintenance\/convert_db.html<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Before Owncloud 6, one used solution was to use sqlite3 to generate an .sql (and then import this .sql in the database configured for Owncloud after using a conversion script in python) [as explained on http:\/\/fabianpeter.de\/cloud\/owncloud-migrating-from-sqlite-to-mysql\/) Now, it&rsquo;s an option integrated in owncloud (&gt;7.0.0) with this syntax (in your ownCloud root folder with your web <a href=\"https:\/\/sdubois.fr\/blog\/2015\/02\/owncloud-7-or-8-migrating-from-sqlite-to-mysql-or-pgsql\/\"> lire la suite <span class=\"meta-nav\"><\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":2293,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-2001","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tic"],"_links":{"self":[{"href":"https:\/\/sdubois.fr\/blog\/wp-json\/wp\/v2\/posts\/2001","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdubois.fr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sdubois.fr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sdubois.fr\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sdubois.fr\/blog\/wp-json\/wp\/v2\/comments?post=2001"}],"version-history":[{"count":0,"href":"https:\/\/sdubois.fr\/blog\/wp-json\/wp\/v2\/posts\/2001\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sdubois.fr\/blog\/wp-json\/wp\/v2\/media\/2293"}],"wp:attachment":[{"href":"https:\/\/sdubois.fr\/blog\/wp-json\/wp\/v2\/media?parent=2001"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdubois.fr\/blog\/wp-json\/wp\/v2\/categories?post=2001"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdubois.fr\/blog\/wp-json\/wp\/v2\/tags?post=2001"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}