a little more help (TRANSFERRING DB'S)
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
Quote:
Originally Posted by
dolkeboy
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
Re: a little more help (TRANSFERRING DB'S)
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.
Re: a little more help (TRANSFERRING DB'S)
Quote:
Originally Posted by
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.
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
Re: a little more help (TRANSFERRING DB'S)
Quote:
Originally Posted by
slayer200230
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...
Re: a little more help (TRANSFERRING DB'S)
Quote:
Originally Posted by
343
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
Re: a little more help (TRANSFERRING DB'S)
Quote:
Originally Posted by
slayer200230
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
Re: a little more help (TRANSFERRING DB'S)
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 ]
Re: a little more help (TRANSFERRING DB'S)
Quote:
Originally Posted by
dolkeboy
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.
Quote:
Originally Posted by
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 ]
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
Re: a little more help (TRANSFERRING DB'S)
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
Re: a little more help (TRANSFERRING DB'S)
Re: a little more help (TRANSFERRING DB'S)
" 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 "
Re: a little more help (TRANSFERRING DB'S)
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
Re: a little more help (TRANSFERRING DB'S)
... how to install navicat > try google: " install navicat " ...
Re: a little more help (TRANSFERRING DB'S)
Quote:
Originally Posted by
fgru
... 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
