[Phpmyadmin-devel] split_sql_file produces sometimes wrong pieces

[Steve Alberty]

Hi,

db_readdump.php failes on the follow tabledump:

--snip--
CREATE TABLE Global (
  ID int(10) unsigned NOT NULL auto_increment,
  TSTAMP timestamp(14) NOT NULL,
  Keyname varchar(255) NOT NULL default '',
  Value mediumtext NOT NULL,
  Number int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY Keyname (Keyname)
) TYPE=MyISAM COMMENT='global memory';

INSERT INTO Global VALUES (209,20010731131330,'Matrix','(\'dadada\')',1);
INSERT INTO Global VALUES (210,20010731131330,'Matrix','dadada',2);
--snap--

mysql_die results:

Fehler in der Syntax bei '; INSERT INTO Global VALUES
(210,20010731131330,'Matrix','dadad' in Zeile 1.
                          ^ here is the problem.

if you remove the parenthesis in the second row, readdump has no problems.

The problem in split_sql_file is row 1480 which try to detect the last
')' char.

also you can see another problem here. db_readdump.php3 ignore the $lang
variable ...


Regards,

--
Steve