Export all database tables data to a file.

[whloo]

Hi,

I have a DB with many tables in it.
I try to export all of my tables data out.
What i do now is to export table data one by one.
Is there a way for me to export all tables data at once?
Like i have a script file that contain all the tables data?
Because by using my current way, that's mean i will have 20 files to contain 20 tables data
Thanks!

Regards,
weihann.

 

[johnherman]

You could copy them together at the end using a batch file; copy a + b + c + d bigfile

Sometimes the grass is greener on the other side because there is more manure there - original.

 

[whloo]

hi johnherman,

thanks for ur reply. so, based on ur answer there is no way for me to use a single action to export all of my tables data right?
hence, i need to export one by one?
for your suggestion, what is the batch command that i need to use? lets say i have table1, table2, table3 and table4 files that contain data for 4 tables?