X-Git-Url: https://git.phdru.name/?a=blobdiff_plain;f=docs%2Fmysql2sql.rst;fp=docs%2Fmysql2sql.rst;h=aba493eed1522dab52c31d700bf3edeb365a018d;hb=159b4e3d7127e719a0dd12013dd54bf05b276ba9;hp=0000000000000000000000000000000000000000;hpb=5ecbd0d7b0fdd14e669438b44845eabe82285648;p=sqlconvert.git diff --git a/docs/mysql2sql.rst b/docs/mysql2sql.rst new file mode 100644 index 0000000..aba493e --- /dev/null +++ b/docs/mysql2sql.rst @@ -0,0 +1,51 @@ +.. mysql2sql documentation master file, created by + sphinx-quickstart on Fri Jul 22 19:32:24 2016. + You can adapt this file completely to your liking, but it should at least + contain the root `toctree` directive. + +Welcome to mysql2sql's documentation! +===================================== + +This is mysql2sql, a mysql to sql converter. It is primary intended to +convert mysqldump (especially with extended INSERT syntax) to standard +SQL to load at least to PostgreSQL or SQLite. + +The program is in its initial phase and currently cannot do much. + +.. highlight:: none + +Command line +------------ + +mysql2sql +~~~~~~~~~ + +Usage:: + + mysql2sql [-e encoding] [-E output_encoding] [infile] [[-o] outfile] + +Options:: + + -e ENCODING, --encoding ENCODING + input/output encoding, default is utf-8 + -E OUTPUT_ENCODING, --output-encoding OUTPUT_ENCODING + separate output encoding, default is the same as + `-e` except for console; for console output charset + from the current locale is used + -P, --no-pbar Inhibit progress bar + infile Input file, stdin if absent or '-' + -o, --outfile outfile Output file, stdout if absent or '-' + +If stderr is connected to the console the program displays a text mode progress +bar. Option `-P/--no-pbar` inhibits it. + +Option `-o` is useful when infile is absent (input is redirected), for +example:: + + mysql2sql -o outfile.sql < infile.sql + cat infile.sql | mysql2sql -o outfile.sql + +But of course it simply can be:: + + mysql2sql - outfile.sql < infile.sql + cat infile.sql | mysql2sql - outfile.sql