nappedeptrole

welcome to my space

01/09/2009 (7:36 am)

mysqldump operation for MySQL4.1.13

Filed under: nappedeptrole.com edit
  • hello,

    whats the best way mysqldump operation for mysql4.1.13 version?

    i use currently;

    mysqldump -u dbusername -p databasename > /path/backup.sql

    is this correct?

    thanks for advice


  • also when i importing database via ssh, turkish characters does not show correctly like: üğşçı

    my previous hosting provider uses mysql4.0-standard and all charsets showing fine.

    But new provider uses Mysql4.1.13 and when i import database characters showing bad, how to import correctly?

    example;

    mysql4.0-standard output;

    paylaşmalarıdır (this is correct)

    mysql4.1.13 output;

    paylaþmalarýdýr (this is bad)

    how to fix this problem?


  • i found the problem post #2.

    i've put --default-character-set=latin1 option for mysqldump, characters showing fine.

    also ignore in this thread post #1, command correct for 1.4.13 version and both --opt , -Q options comes default by 1.4.13 series.

    thanks.







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about mysqldump operation for MySQL4.1.13 , Please add it free.