sql befehl einmal umkehren aber wie?

[marcus-gizmo]

gute morgen

ich würde gerne diesen sql befehl umgekehrt haben weiss aber nicht wie

DELETE FROM phpbb_config WHERE config_name = 'index_rebuild_position';
DELETE FROM phpbb_config WHERE config_name = 'index_rebuild_end_position';
DELETE FROM phpbb_config WHERE config_name = 'index_rebuild_postlimit';
INSERT IGNORE INTO phpbb_config (config_name, config_value) VALUES ('dbmtnc_rebuild_end', '0');
INSERT IGNORE INTO phpbb_config (config_name, config_value) VALUES ('dbmtnc_rebuild_pos', '-1');
INSERT IGNORE INTO phpbb_config (config_name, config_value) VALUES ('dbmtnc_rebuildcfg_maxmemory', '500');
INSERT IGNORE INTO phpbb_config (config_name, config_value) VALUES ('dbmtnc_rebuildcfg_minposts', '3');
INSERT IGNORE INTO phpbb_config (config_name, config_value) VALUES ('dbmtnc_rebuildcfg_php3only', '0');
INSERT IGNORE INTO phpbb_config (config_name, config_value) VALUES ('dbmtnc_rebuildcfg_php3pps', '1');
INSERT IGNORE INTO phpbb_config (config_name, config_value) VALUES ('dbmtnc_rebuildcfg_php4pps', '8');
INSERT IGNORE INTO phpbb_config (config_name, config_value) VALUES ('dbmtnc_rebuildcfg_timelimit', '240');
INSERT IGNORE INTO phpbb_config (config_name, config_value) VALUES ('dbmtnc_rebuildcfg_timeoverwrite', '0');
INSERT IGNORE INTO phpbb_config (config_name, config_value) VALUES ('dbmtnc_disallow_postcounter', '0');
INSERT IGNORE INTO phpbb_config (config_name, config_value) VALUES ('dbmtnc_disallow_rebuild', '0');

p.s.: hatte einen supporter gefragt dachte das es so klein ist wollte ich kein post damit verschwenden ich entschuldige mich nochmal sorry

[Dr.Death]

Hi,

ich war's

Aber was möchtest Du damit bezwecken ?

Sollen nur die vom DB Maintenance MOD gemachten Einträge gelöscht werden ?

Dann wäre dies die Lösung:

Code: Alles auswählen

DELETE FROM phpbb_config WHERE config_name = 'dbmtnc_rebuild_end'; 
DELETE FROM phpbb_config WHERE config_name = 'dbmtnc_rebuild_pos'; 
DELETE FROM phpbb_config WHERE config_name = 'dbmtnc_rebuildcfg_maxmemory'; 
DELETE FROM phpbb_config WHERE config_name = 'dbmtnc_rebuildcfg_minposts'; 
DELETE FROM phpbb_config WHERE config_name = 'dbmtnc_rebuildcfg_php3only'; 
DELETE FROM phpbb_config WHERE config_name = 'dbmtnc_rebuildcfg_php3pps'; 
DELETE FROM phpbb_config WHERE config_name = 'dbmtnc_rebuildcfg_php4pps'; 
DELETE FROM phpbb_config WHERE config_name = 'dbmtnc_rebuildcfg_timelimit'; 
DELETE FROM phpbb_config WHERE config_name = 'dbmtnc_rebuildcfg_timeoverwrite'; 
DELETE FROM phpbb_config WHERE config_name = 'dbmtnc_disallow_postcounter'; 
DELETE FROM phpbb_config WHERE config_name = 'dbmtnc_disallow_rebuild';

[marcus-gizmo]

möchte denn wieder ausbauen

aber da war doch das er vorher was gelöscht hat muss das nicht wieder rein?

[Dr.Death]

Nein, das muss nicht wieder rein, es gehörte auch dazu.

Ich an Deiner Stelle würde den DB Maintenance MOD drin lassen.
Er ist sehr hilfreich.