quering a database...

[apotterdd]

i found this really cool free php/flash chat program. i believe i got everything right but in the directions it tells me to do this.

'Run SQL query/queries on database'

???

i'm confused so i'm not quite sure how to go about this here's the page that the documentation is on if that could help you help me out ;)

http://download.zehnet.de/ZZ_FlashChat_1.31/ it's under installation.

thanks in advance.

[iDxMan]

Its referring the phpMyAdmin `run SQL` screen. Basically its _one_ way to import the `install.sql` into the DB. You could do this from the command line:


mysql -uuser -p chat_db_name < /path/to/install.sql

[apotterdd]

I finally got the php my admin up and running on my server which took me several days to do. but i'm still a little confused as to getting install.sql running. i'm not totally understanding what you wrote there. i'm fairly new to this still myself if you could just explain a little bit or someone exactly tell me what to type in coz i'm am really really confused. and the documentation that came with it is just too far over my head to comprehend.

i so hate to be a pain but i'm totally lost.

thanks again,

anita

[stuka]

Actually, what's posted in the quote box is exactly what you should type on a command line. What it's doing is running the mysql command interpreter, as user "user" (so you'll need to change that to the correct user name for mysql), working on the chat_db_name (again, make it correct for your db), and feeding it with the file /path/to/install.sql (so substitute the correct path on your machine).

[DeadlySin3]

On all of my sites, i'm using CPanel 5

When I go into PHPMyAdmin - There is a drop down menu on the left where you can select which database to work with. Select the db you are using to install this script.

Once you do that, at the top of the screen, you'll see some tabs, "Structure" "SQL" "EXPORT" among others - click on SQL - and you will see a text box and a browse button.

Press the browse button - find the .sql file on your hard drive,(install.sql?) and upload it.

That always works for me!

[apotterdd]

thanks guys. for some reason it's still not working for me. i think the php my admin i have is buggy and i should find a different one to work with. maybe then i'll be able to get it all up and running.

thanks for the help.

anita