Hi

The following example gives me a problem. I create a new database by sending the following SQL commands:

create database dummy create table `Dummy Table` (`Dummy Time` timestamp(14) NOT NULL)

When i run mysqldump with the parameters shown below mysqldump -uroot -pxxxxxx -A -a -F -l --opt -rc:/mysql/data/dump.sql I will get a dump file which look like the following section:

//////////////////////////////////////////////////////////////////////////// ///////////////////////////// # MySQL dump 8.16 # # Host: localhost Database: #-------------------------------------------------------- # Server version 3.23.42-log

# # Current Database: dummy #

CREATE DATABASE /*!32312 IF NOT EXISTS*/ dummy;

USE dummy;

# # Table structure for table 'dummy table' #

DROP TABLE IF EXISTS `dummy table`; CREATE TABLE dummy table ( Dummy Time timestamp(14) NOT NULL ) TYPE=MyISAM;

# # Dumping data for table 'dummy table' #

LOCK TABLES `dummy table` WRITE; UNLOCK TABLES; //////////////////////////////////////////////////////////////////////////// /////////////////////////////

As you can see drop table uses the ` character around dummy table, but don't use it in the CREATE TABLE statement. The `character is also missing around the colum name Dummy Time.

These two things make it difficult for me to restore the database from the dump file so I hope someone has a solution.

PS: I am using the win32 version 3.23.42 (mysqld-opt.exe installed as a service on a Win2K platform). I have the following two lines in my.cnf which is at c:\ [mysqld] log-bin