Package: mysql-navigator
Version: 1.4.2-10
Severity: normal
Unable to import previously exported database/
### table created with the following ##############################
#CREATE TABLE tbl_junk (tbl_junk_id BIGINT not null primary key auto_increment);
#ALTER TABLE tbl_junk ADD mytxt VARCHAR(255) AFTER tbl_junk_id;
#ALTER TABLE tbl_junk ADD editdate TIMESTAMP AFTER mytxt;
#INSERT INTO tbl_junk (mytxt) VALUES ('abc123');
#
###### Below is the output from mysql_navigator export database
##############################
# MySQL Navigator Xport
# Database: bk_dev
# [EMAIL PROTECTED]
# CREATE DATABASE bk_dev;
# USE bk_dev;
#
# Table structure for table 'tbl_junk'
#
# DROP TABLE IF EXISTS tbl_junk;
CREATE TABLE `tbl_junk` (
`tbl_junk_id` bigint(20) NOT NULL auto_increment,
`mytxt` varchar(255) default NULL,
`editdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
PRIMARY KEY (`tbl_junk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
#
# Dumping data for table 'tbl_junk'
#
INSERT INTO tbl_junk VALUES (1,'abc123',2007-12-19 10:45:42);
###### End of the output from mysql_navigator export database
##############################
###### attempting database import with above opens a window ###########
####### with the following error message. #############################
You have an error in your SQL syntax; check the manual that corresponds to your
MySQL
server version for the right synatx to use near '10:45:42)'at line 1
##### End of error message #############################
The exported file only can be used with import database if I manually adding
single quotes around the
editdate field.
-- System Information:
Debian Release: lenny/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.22 (PREEMPT)
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)
Shell: /bin/sh linked to /bin/bash
Versions of packages mysql-navigator depends on:
ii libc6 2.7-3 GNU C Library: Shared libraries
ii libgcc1 1:4.2.2-3 GCC support library
ii libmysqlclient15off 5.0.45-1+lenny1 MySQL database client library
ii libqt3-mt 3:3.3.7-9 Qt GUI Library (Threaded runtime v
ii libstdc++6 4.2.2-3 The GNU Standard C++ Library v3
mysql-navigator recommends no packages.
-- no debconf information
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
