Antwort #20 am: 27. September 2009, 09:08:19
Wart ihr auch alle schön wählen? Wenn nicht gibt es haue. So mancher Pirat braucht Unterstützung.
Zur Datenbank:
Also der Header ist so ok - prima, aber die Sicherung ist um 10MB größer als normal.
Bei mir macht das Backup nun ca. 30 MB aus. Im Normalfall sind es nach 19MB.
Das liegt daran, dass die SQL Anweisungen vor jeder Zeile stehen. Das braucht auf keinen Fall und ist nur Overhead.
Hier von phpMyAdmin:
---- Tabellenstruktur für Tabelle
-- DROP TABLE
IF EXISTS
;CREATE TABLE
IF NOT EXISTS
( int
(11) NOT
NULL auto_increment
, int
(11) NOT
NULL default '0', char
(1) collate latin1_german2_ci NOT
NULL, varchar
(64) collate latin1_german2_ci
default NULL, varchar
(32) collate latin1_german2_ci NOT
NULL, varchar
(32) collate latin1_german2_ci NOT
NULL, varchar
(64) collate latin1_german2_ci NOT
NULL, varchar
(32) collate latin1_german2_ci
default NULL, varchar
(10) collate latin1_german2_ci NOT
NULL, varchar
(32) collate latin1_german2_ci NOT
NULL, varchar
(32) collate latin1_german2_ci
default NULL, int
(11) NOT
NULL default '0', int
(11) NOT
NULL default '0', datetime
default '0000-00-00 00:00:00', datetime
default '0000-00-00 00:00:00', int
(11) NOT
NULL default '0', int
(11) NOT
NULL default '0', varchar
(10) collate latin1_german2_ci NOT
NULL, PRIMARY
KEY (), KEY (), KEY (), KEY ()) ENGINE
=MyISAM
DEFAULT CHARSET
=latin1 COLLATE
=latin1_german2_ci AUTO_INCREMENT
=1359 ;---- Daten für Tabelle
-- INSERT INTO
(, , , , , , , , , , , , , , , , , ) VALUES
(1, 124, 'm', 'XXXXXXX', 'XXXX', 'XXXX', 'XXXXXXX', NULL, 'XXXXX', 'XXXXXX', NULL, 81, 0, '2008-11-11 19:06:46', '2009-09-20 03:02:48', 0, 0, ''),(2, 152, 'm', 'XXXXXXX', 'XXXX', 'XXXX', 'XXXXXXX', NULL, 'XXXXX', 'XXXXXX', NULL, 81, 0, '2008-11-11 19:06:46', '2009-09-20 03:02:48', 0, 0, ''),(3, 144, 'm', 'XXXXXXX', 'XXXX', 'XXXX', 'XXXXXXX', NULL, 'XXXXX', 'XXXXXX', NULL, 81, 0, '2008-11-11 19:06:46', '2009-09-20 03:02:48', 0, 0, ''),etc
. und hier von deiner Version:
drop table
if exists address_book
;CREATE TABLE
( int
(11) NOT
NULL AUTO_INCREMENT
, int
(11) NOT
NULL DEFAULT '0', char
(1) COLLATE latin1_german2_ci NOT
NULL, varchar
(64) COLLATE latin1_german2_ci
DEFAULT NULL, varchar
(32) COLLATE latin1_german2_ci NOT
NULL, varchar
(32) COLLATE latin1_german2_ci NOT
NULL, varchar
(64) COLLATE latin1_german2_ci NOT
NULL, varchar
(32) COLLATE latin1_german2_ci
DEFAULT NULL, varchar
(10) COLLATE latin1_german2_ci NOT
NULL, varchar
(32) COLLATE latin1_german2_ci NOT
NULL, varchar
(32) COLLATE latin1_german2_ci
DEFAULT NULL, int
(11) NOT
NULL DEFAULT '0', int
(11) NOT
NULL DEFAULT '0', datetime
DEFAULT '0000-00-00 00:00:00', datetime
DEFAULT '0000-00-00 00:00:00', int
(11) NOT
NULL DEFAULT '0', int
(11) NOT
NULL DEFAULT '0', varchar
(10) COLLATE latin1_german2_ci NOT
NULL, PRIMARY
KEY (), KEY (), KEY (), KEY ()) ENGINE
=MyISAM AUTO_INCREMENT
=1359 DEFAULT CHARSET
=latin1 COLLATE
=latin1_german2_ci
;insert into address_book
(address_book_id
, customers_id
, entry_gender
, entry_company
, entry_firstname
, entry_lastname
, entry_street_address
, entry_suburb
, entry_postcode
, entry_city
, entry_state
, entry_country_id
, entry_zone_id
, address_date_added
, address_last_modified
, address_book_int_id
, address_book_int_ansnr
, entry_gesell
) values
('1', '124', 'm', etc
.insert into address_book
(address_book_id
, customers_id
, entry_gender
, entry_company
, entry_firstname
, entry_lastname
, entry_street_address
, entry_suburb
, entry_postcode
, entry_city
, entry_state
, entry_country_id
, entry_zone_id
, address_date_added
, address_last_modified
, address_book_int_id
, address_book_int_ansnr
, entry_gesell
) values
('3', '122', 'm', etc
.insert into address_book
(address_book_id
, customers_id
, entry_gender
, entry_company
, entry_firstname
, entry_lastname
, entry_street_address
, entry_suburb
, entry_postcode
, entry_city
, entry_state
, entry_country_id
, entry_zone_id
, address_date_added
, address_last_modified
, address_book_int_id
, address_book_int_ansnr
, entry_gesell
) values
('5', '85', 'm', 'etc.
insert into address_book (address
Die Werte habe ich gelöscht und mit etc. ersetzt.
Du siehst also vor jeder Datenzeile steht der insert into.....
Das sollte weg und wie oben in der phpMyAdmin aussehen.
Deine Version produziert eine so großes Backup, das ich dies mit Schwierigkeiten zurückgespielt bekomme. Zieht die Maschine sehr nach unten.