[Typo3-windows] Backup

[Jesper Nielsen]

Thank you all for the ideas.

I have tried to make the batch-file, and run it, and it works fine.

But when I try to import it again from the typo3 install-tool, I get this:

You have an error in your SQL syntax near '; ' at line 25
You have an error in your SQL syntax near '; ' at line 8
You have an error in your SQL syntax near '; ' at line 1
You have an error in your SQL syntax near '; ' at line 32
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 7
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
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
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
....<snippet>

and so it continues...

The backup .sql file starts like this.

<snippet>

-- MySQL dump 9.08
--
-- Host: localhost    Database: typo3_dummy
---------------------------------------------------------
-- Server version 4.0.13-nt

--
-- Table structure for table 'be_groups'
--

CREATE TABLE be_groups (
  uid int(11) unsigned NOT NULL auto_increment,
  pid int(11) unsigned NOT NULL default '0',
  tstamp int(11) unsigned NOT NULL default '0',
  title varchar(20) NOT NULL default '',
  non_exclude_fields blob NOT NULL,
  db_mountpoints varchar(40) NOT NULL default '',
  pagetypes_select tinyblob NOT NULL,
  tables_select blob NOT NULL,
  tables_modify blob NOT NULL,
  crdate int(11) unsigned NOT NULL default '0',
  cruser_id int(11) unsigned NOT NULL default '0',
  groupMods tinyblob NOT NULL,
  file_mountpoints varchar(40) NOT NULL default '',
  hidden tinyint(3) unsigned NOT NULL default '0',
  inc_access_lists tinyint(3) unsigned NOT NULL default '0',
  description text NOT NULL,
  lockToDomain varchar(50) NOT NULL default '',
  deleted tinyint(3) unsigned NOT NULL default '0',
  TSconfig blob NOT NULL,
  subgroup tinyblob NOT NULL,
  hide_in_lists tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (uid),
  KEY parent (pid)
) TYPE=MyISAM;

<snippet>

If anyone would like to se the whole file, please write me.

I hope someone can help me - I'm beginning to grow mad with these problems.

Regards,

Jesper


"Jesper Nielsen" <scheuer at nybro.dk> skrev i en meddelelse
news:mailman.1058789210.1359.typo3-windows at lists.netfielders.de...
> How du you backup your typo3 when running on WindowsXP and IIS?
>
> Regards,
>
> Jesper
>
>