create database `test_of_xml_import`;

use `test_of_xml_import`;

create table `table1` (
  `id` int(11) not null,
  `text` text,
  primary key (`id`)
) engine=MyISAM default charset=latin1;

insert into `table1` values (1, 'line1\r\nline2\r\nline3');

--	In MySQL Query Browser you can see the line feeds. If you right click the text field and chose
--	"View Field in Popup Editor" you can also see how it looks on multi lines.
select * from `table1`;


--	How I dump database to XML:
--	"c:\Program Files\MySQL\MySQL Server 6.0\bin\mysqldump.exe" --xml -u root -p test_of_xml_import > test_of_xml_import.xml

-- How to load XML data into already existing structure.
-- XML file should be in the same directory.
"c:\Program Files\MySQL\MySQL Server 6.0\bin\mysql.exe" -D test_of_xml_import -uroot -p -e "load xml local infile 'test_of_xml_import.xml' into table table1"

-- When I load the data the \r\n (line feeds) gets removed, instead I get 3 white spaces.
-- Binary wise the text field looks like this, after load XML:
-- 6C 69 6e 65 31 20 20 20 6C 69 6E 65 32 20 20 20 6C 69 6E 65 33 

-- It should look like this (as it did when I inserted the line above):
-- 6C 69 6E 65 31 0D 0A 6C 69 6E 65 32 0D 0A 6C 69 6E 65 33