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
Error during TMyDump->Restore()
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;
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;