backup-restore problem
Posted by:
tsarinus
Date: May 08, 2005 12:58AM
hallo MySql friends..
I have a problem to restore my data on my local mysql-server.
i have made a upgrade from version 4.1.7 to mysql 4.1.11
My 4.1.7 was installed on c:\mysql, the upgrade changed this path to c:\program files\mysql. So i have to make a restore of all my data to this new path. (fortunally I have a backup). I'm using Mysqladministrator 1.0.14
Now it seems i have some problem's with this restore. i get alway's error 1064.
my mysql server is running. Just did some testing. i have create a new table test.testtable, when i make backup with mysql I get the message that the backup was finished successfully.When i try to restore this file i get the following message :
The mysql server returned this error :
Mysql error nr 1064 You have an error in your sql-syntax; Check the manual that con...
'testfield' int(10) unsigned NOT NULL auto increment
note :this message don't fit in the error window "con ... testfield ... is difficult to read)
Is this error in the sql-syntax generated by the msql-backup-tool ?
this is the backup-file:
SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT;
SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS;
SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION;
SET NAMES utf8;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test`;
USE `test`;
CREATE TABLE "testtable" (
"testfield" int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY ("testfield")
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT;
SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS;
SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
What wrong with this ?
Thanks for your help !
Subject
Views
Written By
Posted
backup-restore problem
4990
May 08, 2005 12:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.