6 posts
I was wondering if theres a way of making a .SQL for the custom vendors and items that I created. like the vendor pack in this like http://www.reaper-x.com/2008/07/11/mangos-6245-udb-psdb-scriptdev2-r474/
Not to make a back up, just to give the custom items & vendors to my friends with this .SQL file.
Then to use it i would execute it in navicat and voila. But to create the .SQL file, I have no idea.
tks in advance.
Posted 1 year ago » Permalink
I hoped that someone with better SQL knowledge than me would answer you, but...
Here's the deal. SQL is simple language and you could learn it in a day or so. But you actually do not need to know a bit of SQL for this particular task. Simply do database editing directly in your database (with MySQL manager/editor) and when you're done, you can use the option (which all mysql editors have) to export the whole (or selected parts) your database to .sql file.
Posted 1 year ago » Permalink
There is actually a tool for things like this: the Quice Tool; i think that should do the trick
Posted 1 year ago » Permalink
is there any guide on how quice tool works? Ive tried and I really dont get it.
Posted 1 year ago » Permalink
Need to know this also. Arcane-Fire GM island didn't take from the .bat file menu and spawning them manually would probably work *if* all the commands were active and/or in the database. As things are, yeah, I'm going to have to find a pre-built GM-Island sql DB add-on or build one from scratch...I'll look around the forums and see what I can find first.
Posted 1 year ago » Permalink
Just noting my random thoughts here: It is always possible to type/copy the info in notepad and save it as *.sql; but that's a lot of work. I also know Navicat can backup in .sql; but im not sure you could select specific rows to export...
Then again, SQL is a database language; im SURE its possible to export rows that match a predefined condition (like a statement WHERE entry >= 1456 AND WHERE entry <= 1459) note im not a SQL expert nor do i know the syntaxis; i would try something like this
PS please ignore my previous post, i didnt read the question properly
Posted 1 year ago » Permalink
You must log in to post.
