taking mysql-backups with ispconfig or phpmyadmin

Discussion in 'Installation/Configuration' started by schmidtedv, Apr 13, 2007.

  1. schmidtedv

    schmidtedv New Member

    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 :)
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    I guess phpmyadmin exports the database dump with UTF-8 encoding, so you will have to reimport them with UTF-8 encoding too.
     
  3. schmidtedv

    schmidtedv New Member

    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?
     
  4. falko

    falko Super Moderator ISPConfig Developer

  5. schmidtedv

    schmidtedv New Member

    Icouldn'T because mysql doesn't let my in over localhost...funny :)
     
  6. falko

    falko Super Moderator ISPConfig Developer

    Have you tried localhost.localdomain then?
    You should check the Host column of the user table in the mysql database.
     
  7. schmidtedv

    schmidtedv New Member

    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
     
  8. schmidtedv

    schmidtedv New Member

    ...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? :)
     
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    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;".
     
  10. schmidtedv

    schmidtedv New Member

    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?
     
  11. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     

Share This Page