SQL help.

Ahtum

Freshman

Offline

Posts: 9

SQL help.

« on: February 28, 2007, 06:20:06 PM »

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


	Logged

Malosar

Expert

Offline

Posts: 259

Re: SQL help.

« Reply #1 on: February 28, 2007, 06:54:54 PM »

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


	Logged

Eternalist
General of The Syndicate

Nytridr

Expert

Offline

Gender: Male

Posts: 261

Re: SQL help.

« Reply #2 on: February 28, 2007, 07:20:43 PM »

Quote from: Malosar on February 28, 2007, 06:54:54 PM

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..


	Logged

Co-Prez of Rising Sun RK1 (1st & only org I will ever belong to)

Ahtum

Freshman

Offline

Posts: 9

Re: SQL help.

« Reply #3 on: February 28, 2007, 11:19:04 PM »

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


	Logged

jjones666

BeBot Contributor
Champion

Offline

Posts: 353

Re: SQL help.

« Reply #4 on: March 01, 2007, 02: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-


	Logged

Ahtum

Freshman

Offline

Posts: 9

Re: SQL help.

« Reply #5 on: March 01, 2007, 04: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


	Logged

Pages: [1] Go Up

BeBot - An Anarchy Online/Age Of Conan chat automaton > Forum > Support > Support for older versions > BeBot 0.2 support > Topic: SQL help.

« previous next »