PlaneShift

Development => Development Deliberation => Topic started by: vennatorr on April 06, 2008, 01:46:44 pm

Title: altering settings on my server
Post by: vennatorr on April 06, 2008, 01:46:44 pm

i run a planeshift server on my own machine for personal use. i built it using  Induane's howto (http://vaalnor.mine.nu/psdoc/?q=node/51).

it works fine but now i want to alter some of the settings. i've gone into /src/server/database/mysql and edited the relevant file. now i need to update the database. here's what i did...

Quote

me@desktop:~$ cd /home/me/software/planeshift/planeshift_svn/src/server/database/mysql/
me@desktop:~/software/planeshift/planeshift_svn/src/server/database/mysql$ gedit movement.sql
me@desktop:~/software/planeshift/planeshift_svn/src/server/database/mysql$ mysql -u planeshift -pplaneshift planeshift $@
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 21
Server version: 5.0.45-Debian_1ubuntu3.3-log Debian etch distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use planeshift;
Database changed
mysql> source movements.sql
ERROR:
Failed to open file 'movements.sql', error: 2
mysql> quit
Bye

any idea what i'm doing wrong here?
thanks.

Title: Re: altering settings on my server
Post by: Caarrie on April 06, 2008, 03:08:01 pm

well you have not told us what you changed to start, and without knowing that there is no way for us to know what you got that error.

Title: Re: altering settings on my server
Post by: vennatorr on April 06, 2008, 03:43:52 pm

well, i changed the run speed, but that wouldn't explain why mysql couldn't find the file would it?

*edit*



i've just removed the modified file and restored the original and it's still not working.

me@desktop:~/software/planeshift/planeshift_svn/src/server/database/mysql$ ls movement*
movement.sql

the file is definitely there. no idea why mysql is saying it can't find it.

*edit*

why did you edit my post neko?

Title: Re: altering settings on my server
Post by: neko kyouran on April 06, 2008, 04:28:21 pm

becuase it violated the forum rules for duplicate posting.

Title: Re: altering settings on my server
Post by: Caarrie on April 06, 2008, 04:32:30 pm

try

Code: [Select]

DROP TABLE `movement_modes`;
source movement.sql;

Title: Re: altering settings on my server
Post by: vennatorr on April 06, 2008, 05:56:04 pm

neko - i've taken another look at the forum guidelines and it does say that posters should not "Make multiple posts on the same subject for the purpose of getting attention paid to your issue", which wasn't what i was doing. i tried fixing the problem in a different way and when that didn't work i reported back on it's results to help clarify the problem. i wasn't bumping the thread either. not exactly sure what rule i broke here, care to elaborate?

caarie - thanks. i'll try that.

Title: Re: altering settings on my server
Post by: Xillix Queen of Fools on April 08, 2008, 05:32:19 am

no two posts in a row, just edit your last one.

Title: Re: altering settings on my server
Post by: Lanarel on April 08, 2008, 08:30:50 pm

Quote from: vennatorr on April 06, 2008, 01:46:44 pm

Quote

sktop:~/software/planeshift/planeshift_svn/src/server/database/mysql$ gedit movement.sql
....
mysql> source movements.sql
ERROR:
Failed to open file 'movements.sql', error: 2

any idea what i'm doing wrong here?
thanks.

Yes, I have an idea :) You edit the file movement.sql but try to source file movementS.sql. Try it without the S.