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