Fury Posted January 13, 2013 Share Posted January 13, 2013 is this possible to run 2 run server in one internal.db? Link to comment
myonlake Posted January 13, 2013 Share Posted January 13, 2013 What do you mean? You want to run two servers with the same internal database or what? Or a server with two internal databases? I don't think neither of these are possible, because the database changes every time you query it. Of course if you have made a Windows batch file and make it look for changes every now and then and then copy and paste the file to the second server, it might work, but do not think it's a good idea. It's the -worst- idea. You should use MySQL for such things. Link to comment
uhm Posted January 13, 2013 Share Posted January 13, 2013 I don't know, and I think he means the former. SQLite does support concurrency (http://www.sqlite.org/lockingv3.html), so it's technically possible to use the same database file for both servers. Link to comment
MR.S3D Posted January 13, 2013 Share Posted January 13, 2013 is this possible to run 2 run server in one internal.db? Put the same file in the other server Link to comment
Anderl Posted January 13, 2013 Share Posted January 13, 2013 is this possible to run 2 run server in one internal.db? Put the same file in the other server That's not running two servers with one internal.db, it will be two internal.db anyway. Link to comment
Fury Posted January 22, 2013 Author Share Posted January 22, 2013 I don't know, and I think he means the former. SQLite does support concurrency (http://www.sqlite.org/lockingv3.html), so it's technically possible to use the same database file for both servers. can you give me one example i really dont understand. can i change internal.db's path? Link to comment
Feche1320 Posted January 22, 2013 Share Posted January 22, 2013 No, if you want to share a DB with another host, you MUST use MySQL. MTA internal .db is only for the current server that is running it. Link to comment
Fury Posted January 22, 2013 Author Share Posted January 22, 2013 No, if you want to share a DB with another host, you MUST use MySQL. MTA internal .db is only for the current server that is running it. i want to share internal.db with server in same host. its not on the another host. edit: what about this? https://wiki.multitheftauto.com/wiki/DbConnect test_db = dbConnect( "sqlite", ":/example/sub/dir/file.db" ) Link to comment
Cadu12 Posted January 22, 2013 Share Posted January 22, 2013 You can't use SQLite with 2 or more servers. Only MySQL can do. Link to comment
Fury Posted January 22, 2013 Author Share Posted January 22, 2013 You can't use SQLite with 2 or more servers. Only MySQL can do. oh, okay. is there any MySQL tuttorial for mta sa? Link to comment
Ab-47 Posted January 22, 2013 Share Posted January 22, 2013 You can't use SQLite with 2 or more servers. Only MySQL can do. oh, okay. is there any MySQL tuttorial for mta sa? There may be more, found this: https://forum.multitheftauto.com/viewtop ... 48&t=42067 Link to comment
myonlake Posted January 22, 2013 Share Posted January 22, 2013 It's the same thing as SQLite pretty much when it comes down to functions. Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now