Hi Kevin Yes you're right - you obviously need to keep the database tables if you want to keep the assets
I upgraded an existing installation, complete with the original database (not a copy), without any problems. I'm just wondering if something has gone wrong for you whilst copying the database? Clive On Wed, Oct 28, 2009 at 11:43 AM, Kevin Buckley <[email protected]> wrote: > I meant I copied the v067 built (/bin) directory to the place where I want > it. Then I compared the original ini's with the v067 versions and amended > accordingly (using a fabulous programme called 'Beyond Compare' which I > highly recommend!). > > I then used MySQL administrator GUI to take a .sql snapshot of my current > database, created a new empty database (opensimtest) and 'restored' the > snapshot to it (and changed the appropriate entries in the ini files to now > point at opensimtest) - so that the new v067 build will have all my old > inventories and assets (substantial!). > > Surely, if I drop the tables from Opensimtest that will be like starting > from scratch with a world empty of assets? > > Cheers, Kevin > > -----Original Message----- > From: Clive Gould [mailto:[email protected]] > Sent: 28 October 2009 11:05 > To: [email protected] > Cc: [email protected] > Subject: Re: [Opensim-users] Errors trying to use MySQL data with new > > > Hi Kevin > > Are you trying to make a fresh install of 0.6.7, because if you are > the error messages suggest the database tables already exist. > > For a fresh install the database needs to exist but the tables should > not be there. Try dropping all the tables in the database before you > restart OpenSim. > > Also you say you've copied over the /bin directory - you only need to > copy over and modify where appropriate OpenSim.ini, > Regions/Regions.ini and any terrain files from the old version to the > new one. > > Good luck > > Clive > > > Message: 8 > Date: Wed, 28 Oct 2009 09:49:35 -0000 > From: "Kevin Buckley" <[email protected]> > Subject: [Opensim-users] Errors trying to use MySQL data with new > opensim release > To: <[email protected]> > Message-ID: <[email protected]> > Content-Type: text/plain; charset="us-ascii" > > I am trying to use the latest v0.6.7-post release Opensim in standalone. I > have a 'production grid' which is based on the OSGrid downloadable (with the > ini files suitably changed) working with MySQL. This has been working well > for some time (but has some issues - well known). > > > > I have: > > > > O Downloaded the latest 0.6.7 following the instructions provided by Clive > Gould, prebuilt and compiled it, copied the /bin directory to make a 'Test > Grid' and changed the ini's to reflect my MySQL settings > > O Made a snapshot of my Opensim MySQL database and created a new copy > (opensimtest) which is referenced in the 'Test Grid' Opensim ini's > > > > When I try to run it I get a bunch of errors that look like this and it > terminates: > > > > 2009-10-28 09:30:23,490 INFO - OpenSim.Data.MySQL.MySQLManager [MYSQL]: > Connection established > > 2009-10-28 09:30:23,490 DEBUG - OpenSim.Data.MySQL.MySQLManager [REGION DB]: > Connection wait timeout 28860 seconds > > 2009-10-28 09:30:23,511 INFO - OpenSim.Data.Migration [MIGRATIONS] > Upgrading AssetStore to latest revision. > > 2009-10-28 09:30:23,511 INFO - OpenSim.Data.Migration [MIGRATIONS] NOTE: > this may take a while, don't interupt this process! > > 2009-10-28 09:30:23,631 ERROR - OpenSim.Server.Base.ServerUtils Error > loading plugin from OpenSim.Services.AssetService.dll, exception > MySql.Data.MySqlClient.MySqlException: Table 'assets' already exists > > at MySql.Data.MySqlClient.MySqlStream.OpenPacket() > > at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, > Int64& lastInsertId) > > at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() > > at MySql.Data.MySqlClient.MySqlDataReader.NextResult() > > at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior > behavior) > > at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() > > at OpenSim.Data.Migration.Update() in c:\Documents and > Settings\Kevin\opensim\OpenSim\Data\Migration.cs:line 141 > > at OpenSim.Data.MySQL.MySQLAssetData.Initialise(String connect) in > c:\Documents and > Settings\Kevin\opensim\OpenSim\Data\MySQL\MySQLAssetData.cs:line 83 > > at OpenSim.Services.AssetService.AssetServiceBase..ctor(IConfigSource > config) in c:\Documents and > Settings\Kevin\opensim\OpenSim\Services\AssetService\AssetServiceBase.cs:lin > e 80 > > at OpenSim.Services.AssetService.AssetService..ctor(IConfigSource config) > in c:\Documents and > Settings\Kevin\opensim\OpenSim\Services\AssetService\AssetService.cs:line 46 > > 2009-10-28 09:30:23,871 ERROR - > OpenSim.Region.CoreModules.ServiceConnectorsOut.Asset.LocalAssetServicesConn > ector [ASSET CONNECTOR]: Can't load asset service > > > > Any suggestions? - Thanks, Kevin > > > > > > _______________________________________________ Opensim-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users
