? Getting Data in and out of Tables Quickly

[Tritan]

I've searched and haven't found the solution to this... despite it being probably very simple...

Say i'm creating a custom armor set - i need to be able to copy that particular set of rows out of the database (and into a text doc or something) so that when there is a wipe, i can easily insert them back into the items table of the new database.

I know how to copy a chunk of rows, but i'm not sure how to paste that data back in to the database...

For some reason (sure, call me an idiot :/ ) i still haven't found the solution...

I'm using Navicat, but i'm on the free trial so i'll have to end up switching to another program later. Hopefully there's a way to do this that doesn't require Navicat.

[Greeko]

How do you mean? Be little more specific.

[waymirec]

Just use the mysqldump cli command. If, for example, the entry #'s of your custom items were 100 - 150 you could do

mysqldump -n -c -t --skip-opt --where="`entry` between 100 and 150" <dbname> items > custom_items.sql

Than when you want to reinsert them into a new db you just

mysql -u <user> -p<password> <dbname> items < custom_items.sql

[Tritan]

Just use the mysqldump cli command. If, for example, the entry #'s of your custom items were 100 - 150 you could do

mysqldump -n -c -t --skip-opt --where="`entry` between 100 and 150" <dbname> items > custom_items.sql

Than when you want to reinsert them into a new db you just

mysql -u <user> -p<password> <dbname> items < custom_items.sql

hm.. considering i am a complete SQL nub... how would i go about doing this then -
how would i use this code?

[waymirec]

I assume you are running Windows. Just open a dos prompt and run the commands as I typed them above. If the mysql executables are not in your Path you will need to either change directory to where they are or supply the full path name when running it. Pretty standard Windows stuff....