MySQL import problems

3rd party extensions (phpDivingLog, dive computer downloader,...)
Post Reply
zeroGsa
Posts: 12
Joined: Fri Apr 23, 2010 13:25
Location: FL, USA
Contact:

MySQL import problems

Post by zeroGsa » Thu Apr 12, 2012 17:27

I am having difficulties getting my dives imported into MySQL for use with phpDivingLog 3.0. I run the export function in Diving Log 5.0, it completes, but when I look in phpDivingLog or even directly in MySQL, there's nothing there. I have exported it to a file and am able to see all of my dives in the resulting file.

I tried to manually import the file using phpMyAdmin and got the following error:

SQL query:

CREATE TABLE Brevets(
ID int( 11 ) AUTO_INCREMENT ,
Brevet varchar( 255 ) default '',
Org varchar( 255 ) default '',
CertDate date default NULL ,
Number varchar( 255 ) default '',
Instructor varchar( 255 ) default '',
InstructorNo varchar( 255 ) default '',
Scan1Path varchar( 255 ) default '',
Scan1 blob default NULL ,
Scan2Path varchar( 255 ) default '',
Scan2 blob default NULL ,
UUIDchar( 36 ) default '',
Updated date default NULL ,
SortOrd int( 11 ) default NULL ,
PRIMARY KEY ( ID )
) ENGINE = MYISAM DEFAULT CHARSET = ANSI;

MySQL said: Documentation
#1115 - Unknown character set: 'ANSI'

Any assistance would be greatly appreciated!

divinglog
Site Admin
Posts: 4698
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Re: MySQL import problems

Post by divinglog » Fri Apr 13, 2012 02:22

Either switch in the export settings to UFT-8 encoding, or select ANSI encoding during import in phpMyAdmin. Both encoding settings have to match, then it should work.

zeroGsa
Posts: 12
Joined: Fri Apr 23, 2010 13:25
Location: FL, USA
Contact:

Re: MySQL import problems

Post by zeroGsa » Fri Apr 13, 2012 10:56

I must have missed that in the Advanced Settings the first time. I changed the export to UTF-8 and it works now. Thank you!!

Post Reply