MySQL Problems

[lloyd_borrett]

G'day Sven,

I can do a MySQL Dump just fine.

But when I try and import the following section from the dump into my MySQL database I get an arror.

Code: Select all

#
# Structure for table 'DBInfo'
#

DROP TABLE IF EXISTS DBInfo;
CREATE TABLE DBInfo (
  PrgName varchar(50) default '',
  DBVersion varchar(50) default '',
  LastBackup date default NULL,
  LastChange date default NULL,
) TYPE=MyISAM;

#
# Data for table 'DBInfo'
#

INSERT INTO DBInfo VALUES ('Diving Log', '4.0.0.4', NULL, NULL);

Error is...

Code: Select all

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near ') TYPE=MyISAM' at line 6

Any ideas as to what is causing this?

Best Regards, Lloyd Borrett.

[divinglog]

Hi Lloyd

Thanks for reporting this bug. You have until the next update 2 ways to fix it:

- Uncheck the table DBInfo in the export dialog of Diving Log (this table contains only some database informations for Diving Log itself)

- If you want the table exported you must open the dump file in an text editor and delete the last red comma here:

#
# Structure for table 'DBInfo'
#

DROP TABLE IF EXISTS DBInfo;
CREATE TABLE DBInfo (
PrgName varchar(50) default '',
DBVersion varchar(50) default '',
LastBackup date default NULL,
LastChange date default NULL, <-- Delete this comma

) TYPE=MyISAM;


Kind regards,
Sven

[lloyd_borrett]

Thanks Sven.