[GUIDE] ...How To Excute SQL FILES In To Your Database... menu

User Tag List

Results 1 to 11 of 11
  1. #1
    Followup's Avatar Member
    Reputation
    3
    Join Date
    Aug 2007
    Posts
    17
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    [GUIDE] ...How To Excute SQL FILES In To Your Database...

    Hey,

    Well lets begin. Also Please don't flame because this is different to
    http://www.mmowned.com/forums/emulator-server-guides/56614-how-to-execute-sql-files-to-your-db-with-pictures.html

    because in my guide i have more programs. Thxs

    You Have A choice of extracting your SQL files to Navicat, SQLyog and HeldiSQL.
    Here are the download links. (Not Needed Just for Resources)
    Navicat : Navicat - the World's Best MySQL Front End for Windows, Linux & Mac OS X
    SQLyog : MySQL GUI Tools, MySQL Monitor, MySQL Manager, MySQL Performance Tuning and Optimization
    HeldiSQL : HeidiSQL - Download

    Test SQL FILE (CUSTOM T7 GEAR) : RapidShare: 1-Click Webhosting

    Well Lets begin

    NAVICAT GUIDE:
    1. Open Up Navicat.

    2. Open up your database.



    3. Right click the name of your database and select Execute Batch File.

    4. When the Box Comes up click the button with "..."

    5. Browse your folder still you find your SQL file And click Open.

    6. Once it is loaded click "Execute" And let it load.

    Congratulations You Just Executed Something In to Your Database.
    SQLYOG GUIDE:
    1. Open up SQLYOG and login with your user and pass. Also open up your database.

    2. On the top left hand corner open up File and go down the list to Open. And Open up Your SQL File.

    3. This should appear. then Click the Double Play Button at the top.

    Well Congratulations You Just Executed Something To your Database.


    HELDISQL GUIDE:
    1. Open Up HeldiSQL and open up the database.

    2. Click Query. Then Click The Little Folder And browse for your SQL FILE.

    3. Once you have opened up your SQL file it should look like this. Then click the play button near the little folder.

    Well Congratulations You Just Executed Something To your Database.
    Thank You for reading my guide. Also please don't copy and say this was made bye you. Also +Rep is also appreciated.

    Also To Use the Teir 7 Gear Type IN GAME .npc spawn 2 ( NOTE I DID NOT MAKE THIS CUSTOM MADE GEAR SAY THXS TO SLYFOX)


    copyright 2007 copyright...............................maybe lol


    urewin:
    Followup

    [GUIDE] ...How To Excute SQL FILES In To Your Database...
  2. #2
    Viter's Avatar Elite User
    Reputation
    410
    Join Date
    Aug 2007
    Posts
    2,153
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [GUIDE] ...How To Excute SQL FILES In To Your Database...

    nice guide put there is 1000 of those guides on this forum :-(



  3. #3
    Followup's Avatar Member
    Reputation
    3
    Join Date
    Aug 2007
    Posts
    17
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [GUIDE] ...How To Excute SQL FILES In To Your Database...

    but in my guide i have all three most of the other guides based on one program

  4. #4
    C.C.'s Avatar Contributor
    Reputation
    101
    Join Date
    May 2007
    Posts
    214
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [GUIDE] ...How To Excute SQL FILES In To Your Database...

    You forgot like the number 1 rule. Never mention or ask for REP

    -Richmen6

  5. #5
    Arthas117's Avatar Knight-Champion
    Reputation
    151
    Join Date
    Mar 2007
    Posts
    483
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [GUIDE] ...How To Excute SQL FILES In To Your Database...

    Um.. I though this learnt how to add a different DB to your current..I was wrong..soz man, even if i could, i wouldnt rep u

  6. #6
    2dgreengiant's Avatar ★ Elder ★


    Reputation
    1190
    Join Date
    Feb 2007
    Posts
    7,129
    Thanks G/R
    1/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [GUIDE] ...How To Excute SQL FILES In To Your Database...

    sweet dude thanks
    If you need me you have my skype, if you don't have my skype then you don't need me.

  7. #7
    Gastricpenguin's Avatar Legendary
    Reputation
    980
    Join Date
    Feb 2007
    Posts
    2,236
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [GUIDE] ...How To Excute SQL FILES In To Your Database...

    I love how the SQL failed in the navicat guide.
    Life Puzzler WoW - Website | Forums

  8. #8
    Followup's Avatar Member
    Reputation
    3
    Join Date
    Aug 2007
    Posts
    17
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [GUIDE] ...How To Excute SQL FILES In To Your Database...

    lol it failed cuz i alrdy had it lol

  9. #9
    mollusk's Avatar Member
    Reputation
    2
    Join Date
    Oct 2007
    Posts
    42
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [GUIDE] ...How To Excute SQL FILES In To Your Database...

    i updated my database to a newer rev in mangos but when launching mangosd.exe it got to loading the items then said that the table had certain amount of tables and that it should have a smaller amount of tables therefore saying that it expected to find lets say 130 tables but it found 290 and wouldnt load item table. What can i do to make this work?

  10. #10
    Followup's Avatar Member
    Reputation
    3
    Join Date
    Aug 2007
    Posts
    17
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [GUIDE] ...How To Excute SQL FILES In To Your Database...

    well try to dele all you old ata base and make the new data base.

  11. #11
    tinypocket's Avatar Member
    Reputation
    1
    Join Date
    Jul 2020
    Posts
    6
    Thanks G/R
    1/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    THANKS!!!! I needed one for at least 5weeks xD

Similar Threads

  1. [Guide] How I handle log files!
    By Viano in forum Programming
    Replies: 0
    Last Post: 01-09-2010, 03:36 PM
  2. Replies: 9
    Last Post: 04-17-2008, 02:21 PM
  3. [Guide]How to give permission to remote acces the database [Navicat]
    By Knife in forum WoW EMU Guides & Tutorials
    Replies: 3
    Last Post: 01-26-2008, 02:28 AM
  4. How to Execute SQL Files To Your DB With Pictures
    By C.C. in forum WoW EMU Guides & Tutorials
    Replies: 5
    Last Post: 11-24-2007, 07:21 PM
  5. Help needed - how to insert .sql files with SQLyog
    By ADAMZY in forum World of Warcraft Emulator Servers
    Replies: 3
    Last Post: 11-23-2007, 05:32 PM
All times are GMT -5. The time now is 04:47 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search