BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Anarchy Online Archive => BeBot 0.2 support => Topic started by: Ahtum on March 01, 2007, 12:20:06 am

Title: SQL help.
Post by: Ahtum on March 01, 2007, 12:20:06 am

first thanks to everyone who works on this bot and the mods you all put out.
i am a complete nub for sql, bot is working great but im trying to get !symb and !pb to work. i had been trying to just copy and paste the sql files into my db folder then remove the .txt portion off the filename. areteh told me this wont work and that i have to actually import the files. so i downloaded
phpmyadmin
myimport
the phpmyadmin i have no clue what to do.
the myimport has a wizard im attempting to run.
ive looked on the web for a step by step guide, the myimport has one but it isnt addressing what i need.
does anyone know of a step by step guide i can DL or or look at? or is there an alternative to the 2 import programs i DL thats easier for new users?
thanks is advance for any help
Ahtum
 

Title: Re: SQL help.
Post by: Malosar on March 01, 2007, 12:54:54 am

Download a program called SQLYog and use that as a sql client, it's much easier.

Title: Re: SQL help.
Post by: Nytridr on March 01, 2007, 01:20:43 am

Quote from: Malosar on March 01, 2007, 12:54:54 am

Download a program called SQLYog and use that as a sql client, it's much easier.

awesome.. ty I was looking for another one.. I have gotten so use to to mysql administrator.. but still didnt like it.. this one is fairly easy..

Title: Re: SQL help.
Post by: Ahtum on March 01, 2007, 05:19:04 am

ok i downloaded sqlyog, it seems much easier. i am able to open the files i downloadedna deven can get them saved into the databse. but i get no matches found. so im assuming im doing something wrong. is there anyway someone could post a small step by step guide using sqlyog? i cant believe im the only dumbass who doesnt know how to do this.
thanks for any help
Ahtum
im close to ripping my hair out. im an old man and my hair doesnt grow back like it used to

Title: Re: SQL help.
Post by: jjones666 on March 01, 2007, 08:14:35 am

Go into database, then:
Tools > Restore From SQL dump.

Post any errors if you need any further help.  (You'll need to refresh the database after restoring - which you do by pressing F9 in the root of the database).

-jj-

Title: Re: SQL help.
Post by: Ahtum on March 01, 2007, 10:19:52 am

omg its working. huge thanks to yous. im so happy i cant hardly stand it.
thanks again. oh man now maybe i can get the rest of this stuff to work.
i been screwing with this for the last few days
cant believe its working
Ahtum