Moving antville w/MySQL installation to another server?
Hello,
I am in the process of moving my antville installation to another server. I stopped antville, copied the whole directory and the java-files to another server. Apache and MySQL are freshly installed there. Everything starts fine, but I can only access the standard apache web-pages.
It occured to me that I have to tell the new MySQL installation that there is a antville database present. How do I do this? Running the antville mysql install script again and then just restarting antville with the copies antville database? Or do I have to dump the antville database first? (how?)
As you see, I am not exactly the master of databases, so I would be very grateful if anybody gives me a hint.
Thanks in advance!
tobi Verwaltung
antclick? ie. is there a mysql database already in use in the old installation or not?
if there is, you should try to copy the mysql database files from the old installation to the new one.
smileinthesky
Hello,
it is a antclick installation converted to MySQL. So right now there is a MySQL database running, which I want to take over to the new Server (again, Apache and MySQL). Where is the database located? I thought it was in antville/data?
tobi Verwaltung
only the mckoi db stores data in antville/data. mysql is using a different directory, either defined when compiling or depending on the operating system / distribution.
in many cases you will find most of the mysql stuff inside /var/lib/mysql (the antville database is then located inside the -- drumroll! -- "antville" subdirectory).
if not, a search for "mysql" might help; or maybe you can find a hint at http://www.mysql.com
smileinthesky
Thanks for the hint. Had to solve some minor problems, too. So this is the full procedure for merging your antville installation to a new server (Debian):
* Stop antville, copy the whole directory to the new server.
* Copy java-sdk
* Copy the database, in my case it is the directory /var/lib/mysql/antville
* If java directory changes, adapt hop.sh
* Make sure apache and mysql are installed. Install mod_jk, adapt /etc/apache/httpd.conf:
LoadModule jk_module /usr/lib/apache/1.3/mod_jk.so
Include /opt/antville/jk/mod_jk.conf
JkMount /* ajp13
* Make sure the permissions are correct:
chmod 700 for the /var/lib/mysql/antville directory, chmod u+rw and chmod g+rw for the files. Chown and chgrp directory and files to "mysql".
* Could be you have to comment out the "skip-networking" option in /etc/mysql/my.cnf
* Don't forget to add antville ussername and password to mysql:
mysql -u root
mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON antville.* TO antville@localhost IDENTIFIED BY 'whateveryourpasswordis';
* done, start hop.sh!