Can anybody explain me, why the sql-files I get, if I just open them with the editor, have (example) ü for ü inside? Ultraedit shows the files mostly correct, but if I reimport the files with copy paste from ultraedit into phpmyadmin, I get the wrong characters on the cms to, even it I fixed them in the cms, another reexport/import will kill them again. Please...might be a stupid mistake, but very important to get this done the right way...help me
I guess phpmyadmin exports the database dump with UTF-8 encoding, so you will have to reimport them with UTF-8 encoding too.
i still have original dumps from ispconfig that i would like to reimport over phpmyadmin...are these done with utf-8? and how would I reimport these with phpmyadmin then the right way...as I remember, just change the "session" in phpmyadmin to utf-8 was not working....or should this be the trick?
Have you tried localhost.localdomain then? You should check the Host column of the user table in the mysql database.
maybe I missed a part somewhere, the host-column is only including 84-16-251-18.internetserviceteam.com and localhost, both with user root, but not localhost.localdomain....would I have to add this somewhere or did I do something wrong then within the server-installation? hosts has got 127.0.0.1 localhost.localdomain localhost 84-16-251-18 bind 127.0.0.1 is excluded from my.cnf
...not shure, if I did this right...I added a new root-user for localhost.localdomain with phpmyadmin. However, how could I without makind dumps now...check if everything works...even connections from my home, if that's possible (if I connect with mysql-administrator and putty-tunnel it's saying, i'm not connecting from localhost (although it's localhost I put in) but that might be because of windows-admin connecting to linux-server?
You can check this on the commandline by useing the mysql command: mysql -u root -p and enter the mysql root user password. To quit the sql shell, enter "quit;".
that's working...do I need the localhost.localdomain root-user I added usually, or should I delete this one again? I guess my problem was I restarted MySQL over Services in ISPConfig, but this seemed not to restart the mysql-server! The only way to get a new my.cnf running is to do the restart from the console...is this normal?
Just leave it as it is now. Normally the restart from within ISPConfig works fine. ISPConfig uses the linux start / stop scripts to restart mysql.
