Exporting files seems to go without problem but on trying to import these dump files I nearly always seem to get errors, if phpmyadmin dumps the data then why can't it import it without errors?
For example:
some table structure dumped from phpmyadmin:
Code: Select all
CREATE TABLE dst (
dst_id tinyint(4) unsigned NOT NULL auto_increment,
dst_string varchar(85) default NULL,
dst_start varchar(10) default NULL,
dst_end varchar(10) default NULL,
PRIMARY KEY (dst_id),
UNIQUE KEY id (dst_id),
KEY id_2 (dst_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;
INSERT INTO dst VALUES (2, 'Last Sunday in March - Last Sunday in October (Europe)', '-1/0/3', '-1/0/10');
INSERT INTO dst VALUES (1, 'First Sunday in April - Last Sunday in October (USA, Canada etc.)', '+1/0/4', '-1/0/10');
INSERT INTO dst VALUES (4, 'April 1 - Last Sunday in October (Cuba)', '1//4', '-1/0/10');
INSERT INTO dst VALUES (5, 'April 1 - October 1 (Syria, Iraq)', '1//4', '1//10');
INSERT INTO dst VALUES (6, 'First Friday in April - First Friday in September (Israel)', '+1/5/4', '+1/5/9');
INSERT INTO dst VALUES (7, 'Last Sunday in March - Last Sunday in September (Lebanon)', '-1/0/4', '-1/0/9');
INSERT INTO dst VALUES (8, 'First Friday on or after 5 April - First Friday on or after 5 October (Palestine)', '+5/5/4', '+5/5/10');
INSERT INTO dst VALUES (9, 'The first day of Farvardin - The first day of Mehr (Iran)', '21//4', '23//9');
INSERT INTO dst VALUES (10, 'Last Friday in April - Last Thursday in September (Egypt)', '-1/5/4', '-1/4/9');
INSERT INTO dst VALUES (11, 'First Sunday in October - Last Sunday in Februrary (Brazil)', '+1/0/10', '-1/0/2');
INSERT INTO dst VALUES (12, 'First Sunday on or after 9 October - First Sunday on or after 9 March (Chilie)', '+9/0/10', '+9/0/3');
INSERT INTO dst VALUES (13, 'First Sunday on or after 8 September - First Sunday on or after 6 April (Falklands)', '+8/0/9', '+8/0/4');
INSERT INTO dst VALUES (14, 'First Sunday in October - Last Saturday in February (Paraguay)', '+1/0/10', '-1/6/2');
INSERT INTO dst VALUES (15, 'First Sunday in September - First Sunday in April (Namibia)', '+1/0/9', '+1/0/4');
INSERT INTO dst VALUES (16, 'Last Sunday in October - Last Sunday in March (Australia)', '-1/0/10', '-1/0/3');
INSERT INTO dst VALUES (17, 'First Sunday in November - Last Sunday in February (Fiji)', '+1/0/11', '-1/0/2');
INSERT INTO dst VALUES (18, 'First Sunday in October - First Sunday on or after 5 March (New Zealand)', '+1/0/10', '+5/0/3');
INSERT INTO dst VALUES (19, 'First Sunday in October - First Sunday on or after 15 April (Tonga)', '+1/0/10', '+15/0/4');
INSERT INTO dst VALUES (20, 'First Sunday in October - Last Sunday in March (Tasmania)', '+1/0/10', '-1/0/3');MySQL said:
#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 'dst_id tinyint(4) unsigned NOT NULL auto_increment,
dst_string varchar(85) def' at line 2
I have tried adding backquotes to the data but it makes no difference.
Exports and imports are being done on the same version but on different servers: phpMyAdmin 2.6.0-pl3
Is there some secret on how to get myphpadmin exported dumps to import successfully?
Thanks
Mike