Converting from SQLite to MySQL (without root access)

hosting

#1

I am trying to convert my ownCloud installation from SQLite to MySQL, but I don't have root access, as this is a VPS that behaves a little more like shared hosting.

In the OCC info page (https://doc.owncloud.org/server/9.0/admin_manual/configuration_server/occ_command.html) it shows that the user should use OCC as root.

However, it doesn't show anything about root in the conversion page (https://doc.owncloud.org/server/7.0/admin_manual/maintenance/convert_db.html).

Do I absolutely need to have root access to make this work?


#2

Mhhh, i don't see any note on the first link that occ needs to be running as root. It clearly says:

You must run it as your HTTP user to ensure that the correct permissions are maintained on your ownCloud files and directories.


#3

It is: sudo -u apache /opt/rh/php54/root/usr/bin/php /var/www/html/owncloud/occ

In the first link.


#4

For example, in CentOS 6.5 with SCL-PHP54 installed, the command looks like this:

is in front of this command. Those are examples for various common linux distributions which needs to be adjusted to your environment.


#5

So, the issue ended up being the file path is slightly different, so it wasn't navigating correctly.