Need Help with Installing Data base

Guides for osRose and osiRose (compilation / setup)...

Moderators: osRose dev team, ospRose dev team, osiRose dev team, Moderators

Need Help with Installing Data base

Postby edgieramos on Sun May 10, 2015 9:01 am

Hey there guys, I have been having problems with installing the data base using the db_installer that comes with the svn files i followed the guide and all was good until this part, the data base wont install although i followed the instructions and checked it multiple times now. i dont know if the guide was wrong or it was my fault. This is the screen shot of my db_installer format i did it as what the guides say,
DB INSTALL.png


But when i open the file it always says \mysql.exe is not recognized just like in this screen shot.
Install error.png


me and my friends are newbies in this kind of things so we would greatly appreciate if someone could help us :) thanks in advance!
edgieramos
Jelly Bean
Jelly Bean
 
Posts: 27
Joined: Wed Dec 11, 2013 5:33 am

Re: Need Help with Installing Data base

Postby Eterdaz on Sun May 10, 2015 5:48 pm

in this case, you should check the mysqlbinpath,user, pass, and db . change it to your mysql configuration. mysqlbinpath is the file directory for "bin" folder at mysql. user is your mysql user,pass is your mysql password, db is you database name. I suggest you to try install directly from .sql file. it will be alot easier than use that application. :D :D :D
Eterdaz
Jelly Bean
Jelly Bean
 
Posts: 19
Joined: Fri Jul 18, 2014 1:40 pm

Re: Need Help with Installing Data base

Postby edgieramos on Sun May 10, 2015 6:05 pm

I see, Thanks for the reply, how can i install it directly for .sql file? most guide says to install it from the installer, i would really appreciate it if you can walk me through on how to install it directly, thanks a lot in advance man.
edgieramos
Jelly Bean
Jelly Bean
 
Posts: 27
Joined: Wed Dec 11, 2013 5:33 am

Re: Need Help with Installing Data base

Postby Eterdaz on Mon May 11, 2015 6:29 am

what is the osrose version you use ? can you give me the link ?
Eterdaz
Jelly Bean
Jelly Bean
 
Posts: 19
Joined: Fri Jul 18, 2014 1:40 pm

Re: Need Help with Installing Data base

Postby edgieramos on Mon May 11, 2015 7:15 am

Im using Hrose as my client, and as for the svn files heres the link https://osirose.googlecode.com/svn/trunk/ got this from a guide and says Hrose is easier to use and is best for beginners.
edgieramos
Jelly Bean
Jelly Bean
 
Posts: 27
Joined: Wed Dec 11, 2013 5:33 am

Re: Need Help with Installing Data base

Postby Eterdaz on Mon May 11, 2015 3:55 pm

first create the database using navicat or other software you can follow this tutorial viewtopic.php?f=18&t=4446 at chapter V part 3, then left click twice at roseon table and right click at the blank panel at the right side then choose execute sql file like this picture:

Picture1.jpg


After that you select prose.sql using "..." icon then select start.

Picture2.jpg


**this is the file : Prose.sql, i take it from the link you give me earlier.

prose.rar
(97.85 KiB) Downloaded 566 times


after you follow this step, your database should be ready. good luck :)
Eterdaz
Jelly Bean
Jelly Bean
 
Posts: 19
Joined: Fri Jul 18, 2014 1:40 pm

Re: Need Help with Installing Data base

Postby edgieramos on Mon May 11, 2015 5:08 pm

Thanks a lot man! it says error but i got this in my tables is this good now?
roseon.png
After the error i got this.

i got all of this, here is how i did it.

rose on 2.png
I got the prose file you uploaded


after excecuting it i got this error
rose on 3.png
Error


thanks for the help man. sorry for being such a noobie XD
edgieramos
Jelly Bean
Jelly Bean
 
Posts: 27
Joined: Wed Dec 11, 2013 5:33 am

Re: Need Help with Installing Data base

Postby Eterdaz on Tue May 12, 2015 12:07 pm

for those errors, i need to see the first sentence of the log message.
Eterdaz
Jelly Bean
Jelly Bean
 
Posts: 19
Joined: Fri Jul 18, 2014 1:40 pm

Re: Need Help with Installing Data base

Postby edgieramos on Tue May 12, 2015 1:02 pm

Here's a screen shot of the 1st part of the errors

error up.png
Top error


i have also screen shot the whole error i maximized the process

long error.png
All the errors part 1


long error 2.png
All the errors part 2


long error 3.png
All the errors part 3


bear with the letters being smaller xD would take lots of screen shots if i dont maximize it :)
should be readable if your zoom it :D Thanks again man. hope you can help me again man. :D
edgieramos
Jelly Bean
Jelly Bean
 
Posts: 27
Joined: Wed Dec 11, 2013 5:33 am

Re: Need Help with Installing Data base

Postby PurpleYouko on Tue May 12, 2015 3:07 pm

Do you have a database driver actually running when you try doing this?

There seems to be just too many errors here.

Personally i have never liked to to it from the batch file. It never works properly for me.

My suggestion is to use Xampp. Download it, install it and run it then on a browser open a tab and enter this URL "localhost/phpmyadmin". Follow the setup for your database drivers then open your database from there.

here is a complete backup of my osirose database from my local machine.

[The extension sql has been deactivated and can no longer be displayed.]



in the main database window click the Import tab, select the file and install it.

PHPMyadmin completely replaces Navicat.
It is Free (comes with Xampp)
It is easy to use
It can be accessed on remote machines so you can edit your database on your server machine from anywhere in the world.

Navicat, on the other hand, doesn't meet any of these 3 criteria and is made of a combination of all kinds of SUCK and FAIL.
I don't like Navicat. :lol:
Need to lookup information on NARose items, skills, quests?
Now featuring a newly completed skill tree for all classes
Formatting fixed for different resolutions
Image

"A Gazelle is nothing but a giraffe plotted logarithmicaly"
User avatar
PurpleYouko
Rose Guru
Rose Guru
 
Posts: 4733
Joined: Fri Aug 10, 2007 2:05 pm

Next

Return to osRose / osiRose Guides

Who is online

Users browsing this forum: No registered users and 3 guests