:   export-mysql.bat
:   batch file to automate the relevant ULS "export-from-MySQL" functionality
:   n6lhv@arrl.net
:   created:  31-July-2004
:   updated:  13-November-2004

:   functional dependencies
:     -pkzip25 is somewhere in the path

:   At some point, this script should probably be refactored...


SET tblName=%1

:GOTO t1

: comma-delimited, data and structure
del %tblName%-dataandstructure.zip
del %tblName%-dataandstructure.sql
mysqldump --verbose --quick --result-file=%tblName%-dataandstructure.sql uls %tblName%
pkzip25 -add %tblName%-dataandstructure %tblName%-dataandstructure.sql

: comma-delimited, structure only
del %tblName%-structure.zip
del %tblName%-structure.sql
mysqldump --verbose --quick --result-file=%tblName%-structure.sql --no-data uls %tblName%
pkzip25 -add %tblName%-structure %tblName%-structure.sql

: comma-delimited, data only
del %tblName%-data.zip
del %tblName%-data.sql
mysqldump --verbose --quick --result-file=%tblName%-data.sql --no-create-info uls %tblName%
pkzip25 -add %tblName%-data %tblName%-data.sql

: comma-delimited
:del %tblName%-commadelimited.zip
:del %tblName%-commadelimited.sql
:del %tblName%-commadelimited.txt
::mysqldump --verbose --quick --tab=i:\uls\master uls %tblName%
::mysqldump --verbose --quick --tab=i:\uls\master --fields-terminated-by=',' --fields-enclosed-by="'" uls %tblName%
:mysqldump --verbose --quick --tab=i:\uls\master --fields-terminated-by=',' --lines-terminated-by='\n' uls %tblName%
:ren %tblName%.sql %tblName%-commadelimited.sql
:ren %tblName%.txt %tblName%-commadelimited.txt
:pkzip25 -add %tblName%-commadelimited %tblName%-commadelimited.sql %tblName%-commadelimited.txt

:t1
: comma-delimited (SELECT...INTO OUTFILE)
del %tblName%-commadelimited.zip
del %tblName%-commadelimited.txt
:mysql -vvv <export-mysql-commadelimited.sql >export-mysql-commadelimited.log
mysql uls -e "SELECT * INTO OUTFILE 'i:/uls/master/%tblName%-commadelimited.txt' fields terminated by ',' optionally enclosed BY '\"' lines terminated by '\n' FROM %tblName%;"
ren %tblName%.txt %tblName%-commadelimited.txt
pkzip25 -add %tblName%-commadelimited %tblName%-commadelimited.sql %tblName%-commadelimited.txt
:GOTO END

: tab-delimited (used for import into SQLite v3.x...experimental use only)
del %tblName%-commadelimited-sqlite.zip
del %tblName%-commadelimited-sqlite.sql
del %tblName%-commadelimited-sqlite.txt
:mysqldump --verbose --quick --tab=i:\uls\master uls %tblName%
mysqldump --verbose --quick --tab=i:\uls\master --lines-terminated-by='\n' uls %tblName%
ren %tblName%.sql %tblName%-commadelimited-sqlite.sql
ren %tblName%.txt %tblName%-commadelimited-sqlite.txt
pkzip25 -add %tblName%-commadelimited-sqlite %tblName%-commadelimited-sqlite.sql %tblName%-commadelimited-sqlite.txt

: tab-delimited (used for import into SQLite v2.x)
del %tblName%-tabdelimited.zip
del %tblName%-tabdelimited.sql
del %tblName%-tabdelimited.txt
:mysqldump --verbose --quick --tab=i:\uls\master uls %tblName%
mysqldump --verbose --quick --tab=i:\uls\master uls %tblName%
ren %tblName%.sql %tblName%-tabdelimited.sql
ren %tblName%.txt %tblName%-tabdelimited.txt
pkzip25 -add %tblName%-tabdelimited %tblName%-tabdelimited.sql %tblName%-tabdelimited.txt

: XML
del %tblName%-xml.zip
del %tblName%.xml
mysqldump --verbose --quick --result-file=%tblName%.xml --xml uls %tblName%
pkzip25 -add %tblName%-xml %tblName%.xml

: PostgreSQL compatible structure and data (MySQL v4.1x or higher)
: comma-delimited, structure and data
del %tblName%-dataandstructure-postgresql.zip
del %tblName%-dataandstructure-postgresql.sql
mysqldump --verbose --quick --result-file=%tblName%-dataandstructure-postgresql.sql --compatible=postgresql uls %tblName%
pkzip25 -add %tblName%-dataandstructure %tblName%-dataandstructure-postgresql.sql

:END