Yes, i want insert scripts.also i have used tsystem component using by this command "mysqldump -u talenduser -p db name table name > output.sql" but am not getting the result ,getting error as mysqldump: Couldn't find table: ">" can u pls suggest me to resolve this error
mysqldump is a client utility, to be able to run this command you need to have it on your workstation / server. you need to use the tSystem component and let it run the mysqldump command the > output.sql is a piping to a file, suggest specifying destination too. Next you use the tDBOutputBulk / tMySQLOutputBulk and use the generated file.
No/Yes
No, not with a different component.
Yes, if you want to do some java-coding and use the tJavaRow component and generate the insert statements entirely by yourself.
Second yes, if its a one time load ... you could ask your DB-Admin to do a backup (which wil generate .sql files).
Third, mysqldump utility should work fine... so you're doing something wrong, Im missing a host specification. Also add the -v for verbose more information.
mysqldump -v -h <database_hostname> -u<database_username> -p'<database_password>' <database_name> > test.sql
