Error during TMyDump->Restore()

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Thomas J.

Error during TMyDump->Restore()

Post by Thomas J. » Mon 08 Aug 2005 08:47

Hello all
I did a backup with TMyBackup. (Backup of a complete database).
A file of 50MB was created and I tried to restore the database with the Restore() method. Before I droped the database. In the database were also blobs (images, documents).
But the Restore method shows the error "Parser: The unknown symbol '' $0015". I don't know how to put the symbol in but it looks like a "T" turned by 180°.
I'm using the version
- MySQL Data Access Compnent V. 3.55.0.23
- C++ Builder 6
- MySQL Server 4.1.9
- Windows XP Service Pack2

Thanks for your help

Guest

Post by Guest » Mon 08 Aug 2005 09:07

Also this simple backupfile cannot be processed.

Error message "... check the manual corresponds to your MySQL... right syntax to use near '' at line 5."

-- MyDAC version: 3.55.0.23

-- MySQL server version: 4.1.9-nt

-- MySQL client version: 4.1.3 Direct

-- Script date 08.08.2005 11:04:10

-- ----------------------------------------------------------------------

-- Server: localhost

-- Database: test



--

-- Database test structure

--



USE mysql;

DROP DATABASE IF EXISTS test;

CREATE DATABASE test;

USE test;



--

-- User permissions

--



GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*547C5398BA7B81B1DE6C00F141F8FABD19263A03' WITH GRANT OPTION;

GRANT USAGE ON *.* TO 'cratemaker'@'%' IDENTIFIED BY PASSWORD '*80672D49EA6F705A55328427D5396C6B85650DB4';

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '*547C5398BA7B81B1DE6C00F141F8FABD19263A03' WITH GRANT OPTION;



--

-- Table structure for table t_test_1

--



DROP TABLE IF EXISTS t_test_1;

CREATE TABLE `t_test_1` (

`n_id` int(11) NOT NULL auto_increment,

`n_number` int(11) default NULL,

`c_charachter` varchar(45) default NULL,

PRIMARY KEY (`n_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;



--

-- Dumping data for table t_test_1

--



LOCK TABLES t_test_1 WRITE;

INSERT INTO t_test_1 VALUES

(1, 1, 'test_1'),

(2, 2, 'test_2'),

(3, 2, 'test_2');

UNLOCK TABLES;

Thomas J

Post by Thomas J » Mon 08 Aug 2005 15:20

Sorry, my fault by reading the file

Post Reply