Hello.
Yes, you should specify all necassary options
(database, login, -p switch for password).
"Roberto Jobet" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Thanks for your help.
>
> Usually to export and import dump files I=
> use phpmyadmin, so I'm not very much
> familiar with the my
Hi,
Thanks for your help.
Usually to export and import dump files I use phpmyadmin, so I'm not very much
familiar with the mysqldump command-line utility :-))
In the command line that you specify below, do I have to indicate the db name ?
Thanks in advance
Regards
Roberto Jobet
> Hello.
>
>
Hello.
If you're sure that data in your dump file is in latin1 character
set, you could perform something like:
mysql --default-character-set=latin1 < dump_file
"Roberto Jobet" <[EMAIL PROTECTED]> wrote:
> Hi,
>
>
>> Hello.
>>
>>
>> Check the character sets with the fol
Hi,
> Hello.
>
>
> Check the character sets with the following statement:
> show variables like '%char%';
Here's the output:
character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_results utf8
character_set_server latin1
character_set_system utf8
c
Hello.
> Regarding --default-ch aracter-set command in chapter 10 is written that a
>way to change settings is to recompile...
> Is there another less painful way to do this ?
You may specify default character sets using options when you start
mysqld. See:
http://dev.mysql.com/doc/mys
Hi,
Thanks for your reply.
What do you mean by "right character set" ?
The default character set for ver. 4.1 is latin1, right ? This set should
support all western european languages !
Regarding --default-character-set command in chapter 10 is written that a way to
change settings is to recompi
Hello.
Specify the right character set with --default-character-set command
line option for mysql (if you're using it for reading dump). Chapter 10
of the manual could be helpful. See:
http://dev.mysql.com/doc/mysql/en/charset.html
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
>
Hi,
I'm trying to import a db dump made on ver. 4.0, on a new 4.1 version.
All accented characters (french, spanish) are replaced by a '?'
What it's the right way to import it ?
Thanks in advance
Roberto Jobet
Navighi a 4 MEGA e