phpbar.de logo

Mailinglisten-Archive

PACK_KEYS ausschalten beim mysqldump? - klappt doch nicht

PACK_KEYS ausschalten beim mysqldump? - klappt doch nicht

Wim Bonis mysql-de_(at)_lists.bttr.org
Tue, 8 Jan 2002 12:10:00 +0100


) PACK_KEYS=1 TYPE=MyISAM;
> sprich, wenn ich das so mache, dann fehlt mir die ) und das ;
> 
> was könnte ich denn sonst machen?


Mysql bringt doch selbt das "replace" binary mit:

---cut---
>replace -I
replace  Ver 1.3 for pc-linux-gnu at i686
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

This program replace strings in a file or on stdin/stdout.
It accepts a list of from-strings and to-strings and replaces
all occurents of from-strings to to-strings.
The first occurents of a found string is matched. Longer matches
are prefered before shorter matches.

Special characters in from string:
  \^      Match start of line.
  \$      Match end of line.
  \b      Match space-character, start of line or end of line.
          For a end \b the next replace starts locking at the end
          space-character. A \b alone in a string matches only a
          space-character.

Usage: replace [-?svIV] from to from to ... -- [files]
or
Usage: replace [-?svIV] from to from to ... < fromfile > tofile

Options: -? or -I "Info"  -s "silent"      -v "verbose"
---cut---

also:

replace "PACK_KEYS=1" "" -- yourfile.sql

oder 

replace "\bPACK_KEYS=1\b" "PACK_KEYS=0" -- < in.sql >out.sql

You get the idea...


-------------------------------------------------------------------
Wim Bonis             ,+'^'+,                 Telefon:0631-31662-0
          Internet Solution Service GmbH      Technik:0631-31662-15
                       +,.,+                   privat:0631-36071-80
email: bonis_(at)_solution-service.de               67655 Kaiserslautern
Karl-Marx-Str. 13                           --== VIA-NETWoRKS KL ==-- 

---
Infos zur Mailingliste, zur Teilnahme und zum An- und Abmelden unter
-->>  http://www.4t2.com/mysql 



php::bar PHP Wiki   -   Listenarchive