[Typo3-windows] Backup

[nigel jackson]

Quoting nigel jackson <nigelj at pobox.com>:

> Below is my mail and a reply from May...my guess is that it's the same
> problem.
> 
> I used phpmyadmin to import the sql file without any problems.
> 
> Nige
& here's the old mail I said I'd include!...

Hi Nigel,

a long time ago you wrote:


>> just tried to install a version 35 dummy site...when I tried to import the
>> static data, I got 532 lines of errors like this...


>> You have an error in your SQL syntax near '; ' at line 1
>> You have an error in your SQL syntax near '; ' at line 14
>> You have an error in your SQL syntax near '; ' at line 1
>> You have an error in your SQL syntax near '; ' at line 1
>> You have an error in your SQL syntax near '; ' at line 1
>> You have an error in your SQL syntax near '; ' at line 1
>> You have an error in your SQL syntax near '; ' at line 1


>> Then I decided to try installing a version 3.5b5 site, and upgrade it...the
>> install was fine, but when upgrading the same errors occurred.


>> I have already updated another site without any problems, so I'm at a bit of
>> a loss...has anyone else had any problems?


Now that problem also occured to me and I found out what it was:
Some of the sql-files which contain the static data were obviously
saved as a dos ascii file when the package was made (so it's not
your fault). They contain DOS line breaks which generate these
MySQL errors.

If you have ssh access to your server you can use the dos2unix tool
to convert these files (it's part of the sysutils). If you don't, just open
the .sql files in an editor like UltraEdit, convert them to UNIX mode
and save them on your server.

You'll have to all files called: "ext_tables_static+adt.sql".

All packagers should check their ext_tables_static+adt.sql files on
having UNIX linebreaks!

Good luck!,

-- robert _______________________________________________ Typo3-english mailing 
list Typo3-english at lists.netfielders.de http://lists.netfielders.de/cgi-
bin/mailman/listinfo/typo3-english