a little more help (TRANSFERRING DB'S)

[slayer200230]

ok now that i have a server that works i would like to bring all my charters from one server to the other, only one problem, i have forgotten how to get into the phpmyadmin, i believe the link would be 192.169.1.10/phpmyadmin, but it does not work. what do i need to do to get phpmyadmin working so i can go into the database files? is phpmyadmin in hrace009's release?

i have read threw alot of post on here, and have come to a stand still. i wish hrace009's thread was still here, on it was all the things i had to do to get back to where i was, its been 10 months + since i had to do any of this. i can run around and everything loads fine, just cant buy anything out of botique, mind you i never lost my client, so i just reopened it, if i recall right some file has to be in both the server and the client, i also have to find my npcgen.data file that has all the npc's i edited. to fix the safe zone error in 1k i believe i had to convert the new map folder and replace a file in the server wich one i dont remember anymore. like i said all of this was found in his thread. sorry for all the questions

Make a backup or copy the old server files from the folder PWServer paste them to the new one , it worked for me i had the characters but once when i had some problems and had to reinstall everything and did this , the characters were showing on another accounts , my GM characters were on a players account.
you can try to copy the files if no just wipe /redo and its better

i have tried this, and it works charters pop over, problem, the accounts dont, their stored in the database, if i could get into that i can easyily move them over, im useing hrace009's release that used oracle VM virtualBox, once i can get into the database i can take care of the charters/accounts, then only the other questions remain

[MentaL]

[rudisans]

http://192.168.0.10/
Posted via Mobile Device

[343]

Game characters are stored in the gamedbd DB. Accounts, GM flag etc are stored in the MySQL DB. Whenever 'transferring' you must backup/copy over both DB's or you'll wind up having accounts and no characters, or characters no accounts.

[slayer200230]

Game characters are stored in the gamedbd DB. Accounts, GM flag etc are stored in the MySQL DB. Whenever 'transferring' you must backup/copy over both DB's or you'll wind up having accounts and no characters, or characters no accounts.

i know this much my problem is accessing the MySQL DB, i can move over the charters, not the accounts bc i cant remember how to gain accuess to the MySQL DB i have done this once b4 but it was 10+ months ago

and my ip is 192.168.1.10 i already changed all the ip's in the files

[343]

i know this much my problem is accessing the MySQL DB, i can move over the charters, not the accounts bc i cant remember how to gain accuess to the MySQL DB i have done this once b4 but it was 10+ months ago

and my ip is 192.168.1.10 i already changed all the ip's in the files

There's only a million plus ways you could do this... Using the MySQL command line, phpmyadmin, navicat, or one of the other 999,997 programs out there for managing DBs...

Spoiler:

personally I recommend and use Navicat myself

[slayer200230]

There's only a million plus ways you could do this... Using the MySQL command line, phpmyadmin, navicat, or one of the other 999,997 programs out there for managing DBs...

Spoiler:

personally I recommend and use Navicat myself

i downloaded Navicat but each time i tried to connect it refused the connection, im use to phpmyadmin, i have used it several times, do i need to download it, and place it into the server or is it already their, i dont remember doing it b4, but i may have, is their a guide on how to add it to hrace009's ver? Navicat looked nice, but i dont know what im doing wrong

[Jacknife]

i downloaded Navicat but each time i tried to connect it refused the connection, im use to phpmyadmin, i have used it several times, do i need to download it, and place it into the server or is it already their, i dont remember doing it b4, but i may have, is their a guide on how to add it to hrace009's ver? Navicat looked nice, but i dont know what im doing wrong

Try searching most of questions i think that have been awnsered

[fgru]

phphmyadmin [ debian / ubuntu ] > apt-get install phpmyadmin > http://YOURIPHERE/phpmyadmin ... [ need installed mysql and YOUR password for mysql ... ] ...

other OS > try search [ ... google > YOUROSHERE install phpmyadmin ]

[slayer200230]

Try searching most of questions i think that have been awnsered

your right most of the questions had been answered, on hrace009's original post, now that the hole post is gone i have to ask them again. if i had not searched already i would not be asking the questions, i know alot of ppl who post here do just ask, i spent hours going threw post of phpmyadmin on here, i did not find one that answered my question. is phpmyadmin in hrace009's release already or do i need to install it. sorry if i sound ticked but i do understand y some ppl get ticked off. not all of us are idiots . i say this bc even tho i asked my question, it seams like people are not reading it. i have stated that my ip is 192.168.1.10 and has been changed as such, yet one post is simply 192.168.0.10, i do know where the account info is stored, what i cant remember is how i got into it last time, i know i used phpmyadmin. sorry for the rant just had to let it go. i appreachate everyones help, i really do, just get ticked when ppl treat me like i have not tried looking for the answers myself, heck half the time i find the answer b4 anyone lets me know.

phphmyadmin [ debian / ubuntu ] > apt-get install phpmyadmin > http://YOURIPHERE/phpmyadmin ... [ need installed mysql and YOUR password for mysql ... ] ...

other OS > try search [ ... google > YOUROSHERE install phpmyadmin ]

thanks ill have to give that a try, ill get back to you asap, currently im visiting at my dads and cant try it yet

[slayer200230]

ok so i installed a new instance onto this pc so i could mess with it, got everything running, got my npc's and safe zone fixed, only one thing, i still cant get phpmyadmin, i tryed sudo apt-get install phpmyadmin, and it comes to an e: counldn't find package phpmyadmin, i did a google search and tried ever sugestion, still could not get it, im lost, if their is another php program like phpmyadmin that i could use or get a guide on how to install, i will give it a try

[Jacknife]

http://forum.ragezone.com/f755/setti...yadmin-719098/
Try google search....

[fgru]

" i tryed sudo apt-get install phpmyadmin, and it comes to an e: counldn't find package phpmyadmin "

OS ? debian like needs: " apt-get update "

[slayer200230]

ok so after all of this i looked how to install navicat, and while searching i came across phpMyAdmin-3.2.4 not phpmyadmin wow after all that it was just bc of the name, i dont know if i should feel stupid or, just say wow. after all this digging just a name was wrong, well anyway i can get into phpmyadmin, i changed the folder name to such and it worked 192.168.1.10/phpmyadmin :) now to run to my server and power it up so i can pull the old accounts

