How do you execute a SQL file?

[xbenxspire]

I download these .rar files where I extract them to find a SQL file with data in it. I'm told to right click it and press the execute option, but there is no execute option! Can someone write up a detailed guide, or answer it here in extreme detail, on how to execute these SQL files, cuz I just don't get it.

[Power of Illuminati]

I told you to open your database editor, open the the right connection, open the right database and then rightclick ON THE CONNECTION.

[xbenxspire]

I tried opening the connection, but it said that:

1045-Access denied for user 'root'@'localhost' (using password: NO)

Is something blocking me? If so, what, and how can I turn it off or stop it from blocking me?

[Power of Illuminati]

1. Install Navicat Lite
http://www.navicat.com/download.php?id=1
2. Open it up
3. Click on new connection
4. Enter the host of the server (if it's on your computer just write localhost)
5. Enter Username and password (Username default is root, and password is what you set up while installing MySQL, if you are using a repack as AC-web the password are often ascent)
6. Hit ok
7.Open up the database (Double click on the new connection in navicat, then double click on the database, name could be world/ascent)
8. Rightclick on the database name, INSIDE NAVICAT. Now you get a menu there, hit "Execute" button (stands something like that).
9. Point out where the .sql file is located

[xbenxspire]

Once I finish executing, it should have put it into the server? Thanks for the help!

I just got a problem. I right-clicked Mysql after double clicking it, and the executable option is "Execute Batch File". I clicked on it and searched for my SQL file by clicking the "..." button. I found the SQL file and pressed the open button, then pressed start to start executing the SQL file. It finished in about 3 seconds saying there was an error and it could not be finished. What happened? Is that normal?

[C.C.]

There something wrong with yoru sql file.
Post the error here

[hotandsekc]

open up hiediSQL navicat ect. whatever you have, if you dont have it try to find it you'll be using it alot. then once u log in up at the top it says Import, click that. Load Sql file, find the file, click it, then you will see SQL querry, on the right of it should be a blue arrow, click it, and it should be executed. gtg to work pm me if u need help

[orion5814]

Power lol, you told me, I got the same problem too bro, it wasn't the SQL file with me I had to get a new SQL reader, it happened to me with Navicat, so I got HeidiSQL and it worked there.

[Shobo]

I've been having trouble with this as well. I imported my .SQL file but where is the button to execute it in HeidiSQL I don't see it next to SQL Query

[Power of Illuminati]

No clue with HeidiSQL, but it should be when you rightclick on the database =P Else you can put all the text into the SQL query and run it

[kruz2]

HeidiSQL is more easy than Navicat...

[Power of Illuminati]

Then explain it to him? Oo

[Moffeman]

:O heidisql sux, navicat is more easy

[xbenxspire]

Dangit guys, which one is better! jk, I got a new server straight from Apple's Ascent. I had to make a new database called world and executed the SQL file called World. It had all the data for the server. Now when I execute other SQL files, it works fine. Personally, I'll stick with Navicat since I'm more familiar with it now. Thanks for the help guys! (No Sarcasm)

I've got a new question now. With this new server, I go to Ascent-world.exe file to create more accounts manually, right? When I type in "help" for some commands to use, I find the create account command. This is where I'm kind of confused. It has it like this:

: createaccount : <name> <pass> <email> <flags> :

Can someone explain to me what exactly to type in. Am I supposed to put it like this:

createaccount <name> <pass> <my email> <flags>

I know I put my username, password and email in there seperated with a space, but I don't know what to put it in the flags spot.

[Power of Illuminati]

On flags put 8, this enables TBC on the account