altering settings on my server

[vennatorr]

i run a planeshift server on my own machine for personal use. i built it using Induane's howto.

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...

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.

[Caarrie]

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.

[vennatorr]

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?

[neko kyouran]

becuase it violated the forum rules for duplicate posting.

[Caarrie]

try

Code: [Select]

DROP TABLE `movement_modes`;
source movement.sql;

[vennatorr]

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.

[Xillix Queen of Fools]

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

[Lanarel]

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.