Re: Problems with back up and restore mysql 5.0

2005-11-25 Thread Gleb Paharenko
Hello. >dump, it just cannot restore it back. Please provide exact actions which you're doing to restore a backup. "Sandeep Raul" <[EMAIL PROTECTED]> wrote: >Hi, > >Need your help in restoring mysqldump from version 4.1 to 5.0 > >We wanted to update our mysql server from version

Re: Problems with back up and restore mysql 5.0

2005-11-25 Thread Jacques Brignon
When under 5.0 you need to export your data doing a character set translation to latin1 or iso-8859-1. You also need to adjust the export for compatibilty with older versions (some SQL verbs used in 5.0 are not understood by older versions) Jacques Brignon You can do that either with mysqldump or