ANSI cotes problem

bogoda · 02-23-2006, 12:45 AM

hi,

When i am going to take backups in fedora 4 using Mysql administrator it gives an error call ANSI cotes not found.

How can i install it.

thank you.

timmeke · 02-23-2006, 04:13 AM

This can be related to a locale problem. locale's are comparable to regional settings (like language, etc).
If I'm not mistaken, there's also a locale for Ascii (ANSI) codes.
Try
locale -a
and post back what you find.

If you are going to take backups of your MySql database, why would you use the Mysql admin? Why not simply use
mysqldump instead? Dump the entire database to a text file, zip it and save the zip file in the safe location where you keep your backups.

bogoda · 02-23-2006, 08:29 PM

Hi,

How can i create backup using mysqldump and how can I restore it.

Thank u.

chrism01 · 02-23-2006, 11:11 PM

mysqldump -p<passwd> -u <user> <dbname> >somefile.sql
mysql <db_name> -p<passwd> -u <user> <somefile.sql
See link: http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html