Welcome to WebmasterWorld Guest from 18.104.22.168
Forum Moderators: open
a) my intranet server
b) my webserver
After installing mysql 5.1 on my notebook testwise, I was faced with the problem of not being able to import dump-files (from my notebook) on any of both mysql 4 environments.
It seems I made a mistake with the default sort-charset (latin-swedish OMG;), but I cannot remember to have defined this anywhere in the installation process.
Imports from 4 to 5 work perfectly fine, but not vice versa.
What exactly is the background with this feature?
What do I have to take care for if I want to update on my webserver? Will I have to copy the database to a new 5.1 Version and then redefine access-parameters (password) in all scripts to that new updated database or is there any chance to tell my hoster "please now update my mysql-version and keep the databases"?
alter database [dbname] character set latin1, collate latin1;
This can also be done table by table.
Specifying Character Sets and Collations [dev.mysql.com]
Database Collation [dev.mysql.com]
Table Collation [dev.mysql.com]
Another problem I often encounter when changing versions, "Client does not support authentication protocol" when trying to connect with the same password. The encryption methods changed from one version to the next.
SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
Hope this was on the right track . . .