Remote Mysql Database Server - 8.05.2 VM

[arasha]

I am new to Deki Wiki and I am trying to configure the Deki_Wiki_Jay_Cooke_8.05.2 virtual machine to connect to our company MySQL server. (RHEL / 5.0.30sp1) I am all for RTFM but I am not finding anything definitive.

NOTE: I am trying to connect to a remote database, not connect to the local database remotely. (I mention this because it seems to be a popular question.)


So far I have done the following:

Installed the vm and confirmed it is working, backed up the local database and restored it to the remote server. (mysqldump)

Created a dedicated user with full permissions on the remote database server.

Edited the startup.xml and LocalSettings.php files and restarted the server /etc/init.d/dekiwiki restart (also tried force-reload)

I am able to connect to the remote database from the command line of the debian vm machine using the mysql -h remoteserver -u username -p etc etc.....

Does anyone know where I can find any documentation on moving the mysql database on the later releases of the deki wiki?

I have read in other threads about problems with stored procedures not getting moved in backup and restores as well as some other problems but I have not found any current threads and the ones I am finding appear to be outdated.

Thanks in advance,
Arasha

p.s. First post, go easy. :-)

[SteveB]

Might be better for you to install using the RPMs than the VM since the RPMs don't assume a local DB, afaik.

[arasha]

Ok I will give that a try.
Thanks