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

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 4.1.0 to

Problems with back up and restore mysql 5.0

2005-11-24 Thread Sandeep Raul
Hi, Need your help in restoring mysqldump from version 4.1 to 5.0 We wanted to update our mysql server from version 4.1.0 to version 5.0, we took the mysqldump and upgraded it to version 5.0. But, when we tried to restored the database dump, it just cannot restore it back. We searched on the

Problems with back up and restore mysql 5.0

2005-11-24 Thread Sandeep Raul
Hi, Need your help in restoring mysqldump from version 4.1 to 5.0 We wanted to update our mysql server from version 4.1.0 to version 5.0, we took the mysqldump and upgraded it to version 5.0. But, when we tried to restored the database dump, it just cannot restore it back. We searched on the

Problems with back up and restore mysql 5.0

2005-11-24 Thread Sandeep Raul
Hi, Need your help in restoring mysqldump from version 4.1 to 5.0 We wanted to update our mysql server from version 4.1.0 to version 5.0, we took the simple mysqldump and when we tried to restored the database dump, it just failed. There is no error as such. The execution of dump command