[fgru]

... how to install navicat > try google: " install navicat " ...

[slayer200230]

... how to install navicat > try google: " install navicat " ...

lol dont need it phpmyadmin is working, now for a question, i want to pull just the users out of db0 is their a file i can do that, i want to be very clear, something is wrong with my old servers mysql, period, i dont want to spend hours trying to fix it, i know what i want, i just need to know if i can take it. everything on a computer is ran threw files, even the dbo is made of files, my question is where can i find the db0 files i have searched and searched i cant find it, i can start new. tho, i would like to continue from where i left off.

i am trying to move the files themself off the server, if this works i can recover the tables and all, i will keep u updated

it worked, i am now makeing 3 backup instances of this server, as is, everything but toons have been added, i will add that next

[fgru]

... dbo is the name of the database ... dont know what ur mean ...

[slayer200230]

... dbo is the name of the database ... dont know what ur mean ...

what i had meant was the actual files for dv0, i found then now i have an interesting problem, i cant create any new accounts, says connection to the mysql database failed, yet it reads all the accounts just fine, how can it read from the database but not write to it

i pulled the db0 from the old server, i have checked permissions and all seam to be in check, what could i be missing?

[fgru]

https://www.google.de/search?q=mysql...w=1259&bih=661

[slayer200230]

what was the point of that link? do you think i dont know how to move the files? or how to google? look im gonna be frank, i ask the questions here bc i have questions my searching did not answer, ppl who dont read the messege, then post a reply dont help. for once i wish someone would read all the post, and reply with some useful info. the database has been moved! i already stated that, something else is going on so i asked a question. when ever i go to register an account i get a mysql error, cant log into the accounts bc of this same error, tho in phpmyadmin its their, in pwadmin i can see all charters and accounts, i dont understand what error mysql is haveing

[fgru]

... gz THIS is a usefull explain ... other are ...