I am exchanging SQLyog backup files with another person, and my back up files hang and will not install on his mysql server.

Header from my SQLyog backup

/*
SQLyog Enterprise - MySQL GUI v6.14
MySQL - 5.0.45-community-nt : Database - naasf
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

create database if not exists `naasf`;

USE `naasf`;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

Header from friends backup file

/*
SQLyog - Free MySQL GUI v5.02
Host - 5.0.41-community-nt : Database - naasf
*********************************************************************
Server version : 5.0.41-community-nt
*/


create database if not exists `naasf`;

USE `naasf`;

SET FOREIGN_KEY_CHECKS=0;

Differences Noted


My backup files had mysql version comments in some of the lines (i.e. run on mysql version 4.0.014 or greater
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

His backup file has NO version comments. Why does his backup have no version comments.

Additionally, my backup file will not restore and hangs up on his computer with the following line

/*!50001 DROP VIEW IF EXISTS `viewracedetail` */;

Any idea why he would not be able to restore my backup file?

My backup file restores with no problem on my mysql server. I do note that I am using MySQL - 5.0.45-community-nt while he is using version Host - 5.0.41-community-nt. Could that be the problem?

Thanks

Frank

1)
There should not be any issues with MySQL servers 5.0.41/5.0.45! But I cannot guarantee that there is no bug in 5.0.41, of course!

2)
"Why does his backup have no version comments." Because we did not use this in 5.02 yet

3)
version 5 is an ANSI program, version 6 is a UNICODE program. In version 6 we
/*!40101 SET NAMES utf8 */;
.. and encode the dump using UFT8, so if the server has utf8 as default charset, the DUMP from a SQLyog5 will not restore special characters correctly. However after adding
/*!40101 SET NAMES latin1 */;
on top of it it should!

4)
This is strange
"Additionally, my backup file will not restore and hangs up on his computer with the following line
/*!50001 DROP VIEW IF EXISTS `viewracedetail` */;"
.. if he executes that statment manually what happens? One important detail is that if his server was installed 'on top' of a 4.x version he will have to execute the 'mysql_upgrade' program to update system tables (running the installer alone will not do! Refer to MySQL documentation on how to upgrade the server)


Also please observe that we *in priciple* support only latest stable version. *in practice* we are more flexible, but 5.02 is 3 years old now and that is very long time in software industry! But anyway the most serious problem here is 4) I think, and I doubt that is a SQLyog problem! You can try executing the statement with command line client or whatever!