I didn't know you have mysql 4.0, on this version there is no such option. So your dmp is correct.
On Sat, Aug 1, 2009 at 2:13 AM, <[email protected]> wrote: > > Hi Ruslan, > > I finally got some time to export old server DB per your instruction using > binary set - > > mysqldump --opt --add-drop-table --single-transaction > --default-character-set=binary -u root -pXXXXXX -h localhost rt3 | gzip -c > > /var/www/db_bkp/RTNEW-RT3-$date.sql.gz > > > and got the following errors? How to fix? > > server is running mysql 4.022 on debian > > > ester:/var/dba/scripts# mysqldump: Character set 'binary' is not a compiled > character set and is not specified in the '/usr/share/mysql/charsets/Index' > file > > > > [1]+ Done ./backup_mysql.new > > > > > > > > On Wed, 29 Jul 2009, Ruslan Zakirov wrote: > >> On Wed, Jul 29, 2009 at 9:21 PM, <[email protected]> wrote: >>> >>> Hi, >>> >>> Thank you for the suggestion. >>> >>> I'll give that a shot. This is a migration from an old box running 3.2.2 >>> to >>> a new server which is rt 3.8.4 fresh install. Will I need to do "make >>> upgrade" as indicated in the 3.8.4 README file? >> >> Nope, you run `make install` instead of `make upgrade` as you have no >> RT files on new server. >> >>> I am exporting rt 3.2.2 db on old server and importing to the new server >>> running rt 3.8.4 >> >> Don't forget to using --default-charset=binary, both on export and >> import. Check exact syntax in mysql's docs. It's important or you can >> break every binary attachment. >> >>> >>> >>> mysql -u root -p rt3 < oldrt3.2.2.db.sql >> >> mysql --default-charset=binary -u root -p rt3 < oldrt3.2.2.db.sql >>> >>> >>> >>> raymond >>> >>> >>> >>> >>> >>> On Wed, 29 Jul 2009, Ruslan Zakirov wrote: >>> >>>> Then you missed one step. You have to upgrade DB first from 3.2.2 to >>>> 3.7.89 first. It's `rt-setup-database --action update ...` command >>>> described in more details in UPGRADING.mysql and README files. >>>> >>>> On Tue, Jul 28, 2009 at 11:39 PM, <[email protected]> wrote: >>>>> >>>>> Hi Ruslan, >>>>> >>>>> >>>>> My apologies. I was upgrading from 3.2.2 >>>>> >>>>> >>>>> raymond >>>>> >>>>> >>>>> >>>>> On Tue, 28 Jul 2009, Ruslan Zakirov wrote: >>>>> >>>>>> Why do you even need mysqlupgrade.sql if it's fresh install? >>>>>> >>>>>> On Tue, Jul 28, 2009 at 10:13 PM, <[email protected]> wrote: >>>>>>> >>>>>>> ubuntu vmware esx4i with ubuntu 9.04 4GB of memory dual xeon >>>>>>> processor >>>>>>> >>>>>>> fresh 3.8.4 install, apache2, perl_Mode 2, mysql 5 >>>>>>> >>>>>>> go error "Table 'rt3.ObjectCustomFields' doesn't exist" >>>>>>> >>>>>>> so I went and commented out the following, see below and proceed with >>>>>>> the >>>>>>> install with no other issues. >>>>>>> >>>>>>> Am wondering if there are any implications, issues or problems with >>>>>>> this >>>>>>> or is there a better way to fix this ? >>>>>>> >>>>>>> >>>>>>> thanx! >>>>>>> >>>>>>> >>>>>>> >>>>>>> /usr/local/src/rt-3.8.4/etc/upgrade# mysql -u root -p rt3 < >>>>>>> mysqlupgrade.sql >>>>>>> Enter password: >>>>>>> ERROR 1146 (42S02) at line 77: Table 'rt3.ObjectCustomFields' doesn't >>>>>>> exist >>>>>>> >>>>>>> >>>>>>> r...@joeblow:/usr/local/src/rt-3.8.4/etc/upgrade# vi mysqlupgrade.sql >>>>>>> >>>>>>> #ALTER TABLE ObjectCustomFields >>>>>>> # DEFAULT CHARACTER SET utf8; >>>>>>> #ALTER TABLE ObjectCustomFieldValues >>>>>>> # DEFAULT CHARACTER SET utf8; >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> >>>>>>> >>>>>>> >>>>>>> Regards, >>>>>>> >>>>>>> Raymond Wong >>>>>>> >>>>>>> >>>>>>> Personal motto: P.E.A.C.E >>>>>>> Enjoy the present >>>>>>> Assert your goals >>>>>>> Champion peace >>>>>>> Entrust others >>>>>>> _______________________________________________ >>>>>>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >>>>>>> >>>>>>> Community help: http://wiki.bestpractical.com >>>>>>> Commercial support: [email protected] >>>>>>> >>>>>>> >>>>>>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >>>>>>> Buy a copy at http://rtbook.bestpractical.com >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>>> -- >>>>> >>>>> >>>>> >>>>> Regards, >>>>> >>>>> Raymond Wong >>>>> >>>>> >>>>> Personal motto: P.E.A.C.E >>>>> Enjoy the present >>>>> Assert your goals >>>>> Champion peace >>>>> Entrust others >>>> >>>> >>>> >>>> >>> >>> -- >>> >>> >>> >>> Regards, >>> >>> Raymond Wong >>> >>> >>> Personal motto: P.E.A.C.E >>> Enjoy the present >>> Assert your goals >>> Champion peace >>> Entrust others >> >> >> >> > > -- > > > > Regards, > > Raymond Wong > > > Personal motto: P.E.A.C.E > Enjoy the present > Assert your goals > Champion peace > Entrust others -- Best regards, Ruslan. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
