Hi!
I try to use mysqldump to automatically copy my local mysql db to my provider. The problem is that the provider is using mysql 3 and on my computer I've got mysql 4. mysqldump will add commands like "CHARSET=latin1" to the dump, which the mysql server at my provider does not understand and regards as errors. is there any way to get mysqldump create dumps that mysql 3 understands?
below is the command I use:
mysqldump -u root xxx_db | mysql -h whatever.com -u xxxuser -pxxxpw -C xxx_db
Thanks,
Matthias