Server memory blow please help

[swish]

No idea what happand, but now when I start up the server every zone takes like 350mb and kills all the memory.
Useally, all the zones together took like 200mb I have no idea whats going on.
I havent changed anything heh.

Please help! =P

Thanks,
Swish.

[swish]

This is my swap memory, I dont know what it is but I think that whats causing it:
Swap: 0k total, 0k used, 0k free, 96516k cached

What can I do ?
Please help me! =P

Thanks.

[eq4me]

I wager the guess that you are using linux? (Edit: Dumb me. Of course it is or why should it be under "Support: Linux Servers"
Are you certain that you didnt change a thing. Maybe updating the OS?
What distro/kernel do you use?
Having no swap at all is not very advisable but it probably wont help much if you are out of RAM because your server might be slowing to a crawl when swapping to harddrive.
Please have a look in /etc/fstab and see what partition is the swap partition. In case the server is running on one disk or has an hardware raid you should make sure that that partition has the correct system ID (82) and is set up as a swap partition (mkswap /dev/<whatever>) If that is the case do a swapon -a, maybe you have a wrong fstab entry. If you have a software raid the (raided)swap partition should have a system id of 'FD' or it wont work propperly.
See if any shared memory segments are still in use ... as much as I hate the idea(typical Windows procedure, if it wont work reboot and try again) you should think about rebooting the server. Depending on the kernel you use there are some strange bugs. Eg. after 400+ days of uptime under older 2.4.ish kernels ect.

[swish]

Well, now I know that its a DB problem.
Though, I cant figure out how to source an sql file.
Where do I put the sql file and than source through mysql ?

Thanks,
Swish.

[Angelox]

Originally Posted by bongol

Well, now I know that its a DB problem.
Though, I cant figure out how to source an sql file.
Where do I put the sql file and than source through mysql ?

Thanks,
Swish.

If you have a custom database or already started adding npc's ect - It may be a fatal idea, to source stuff into your DB from me or anyone else. Here is the way to do it;
Read up here and down load his (zephyr325) tool;
http://www.eqemulator.net/forums/showthread.php?t=21441
download my full PEQ back up , then restore to a NEW schema, with a new name.
Now you have your DB and mine, so you can merge my stuff into yours.

[eq4me]

Why dont you revert to the last working DB backup and try to import the latest char data from the broken DB?

[swish]

I cant seem to be able to log on my DB.
It says that the access is denied and I need to check the DB values..
Iam deperate heh.

[eq4me]

Without the exact error message we cant make a prediction. Google is your friend here.
Reading the Forums on your website it seems the trouble started after you rebootet your server? When was the last time you restarted the mysql daemon? Maybe something screwed up yor config since the last restart. Or did you transfer part of your installation to a new disk? See if the mysql file ownerships and flags are still correct.

In case you dont do this yet: I urge you to do at least a daily backup of all relevant data(Database dump and /etc/) to some save place. Maybe to another disk, an USB stick or better to an remote computer.

I am toying with doing an basic howto on EQEmu specific Linux server setup and adminstration but thanks to my current workload that might wait till the next cycle of the multiverse... *sigh*

[swish]

Iam trying to figure out how to source in Linux.
I am entering MySql but when I try to source the sql file it says that it cant find it or something. Which is obvious heh.
I was just wondering if ya know where does mysql reads sql files in Linux.
I know that its mysql/bin on windows.

Thanks,
Swish.

[swish]

Oh btw. Now I understand something.
I copied the database and I am only left with copies.
It gives me error 1017. Googled it and it says that it useally happans by copying the DB and needs to change premissions.
Saw it in HERE .

How do I change it ?

Thanks,
Swish.

[Angelox]

Originally Posted by bongol

Iam trying to figure out how to source in Linux.
I am entering MySql but when I try to source the sql file it says that it cant find it or something. Which is obvious heh.
I was just wondering if ya know where does mysql reads sql files in Linux.
I know that its mysql/bin on windows.

Thanks,
Swish.

There shouldn't be a problem with that - anything you install in Linux becomes an "integrated" part of the system- so you should be able to type out the command (in a shell), direct it to the sql file, and it should take it.
It should be "mysql" and the rest of the options you want. Remember, Linux is caps sensitive, if you put in a letter that doesn't match exactly the file's it will not work. Also make sure you have no hidden spaces.

[Angelox]

Originally Posted by bongol

Oh btw. Now I understand something.
I copied the database and I am only left with copies.
It gives me error 1017. Googled it and it says that it useally happans by copying the DB and needs to change premissions.
Saw it in HERE .

How do I change it ?

Thanks,
Swish.

You need to go to mysql.com and download some tools;
http://dev.mysql.com/downloads/
get the mysql-administrator for now, so you won't confuse your self.

[eq4me]

Did you do a copy via SQL or on the Linux commandline with 'cp' or some archiving tool like 'tar' ?
Check that the files you copied still owned by the user mysql.

Provided the user and group is named mysql you can change that back with:

chown mysql:mysql <filename>
or
chown -R mysql:mysql <directory> # this recursively changes all ownerships from the top directory down.

Be extremely cautionous when doing this and triple check that you are in the right directory.

Changing the file permissions can be done with 'chmod' please read the manpage carefully and dont do a chmod 777 or 666 it is as popular as dumb. As above be extremely cautionous that you dont accidently change the wrong files. If you accidently do an chmod -R 666 on system libraries or binaries youre screwed.

chmod 750 would make an directory read/writable by the owner, readable by the group and forbidden for anyone else

In short 777 would make an directory read/writable and an binary executable and read/writable by !anyone!. chmod 666 would be preventing anyone from entering a directory otherwise it does the same as 777.

If you do copy data around I would recommend that you use cp at least with the -iax options. If you do use tar be sure to add the -p option to preserve file ownerships and attributes.

[swish]

I am not too good with Linux heh. And I am useing a dedicated host so I dont really know how to download things to there.

Anyway, I use Webmin and I see few options to change premissions and stuff in there.
Can anybody explain to me which premission I need to change and to what plz ?

Thanks,
Swish.

[swish]

Not sure I understood that eq4me heh =P

Maybe you guys can ask me stuff and tell me what to do ?

I'v never messed with mysql too much lol. No idea how to do these stuff heh.