I've been using gallery for a while, and now i want to start using WordPress as well. "They" suggest that i run G2 and WP from the same SQL-server. I've installed this WP plugin called wpg2 to run G2 on WP, and it seems 2 run just fine on 2 different SQL.
Anyone have any thought about this?
Will i meet problems down the line running it on separate SQLs?
Am i just paranoid running them separate?
My webhoster is installing all this for me at my command. (one-click-install sort of thing on their homepage (http://www.dreamhost.com)). Would it be safe for me to just have WP us the G2-base when it's being installed by dreamhost.com?
My server:
Gallery version = 2.2.2 core 1.2.0.4
PHP version = 5.2.2 cgi-fcgi
Webserver = Apache/2.0.54 (Unix) PHP/4.4.7 mod_ssl/2.0.54 OpenSSL/0.9.7e mod_fastcgi/2.4.2 DAV/2 SVN/1.4.2
Database = mysql 5.0.24a-standard-log, lock.system=flock
Toolkits = ArchiveUpload, Exif, Ffmpeg, Getid3, NetPBM, Thumbnail, Gd
Operating system = Linux 2.6.18.1
Rows in GalleryAccessMap table = 216
Rows in GalleryAccessSubscriberMap table = 1282
Rows in GalleryUser table = 4
Rows in GalleryItem table = 1275
Rows in GalleryAlbumItem table = 79
Rows in GalleryCacheMap table = 1113
Posted: Mon, 2007-07-30 07:16
Posts: 32509
topic moved to the WP forums.
i'm pretty sure you can have WP and G2 use different mysql dbs or even servers. that's the case for some other integrations as well.
you can also use the same db for both, with a different db table prefix for each application.
note that the word "database" has a different meaning in a different context.
e.g. on the application level, WP and G2 use different databases anyway. they both have their own separate User table etc.
on the database server level, WP and G2 can use the same MySQL database, but they don't have to.
--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage