SQL Help

darkkiller

LOMCN Veteran
Veteran
Loyal Member
Jul 5, 2007
254
7
45
Hi , I have a problem , I have a Monster.dat and Stditems.dat tables and I like to import this but I don't know how .. I press to Import data but I don't find to import .dat files :S
 
  • Like
Reactions: mirlin6

Amenovis

Golden Oldie
Golden Oldie
Loyal Member
Jan 9, 2006
1,105
0
123
Germany
ehm if u use the restore function ( start server db install) it should work ill think.

so why u dont go on ur db and restore it ( in that case it should do the same as a import data) mhh only thinking i dunno what u did with ur sql files ... stditems and monster) or better question...

WHAT U WANNA DO WITH IT

i ask only cause there is maybe a better or other way to make it

greetz

ameno
 
Upvote 0

Draka

Dedicated Member
Dedicated Member
Jan 22, 2008
72
0
33
maybe if you can work that table in apart sql creuldragon, when you end save the change, after you can save the change make a bakc up, after you copy that back up with the last back up.
 
Upvote 0

mapadale

Guest
have you exported the .dat files from SQL, if not then you can only restore them back into SQL. Which will over write the whole DB for that file.

If you've exported it from SQL, then if you go to the import. It ask's you what format the files are that you want to import, if you notice in the SQL import screen where you browse the type of files you have a list.

TABLE -> ALL TASKS -> IMPORT DATA

This will bring up the wizard.

First you need to change you data source, this is the type of file you are trying to import into SQL. Once you have choosen the correct file format, it will ask you to show it where the files are stored. Once you've done the first part of the import you go onto the destination for the file.

The destination doesn't need to be changed as this is SQL, so leave it alone. All the rest is self explantry.
 
Upvote 0