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 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 you can give me some advise.



Best regards,
RTX Telecom A/S
Benny B. Simonsen
BB/Project Engineer
System Development
RTX Telecom A/S
Stroemmen 6
DK-9400 Noerresundby.
Phone.: +45 96 32 23 00
Fax.: +45 96 32 23 10
E-mail: [EMAIL PROTECTED]
Web: www.rtx.dk


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






---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to