Hello.
> It gives an error near some special chars (because the file is not >ANSI). Please, could you provide the error message. Check if it disappears if you perform the dump with --quote-names option. > The second question is related to "explain". Is there a "explain" >function for update as there is for "select"? An update statement is optimized like a SELECT query with the additional overhead of a write. So you can take the optimizer plan from the corresponding SELECT statement (with the same WHERE clause and table references). Octavian Rasnita wrote: > Hi, > > I have used mysqldump with 5.0.15-nt and I have seen that it saves the file > in UTF-8 format. > This is OK, but if I try to run: > > mysql database < saved_file.sql > > It gives an error near some special chars (because the file is not ANSI). > > If I convert the file as ANSI, I can import the data from it into MySQL > without problems. > > Am I doing something wrong? > > The second question is related to "explain". Is there a "explain" function > for update as there is for "select"? > > Thank you. > > Teddy > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
