Correction
OK, its not premission. Its not the problem. I get access to the DB.
I just cant get rid of the error 1017. Any clues how to fix it ? Thanks, Swish. |
Angelox
I got it all working. I can access the DB now.
But I still having the memory blow after I used Angelox's sqls without being careful (no hard feelings). Angelox: any way you can help me remove the lines I'v added by your sqls please ? Thx. |
Quote:
MAKE SURE you compress it first with RARE or what ever, before you post it |
Yesterday: A DBA's backup song
(To be sung to the tune of Yesterday) Yesterday, All those backups seemed a waste of pay Now my database has gone away Oh I believe in yesterday Suddenly, There's not half the files there used to be And there's a deadline hanging over me The system crashed so suddenly. I pushed something wrong What it was I could not say Now my data's gone and I long for yesterday-ay-ay-ay. Yesterday, The need for back-ups seemed so far away. Thought all my data was here to stay, Now I believe in yesterday. Sorry, couldn't resist. :D Seriously. Get a good beginners book about Linux adminstration and try to be more paranoid when it comes to important data. |
Quote:
Man, I really feel bad about this, I might be able to fix his database - But I don't know how it could have gotten damaged if these sqls worked for everyone else. It could have been just a freak thing where the database got corrupted during the update process or, it could be the extra data needs more memory? his machine doesn't have much memory -anyways, If I can get my hands on it, I might be able to salvage it. |
umm
Cant really download it its on my host and wont let me download it heh.
Maybe I can PM you the password ? Or maybe give you access to the DB ? Swish. |
Dont feel bad Angelox. As far as I am reading it he is back to his original problem. That was before he inserted your SQLs(?). So it isnt your fault.
I am in the businness for over 10 years and at some point I stopped to feel sorry for people who regard backups as unneccessary. Its all about not making the same mistake twice. What I would do: Get a fresh PEQ database and switch the Server temorarily to this DB. Does the EQEmu Server still use massive ammounts of RAM? |
Lol
Lol bro, I said no hard feelings =P
I dont blame anyone but myself heh. But it was caused because of inserting these sqls. I should have backed it up heh. I just need to know how to erase these things. Thanks, Swish. |
Quote:
I really don't think these sql's did the damage - What most I worry about is, if someone has a database with work already done, then installing mine could interfere or not all go in due to duplicate numbers (not crash the whole database). Reality of all this is, if you want to depart from the original 7.0 installer for windows, and start doing your own stuff - then you need to learn stuff mysql, perl, and if Linux; basic Unix first. I know enough Unix/Linux to have a Linux EqEmu server - but chose a windows server instead, because I knew I had to learn Mysql, Perl, and would be working out Linux issues also, not to mention most the support, tools are in windows. |
Quote:
I don't really like to use PM a lot because all this that happens teaches others what to do (or what not to do). It's better to keep things open for the rest here. But PM me the password - Tell me what system you have running and where (if it is close to you like at home, or on a far off server). It sounds like your host controls you , instead of you control your host. |
Working
Alright heh, its working now =D
I deleted all the loot drops and tables that i'v inserted from the sql from the DB. The problem was the loots somehow heh. Anyway, sorry for the mess and everything. Thanks for supporting guys =D I think your doing great job Angelox heh. Its all good now heh. I just think you should make some warning in there =P Anyways, cheers guys. Thanks again, Swish. |
Quote:
That's what they have back-ups :) I haven't lost anything I wanted to keep in almost 20 years now. |
I am experimenting with an EQEmu Linux installation right now and it comes to my mind that maybe you didnt had enough shared memory.
Look in your logs or start a zone server and see if you find the following lines: Code:
failed to get 0-length shared mem: Function not implemented cat /proc/sys/kernel/shmmax The Number you got is the size in BYTES You can change that on the fly with this command. As an example let us set the size to 128 MB echo 134217700 > /proc/sys/kernel/shmmax To see an effect you should restart the EQEmu server after that. After a reboot of the server the setting is gone. If you want to make it permanent you have to edit /etc/sysctl.conf (at least for Debian, Redhat/Fedora and derviates) See if you already have an 'kernel.shmmax' entry you can modify. Otherwise add the line: Code:
kernel.shmmax = 134217700 |
Quote:
|
Quote:
http://paul.merton.ox.ac.uk/computing/beatles.html |
All times are GMT -4. The time now is 07:36 PM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.