Hi,
Ok. thanx!
raymond
On Sat, 1 Aug 2009, Ruslan Zakirov wrote:
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, <raym...@pilotsupplies.com> 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, <raym...@pilotsupplies.com> 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, <raym...@pilotsupplies.com> 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, <raym...@pilotsupplies.com> 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: sa...@bestpractical.com
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
--
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: sa...@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
