If I've made a whole instance or a Mall.. how do i put all the stuff in one .sql ?

[Wheeze201]

Ok, let's say I've made a new mall and I've spawned nice GO's and all the NPC's and stuff.. how do i put it in .sql file so i could release it or keep it in case i need a backup file ?

Do i just go to the Gameobjects_spawns select all the GO spawns that i spawned.. put them into a SQL file and do the sme with creature_spawns into the same .sql file ?
That would take some time to be honest : /

[Cheesy]

I've never taken out something like a mall, but I guess you can do on of these methods:

Mark every table in your database and right-click - press: "Dump SQL file" - Navicat
Right click on your database, like "ascent" and press "Backup Database as SQL Dump" - SQLyog
Mark every table in your database and right-click - press: "Export tables as SQL" - HeidiSQL

And, if you want to take only some items from your database, do this:

Step 1 - Exporting

Mark every needed table in your database and right-click - press: "Dump SQL file" - Navicat
Right click on the needed table - press: "Backup Database as SQL Dump" - SQLyog
Mark every needed table in your database and right-click - press: "Export tables as SQL" - HeidiSQL


Step 2 - Getting needed files

Now, open the freshly extracted SQL with some kind of text editor, notepad, wordpad, etc. and simply selecting the rows you DON'T want to have in there. 
Then, press "Backspace" or "Delete" or whatever you use to delete. And then, Save it.

Have fun

[Wheeze201]

Well you sort of said the same thing as i did up there.. but i was asking if there was some sort of other way to make it work..

[Cursed]

No there is no other way. That is the fastest way of exporting something out of you database. (ok you could write the whole sql but that would take much longer )

[Cheesy]

Oh, I thought you wanted to put everything in one SQL without some effort, that's the easiest way.

[latruwski]

well the way you say is good if you wnt your custom stuff only to be in the SQL file...

[beileroord]

Well i think u can do it with some SQL,

U need to make a temporary table first :

/*
SQLyog Enterprise - MySQL GUI v6.07
Host - 5.0.45-community-nt : Database - world
*********************************************************************
Server version : 5.0.45-community-nt
*/ 
/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

create database if not exists `world`;

USE `world`;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `tmp` */

DROP TABLE IF EXISTS `tmp`;

CREATE TABLE `tmp` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `entry` int(30) NOT NULL,
  `map` int(30) NOT NULL,
  `position_x` float NOT NULL,
  `position_y` float NOT NULL,
  `position_z` float NOT NULL,
  `orientation` float NOT NULL,
  `movetype` int(30) NOT NULL default '0',
  `displayid` int(30) unsigned NOT NULL default '0',
  `faction` int(30) NOT NULL default '14',
  `flags` int(30) NOT NULL default '0',
  `bytes` int(30) NOT NULL default '0',
  `bytes2` int(30) NOT NULL default '0',
  `emote_state` int(30) NOT NULL default '0',
  `npc_respawn_link` int(30) NOT NULL default '0',
  `channel_spell` int(30) NOT NULL default '0',
  `channel_target_sqlid` int(30) NOT NULL default '0',
  `channel_target_sqlid_creature` int(30) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `tmp` */

LOCK TABLES `tmp` WRITE;

UNLOCK TABLES;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

My Database has name World and the table is called TMP

Then i went to the Console of my navcat and typed :

INsert into TMP TMPSELECT * FROM  world.creature_spawns WHERE (entry >50000) and (entry <50081);

To get all the spawns for My vendors Which are in the range of 50000 - 500081.

Then all i did was dump the tmp table to a sql. Maybe u need to adjust the file to get the SPAWNID out, so it wont conflict with some future dbase..

Hope this will help u out.

Edit :
Guess it will work out fine with the gameobjects spaws too but then i guess u have to make some check in u're query line where mapid = 530 orso. or take the highest gameobjects ?? (not Sure)