[Typo3-windows] Backup

[Jesper Nielsen]

FINALLY IT WORKED :-)

Thanks for all your help.

PS: Nige->How did you import from phpMyAdmin?

"nigel jackson" <nigelj at pobox.com> skrev i en meddelelse
news:mailman.1058965202.28002.typo3-windows at lists.netfielders.de...
> 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
>