How to Export Content to SQL?

[llammaboi]

How would i go about exporting content such as , a mall I made, to an SQL to release onto here?



~Thanks in Advance!

[*Alexz*]

dump sql file then delete the stuff you dont wont orr copy the custom stuff into a new file

[llammaboi]

Sorry for being nubcakeish, but just like go into navicat and choose dump SQL file, then delete any lines that isnt part of my mall? Wouldnt that take quite a bit of time?

[*Alexz*]

or you cope it into another notepad file and yes it dose lol

[waymirec]

You could do mysqldump queries on each table that has custom content and specify just the entry id's that you want. Not sure if the syntax is the same on Win as it is on Unix but here's an example (ascent = target database, items = target table)


mysqldump -n -c -t ascent items --where="entry between 190000 AND 199000" > custom.sql

[llammaboi]

Ah, thanks for the info! Gonna go make my mall now :P

+Rep to Alexz (only 1 rep power) I'mm rep you tommorow Waymirec