What is this!!!

[talkster5]

i have downloaded a login script and it says to run createdb.sql

how do i go about doing this???

[cgraz]

.sql files hold the structure to your database (I believe). What you can do is get phpmyadmin (or myphpadmin; i always get them mixed up) and copy and paste the .sql file and execute it. You can also write a php script that will read the contents of the sql file and execute it, or phpmyadmin or myphpadmin may also have a feature where you can load a .sql file and have it executed.

Cgraz

[talkster5]

where do i paste the sql file

[laserlight]

Well, it depends on what option did you take.

If you are using phpmyadmin, there is a textarea provided, once you have logged in.

EDIT:
post number 1000 !
😃

[talkster5]

rite i have jsut logged into phpmyadmin and i dont see a txt box on the index page so wher is it???

[laserlight]

Have you tried using the navigation panel on the left?

[talkster5]

the only thing it shows there is the databases currentyl on there

[laserlight]

Click on the database you want.

Then you will see a page with the listing of existing tables (if I remember correctly)

Scroll past that, and you'll have your textbox.

[DeltaRho2K]

I run phpMyAdmin v 2.51 on my local machine, and here is the deal... If this file is used to create the database itself, then all you have to do is type in the name of the DB on the home page where it reads: "Create Database" and click Create.

Once you do that, then select your DB from the left side, and in the right pane, you will see a tab at the top that reads: "SQL"

Select that tab, and either copy and past into the textarea at top, or browse to select the createdb.sql file in the box below, and click GO.

Your version may be different than mine, but the principals are similar enough, you should be able to find it now that you know what you are looking for.

[talkster5]

thankyou for your help ill just go and test this

[talkster5]

thankyou and for everyone else this theory is correct

[superwormy]

you could also run the mysql program on the *nix command line, and use 'source /path/to/file.sql'