Page 1 of 4

Need Help with Installing Data base

PostPosted: Sun May 10, 2015 9:01 am
by edgieramos
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!

Re: Need Help with Installing Data base

PostPosted: Sun May 10, 2015 5:48 pm
by Eterdaz
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

Re: Need Help with Installing Data base

PostPosted: Sun May 10, 2015 6:05 pm
by edgieramos
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.

Re: Need Help with Installing Data base

PostPosted: Mon May 11, 2015 6:29 am
by Eterdaz
what is the osrose version you use ? can you give me the link ?

Re: Need Help with Installing Data base

PostPosted: Mon May 11, 2015 7:15 am
by edgieramos
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.

Re: Need Help with Installing Data base

PostPosted: Mon May 11, 2015 3:55 pm
by Eterdaz
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 569 times


after you follow this step, your database should be ready. good luck :)

Re: Need Help with Installing Data base

PostPosted: Mon May 11, 2015 5:08 pm
by edgieramos
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

Re: Need Help with Installing Data base

PostPosted: Tue May 12, 2015 12:07 pm
by Eterdaz
for those errors, i need to see the first sentence of the log message.

Re: Need Help with Installing Data base

PostPosted: Tue May 12, 2015 1:02 pm
by edgieramos
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

Re: Need Help with Installing Data base

PostPosted: Tue May 12, 2015 3:07 pm
by PurpleYouko
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: