diff options
Diffstat (limited to 'contrib/mysql/my2pg.html')
| -rwxr-xr-x | contrib/mysql/my2pg.html | 193 |
1 files changed, 0 insertions, 193 deletions
diff --git a/contrib/mysql/my2pg.html b/contrib/mysql/my2pg.html deleted file mode 100755 index 13704249aaa..00000000000 --- a/contrib/mysql/my2pg.html +++ /dev/null @@ -1,193 +0,0 @@ -<HTML> -<HEAD> -<TITLE>my2pg - MySQL -> PostgreSQL dump conversion utility.</TITLE> -<LINK REV="made" HREF="mailto:bhcompile@daffy.perf.redhat.com"> -</HEAD> - -<BODY> - -<A NAME="__index__"></A> -<!-- INDEX BEGIN --> - -<UL> - - <LI><A HREF="#name">NAME</A></LI> - <LI><A HREF="#syntax">SYNTAX</A></LI> - <LI><A HREF="#overview">OVERVIEW</A></LI> - <LI><A HREF="#commandline options">COMMAND-LINE OPTIONS</A></LI> - <LI><A HREF="#side effects">SIDE EFFECTS</A></LI> - <LI><A HREF="#bugs">BUGS</A></LI> - <LI><A HREF="#authors">AUTHORS</A></LI> - <LI><A HREF="#credits">CREDITS</A></LI> - <LI><A HREF="#license">LICENSE</A></LI> -</UL> -<!-- INDEX END --> - -<HR> -<P> -<H1><A NAME="name">NAME</A></H1> -<P>my2pg - MySQL -> PostgreSQL dump conversion utility.</P> -<P> -<HR> -<H1><A NAME="syntax">SYNTAX</A></H1> -<PRE> - mysqldump db | ./my2pg.pl [-nds] > pgsqldump.sql - vi libtypes.c - make - psql database < pgsqldump.txt -where</PRE> -<DL> -<DT><STRONG><A NAME="item_pgsqldump%2Esql"><EM>pgsqldump.sql</EM></A></STRONG><BR> -<DD> -- file suitable for loading into PostgreSQL. -<P></P> -<DT><STRONG><A NAME="item_libtypes%2Ec"><EM>libtypes.c</EM></A></STRONG><BR> -<DD> -- C source for emulated MySQL types (ENUM, SET) generated by <STRONG>my2pg</STRONG> -<P></P></DL> -<P> -<HR> -<H1><A NAME="overview">OVERVIEW</A></H1> -<P><STRONG>my2pg</STRONG> utility attempts to convert MySQL database dump to Postgres's one. -<STRONG>my2pg</STRONG> performs such conversions:</P> -<UL> -<LI><STRONG><A NAME="item_Type_conversion%2E">Type conversion.</A></STRONG><BR> - -It tries to find proper Postgres -type for each column. -Unknown types are silently pushing to output dump; -ENUM and SET types implemented via user types -(C source for such types can be found in -<STRONG>libtypes.c</STRONG> file); -<P></P> -<LI><STRONG><A NAME="item_Encloses_identifiers_into_double_quotes%2E">Encloses identifiers into double quotes.</A></STRONG><BR> - -All column and table -names should be enclosed to double-quotes to prevent -conflict with reserved SQL keywords; -<P></P> -<LI><STRONG><A NAME="item_Converting">Converting</A></STRONG><BR> - -AUTO_INCREMENT fields to SERIAL. Actually, creating the sequence and -setting default value to nextval('seq'), well, you know :) -<P></P> -<LI><STRONG>Converting</STRONG><BR> - -<CODE>KEY(field)</CODE> to CREATE INDEX i_field on table (field); -<P></P> -<LI><STRONG><A NAME="item_The_same">The same</A></STRONG><BR> - -for UNIQUE keys; -<P></P> -<LI><STRONG><A NAME="item_Indices">Indices</A></STRONG><BR> - -are creating AFTER rows insertion (to speed up the load); -<P></P> -<LI><STRONG><A NAME="item_Translates_%27%23%27">Translates '#'</A></STRONG><BR> - -MySQL comments to ANSI SQL '--' -<P></P></UL> -<P>It encloses dump in transaction block to prevent single errors -during data load.</P> -<P> -<HR> -<H1><A NAME="commandline options">COMMAND-LINE OPTIONS</A></H1> -<P>My2pg takes the following command-line options:</P> -<DL> -<DT><STRONG><A NAME="item_%2Dn">-n</A></STRONG><BR> -<DD> -Convert *CHAR DEFAULT '' NOT NULL types to *CHAR NULL. -Postgres can't load empty '' strings in NOT NULL fields. -<P></P> -<DT><STRONG><A NAME="item_%2Dd">-d</A></STRONG><BR> -<DD> -Add double quotes around table and column names -<P></P> -<DT><STRONG><A NAME="item_%2Dh">-h</A></STRONG><BR> -<DD> -Show usage banner. -<P></P> -<DT><STRONG><A NAME="item_%2Ds">-s</A></STRONG><BR> -<DD> -Do not attempt to convert data. Currently my2pg only tries to convert -date and time data. -<P></P></DL> -<P> -<HR> -<H1><A NAME="side effects">SIDE EFFECTS</A></H1> -<UL> -<LI><STRONG><A NAME="item_creates">creates</A></STRONG><BR> - -file <STRONG>libtypes.c</STRONG> in current directory -overwriting existed file without any checks; -<P></P> -<LI><STRONG><A NAME="item_the_same">the same</A></STRONG><BR> - -for Makefile. -<P></P></UL> -<P> -<HR> -<H1><A NAME="bugs">BUGS</A></H1> -<P>Known bugs are:</P> -<UL> -<LI><STRONG><A NAME="item_Possible_problems_with_the_timestamp_data%2E">Possible problems with the timestamp data.</A></STRONG><BR> - -PostgreSQL does not accept incorrect date/time values like <STRONG>2002-00-15</STRONG>, -while MySQL does not care about that. Currently my2pg cannot handle this -issue. You should care yourself to convert such a data. -<P></P> -<LI><STRONG><A NAME="item_Use_%2Ds_option_if_your_numeric_data_are_broken_du">Use -s option if your numeric data are broken during conversion.</A></STRONG><BR> - -My2pg attempts to convert MySQL timestamps of the form <STRONG>yyyymmdd</STRONG> to -<STRONG>yyyy-mm-dd</STRONG> and <STRONG>yyyymmddhhmmss</STRONG> to <STRONG>yyyy-mm-dd hh:mm:ss</STRONG>. It performs -some heuristic checks to ensure that the month,day,hour,minutes and seconds have -values from the correct range (0..12, 0..31, 0..23, 0..59, 0..59 respectively). -It is still possible that your numeric values that satisfy these conditions -will get broken. -<P></P> -<LI><STRONG><A NAME="item_Possible_problems_with_enclosing_identifiers_in_do">Possible problems with enclosing identifiers in double quotes.</A></STRONG><BR> - -All identifiers such as table and column names should be enclosed in double -quotes. Program can't handle upper-case identifiers, -like DBA. Lower-case identifiers are OK. -<P></P> -<LI><STRONG><A NAME="item_SET_type_emulation_is_not_full%2E_LIKE_operation_o">SET type emulation is not full. LIKE operation on</A></STRONG><BR> - -SETs, raw integer input values should be implemented -<P></P> -<LI><STRONG><A NAME="item_Makefile"><STRONG>Makefile</STRONG></A></STRONG><BR> - -generated during output is -platform-dependent and surely works only on -Linux/gcc (FreeBSD/gcc probably works as well - not tested) -<P></P> -<LI><STRONG><A NAME="item_Generated_libtypes%2Ec_contain_line">Generated <STRONG>libtypes.c</STRONG> contain line</A></STRONG><BR> - -<PRE> - #include <postgres.h></PRE> -<P>This file may be located not in standard compiler -include path, you need to check it before compiling.</P> -</UL> -<P> -<HR> -<H1><A NAME="authors">AUTHORS</A></H1> -<P><STRONG>(c) 2000-2002 Maxim V. Rudensky (<A HREF="mailto:fonin@omnistaronline.com">fonin@ziet.zhitomir.ua</A>)</STRONG> (developer, maintainer)</P> -<P><STRONG>(c) 2000 Valentine V. Danilchuk (<A HREF="mailto:valdan@ziet.zhitomir.ua">valdan@ziet.zhitomir.ua</A>)</STRONG> (original script)</P> -<P> -<HR> -<H1><A NAME="credits">CREDITS</A></H1> -<P>Great thanks to all those people who provided feedback and make development -of this tool easier.</P> -<P>Jeff Waugh <<A HREF="mailto:jaw@ic.net">jaw@ic.net</A>></P> -<P>Joakim Lemström <<A HREF="mailto:jocke@bytewize.com">jocke@bytewize.com</A>> || <<A HREF="mailto:buddyh19@hotmail.com">buddyh19@hotmail.com</A>></P> -<P>Yunliang Yu <<A HREF="mailto:yu@math.duke.edu">yu@math.duke.edu</A>></P> -<P>Brad Hilton <<A HREF="mailto:bhilton@vpop.net">bhilton@vpop.net</A>></P> -<P>If you are not listed here please write to me.</P> -<P> -<HR> -<H1><A NAME="license">LICENSE</A></H1> -<P><STRONG>BSD</STRONG></P> - -</BODY> - -</HTML> |