Datenbank wiederherstellen

lima-city → Forum → Programmiersprachen → PHP, MySQL & .htaccess

Autor dieses Themas
alm

alm hat kostenlosen Webspace.

15:45, 28.4.2006
Hallo!

Ich benutze wbb2 und habe immer wieder Sicherungen der Datenbank gemacht..
diese wurden als .sql gespeichert!

Nun m?chte ich diese wiederherstellen!

Geht das?
Mfg Marcel
Diskutiere mit und stelle Fragen: Jetzt kostenlos anmelden!

lima-city: Gratis werbefreier Webspace für deine eigene Homepage
~~n********r~~

15:49, 28.4.2006
Geh in deine DB.
Jetzt klickst du auf SQl.
Dann klickst du auf durchsuchen und du w?hlst die Datei aus.
Jetzt wird deine DB wieder hergestellt.
Autor dieses Themas
alm

alm hat kostenlosen Webspace.

15:52, 28.4.2006
zitat:
maximal gr??e 2.048KB

Fuck!
Meins is 2,4 Mb gro?,was soll ich denn da jetzt machen?

Mfg Marcel

Beitrag ge?ndert am 28.04.2006 15:52 von alm
wilhelm

wilhelm hat kostenlosen Webspace.

16:48, 28.4.2006

zitat:
maximal gr??e 2.048KB

Fuck!
Meins is 2,4 Mb gro?,was soll ich denn da jetzt machen?

Mfg Marcel

Dann ?ffneste die Datei mit deinem Texteditor und kopierst die H?lfte und speicherst die in einer sql-datei (name.sql) ab. dann nimmst du den rest und speicherst ihn in einer anderen sql-datei ab. Nun l?dst du beide Dateinen nacheinander hoch.

(Achtung, die Datei musst du geschickt zwischen zwei Funktionen teilen.)
Autor dieses Themas
alm

alm hat kostenlosen Webspace.

16:51, 28.4.2006

zitat:
maximal gr??e 2.048KB

Fuck!
Meins is 2,4 Mb gro?,was soll ich denn da jetzt machen?

Mfg Marcel

Dann ?ffneste die Datei mit deinem Texteditor und kopierst die H?lfte und speicherst die in einer sql-datei (name.sql) ab. dann nimmst du den rest und speicherst ihn in einer anderen sql-datei ab. Nun l?dst du beide Dateinen nacheinander hoch.

(Achtung, die Datei musst du geschickt zwischen zwei Funktionen teilen.)

Danke! *freu*
nur wie erkenne ich,dass eine Funktion zu Ende is?
~~n********r~~

16:54, 28.4.2006
So

------------------------------------------------------------------------------
Tabelle:

dssdf
Autor dieses Themas
alm

alm hat kostenlosen Webspace.

17:02, 28.4.2006
H?h das scheck ich irgendwie nich!
IOch finde das da irgendwie gar ncih sowas in der art!
Das is voll dumm bzw ich...!
kannstes nich mal f?r bl?de erkl?ren?

17:09, 28.4.2006

H?h das scheck ich irgendwie nich!
IOch finde das da irgendwie gar ncih sowas in der art!
Das is voll dumm bzw ich...!
kannstes nich mal f?r bl?de erkl?ren?

Da m?sste so etwas stehen?

-- 
-- Daten f?r Tabelle `affiliate`
-- 

INSERT INTO `affiliate` VALUES (9, 9, '2003-01-15', '1', 'Tester', '1027 West Way', 'Greenville', 'SC', '29642', '840', 'local account');

-- --------------------------------------------------------

-- 
-- Tabellenstruktur f?r Tabelle `article_categories_link`
--

Autor dieses Themas

alm

alm hat kostenlosen Webspace.

17:12, 28.4.2006

# WoltLab Burning Board 2.3.4 Database Backup
# generated: 13.04.2006 10:26

CREATE TABLE abi_actions (
	action tinytext NOT NULL, 
	caption tinytext NOT NULL, 
	navi tinytext NOT NULL, 
	cat tinytext NOT NULL, 
	catname tinytext NOT NULL, 
	visible int(1) NOT NULL DEFAULT '0', 
	extra int(1) NOT NULL DEFAULT '0', 
	extra_descr tinytext NOT NULL, 
	navid int(1) NOT NULL DEFAULT '1', 
	ord int(1) NOT NULL DEFAULT '0'
);

INSERT INTO abi_actions VALUES ('index','Hauptseite','','none','','0','0','','1','0'),('login','Login','','none','','0','0','','1','0'),('logout','Logout','','none','','0','0','','1','0'),('news.show','News-?bersicht','Artikel zeigen','news','Newsmanagement','1','1','Mit Sonderrechten kann ein Benutzer auch die Artikel Anderer einsehen.','1','1'),('news.add','Newseintrag hinzuf?gen','Neuer Artikel','news','Newsmanagement','1','0','','1','1'),('news.edit','Newseintrag bearbeiten','','news','Newsmanagement','0','1','Sonderrechte erlauben einem Benutzer auch fremde Artikel zu l?schen.','1','1'),('news.copy','Artikel kopieren','','news','Newsmanagement','0','0','','1','0'),('news.replace','Suchen & Ersetzen','Suchen & Ersetzen','news','Newsmanagement','1','0','','1','1'),('news.del','Newseintrag l?schen','','news','Newsmanagement','0','1','Sonderrechte erlauben einem Benutzer auch fremde Artikel zu l?schen.','1','1'),('news.pub','News ver?ffentlichen','','news','Newsmanagement','0','1','Mit Sonderrechten lassen sich auch Artikel fremder Benutzer ver?ffentlichen.','1','1'),('news.unpub','News wiederrufen','','news','Newsmanagement','0','1','Mit Sonderrechten lassen sich auch Artikel fremder Benutzer zur?cknehmen.','1','1'),('news.pics','Bildmanager','Bildmanager','news','Newsmanagement','0','1','Sonderrechte erm?glichen auch das Umbenennen, Verschieben und L?schen von Bildern.','1','1'),('cat.show','Newskategorien-?bersicht','Kategorien','news','Newsmanagement','1','0','','1','1'),('cat.add','Newskategorie hinzuf?gen','','news','Newsmanagement','0','0','','1','1'),('cat.edit','Newskategorie bearbeiten','','news','Newsmanagement','0','0','','1','1'),('cat.del','Newskategorie l?schen','','news','Newsmanagement','0','0','','1','1'),('cat.clean','Newskategorie r?umen','','news','Newsmanagement','0','0','','1','1'),('com.show','Kommentar-?bersicht','Kommentare','news','Newsmanagement','1','0','','1','1'),('com.edit','Kommentar bearbeiten','','news','Newsmanagement','0','0','','1','1'),('com.del','Kommentar l?schen','','news','Newsmanagement','0','0','','1','1'),('com.block.show','Kommentar-Sperren ?bersicht','','news','Newsmanagement','0','0','','1','1'),('com.block.add','Kommentar-Sperre hinzuf?gen','','news','Newsmanagement','0','0','','1','1'),('com.block.del','Kommentar-Sperre aufheben','','news','Newsmanagement','0','0','','1','1'),('vote.show','Bewertungen-?bersicht','Bewertungen','news','Newsmanagement','1','0','','1','1'),('vote.del','Bewertung l?schen','','news','Newsmanagement','0','0','','1','1'),('news.source','Quellen','Quellen','news','Newsmanagement','1','1','Mit Sonderrechten lassen sich Quellen auch editieren und l?schen.','1','1'),('user.show','Benutzer-?bersicht','Benutzer zeigen','user','Userverwaltung','1','0','','1','2'),('user.profile','Benutzerprofil zeigen','','user','Userverwaltung','0','0','','1','2'),('user.add','Benutzer hinzuf?gen','Neuer Benutzer','user','Userverwaltung','1','0','','1','2'),('user.edit','Benutzer bearbeiten','','user','Userverwaltung','0','0','Seien Sie vorsichtig bei der Rechtevergabe. Mit dieser Funktion kann der Benutzer jeden beliebigen anderen Account ver?ndern!','1','2'),('user.del','Benutzer l?schen','','user','Userverwaltung','0','0','Seien Sie vorsichtig bei der Rechtevergabe. Mit dieser Funktion kann der Benutzer jeden beliebigen anderen Account l?schen!','1','2'),('user.group.show','Benutzergruppen-?bersicht','Benutzergruppen','user','Userverwaltung','1','0','','1','2'),('user.group.add','Benutzergruppe erstellen','','user','Userverwaltung','0','0','','1','2'),('user.group.edit','Benutzergruppe bearbeiten','','user','Userverwaltung','0','0','','1','2'),('user.group.del','Benutzergruppe l?schen','','user','Userverwaltung','0','0','','1','2'),('user.log','Protokoll einsehen','Protokoll','user','Userverwaltung','1','0','','1','2'),('pers.profile','Ihr Benutzerprofil','Benutzerprofil','pers','Personal','1','0','','1','3');


CREATE TABLE abi_block (
	id int(11) NOT NULL auto_increment, 
	type tinytext NOT NULL, 
	string tinytext NOT NULL, 
	endtime int(11) NOT NULL DEFAULT '0', 
	PRIMARY KEY (id)
);



CREATE TABLE abi_blockip (
	ip tinytext NOT NULL, 
	endtime int(11) NOT NULL DEFAULT '0'
);



CREATE TABLE abi_comment (
	id int(11) NOT NULL auto_increment, 
	newsid int(11) NOT NULL DEFAULT '0', 
	name tinytext NOT NULL, 
	feld1 tinytext NOT NULL, 
	feld2 tinytext NOT NULL, 
	feld3 tinytext NOT NULL, 
	feld4 tinytext NOT NULL, 
	feld5 tinytext NOT NULL, 
	text text NOT NULL, 
	time int(11) NOT NULL DEFAULT '0', 
	ip tinytext NOT NULL, 
	PRIMARY KEY (id)
);



CREATE TABLE abi_group (
	groupid int(11) NOT NULL auto_increment, 
	groupname tinytext NOT NULL, 
	grouprights text NOT NULL, 
	groupsprights text NOT NULL, 
	PRIMARY KEY (groupid)
);

INSERT INTO abi_group VALUES ('1','Chef-Administrator','global','');


CREATE TABLE abi_log (
	time tinytext NOT NULL, 
	userid tinytext NOT NULL, 
	action tinytext NOT NULL
);

INSERT INTO abi_log VALUES ('25-03-2006 18:57:05','1','&gt;&gt;&gt;&gt;&gt;&gt; LOGIN &gt;&gt;&gt;&gt;&gt;&gt;'),('25-03-2006 18:57:36','1','Kategorie ID #1 erstellt'),('25-03-2006 18:58:17','1','Artikel ID #1 erstellt'),('25-03-2006 18:58:20','1','Artikel ID #1 ver?ffentlicht'),('25-03-2006 19:02:21','1','&gt;&gt;&gt;&gt;&gt;&gt; LOGIN &gt;&gt;&gt;&gt;&gt;&gt;');


CREATE TABLE abi_news (
	id int(11) NOT NULL auto_increment, 
	catid int(11) NOT NULL DEFAULT '1', 
	userid int(11) NOT NULL DEFAULT '0', 
	ext_user tinytext NOT NULL, 
	ext_mail tinytext NOT NULL, 
	topic tinytext NOT NULL, 
	subtopic tinytext NOT NULL, 
	text mediumtext NOT NULL, 
	link1 text NOT NULL, 
	link2 text NOT NULL, 
	link3 text NOT NULL, 
	time int(11) NOT NULL DEFAULT '0', 
	pubtime int(11) NOT NULL DEFAULT '0', 
	endtime int(11) NOT NULL DEFAULT '0', 
	pin int(1) NOT NULL DEFAULT '0', 
	allowcoms int(1) NOT NULL DEFAULT '1', 
	allowvote int(1) NOT NULL DEFAULT '0', 
	hot int(1) NOT NULL DEFAULT '0', 
	counter int(11) NOT NULL DEFAULT '0', 
	PRIMARY KEY (id)
);

INSERT INTO abi_news VALUES ('1','1','1','','','test','asdsasd','saddsandsjandsajsndmdsjnmsd,mnsdksdmsdds\r\nasdasd\r\ndssda\r\n\r\nsdsd\r\nsda\r\ns\r\nsda','','','','1143309497','1143309500','0','0','1','1','0','15');


CREATE TABLE abi_newscat (
	id int(11) NOT NULL auto_increment, 
	name tinytext NOT NULL, 
	icon tinytext NOT NULL, 
	tfolder tinytext NOT NULL, 
	KEY id (id)
);

INSERT INTO abi_newscat VALUES ('1','test','','');


CREATE TABLE abi_source (
	id int(11) NOT NULL auto_increment, 
	name tinytext NOT NULL, 
	url tinytext NOT NULL, 
	text tinytext NOT NULL, 
	PRIMARY KEY (id)
);



CREATE TABLE abi_user (
	userid int(11) NOT NULL auto_increment, 
	username tinytext NOT NULL, 
	password tinytext NOT NULL, 
	email tinytext NOT NULL, 
	groupid int(3) NOT NULL DEFAULT '0', 
	active int(1) NOT NULL DEFAULT '1', 
	lastonline int(11) NOT NULL DEFAULT '0', 
	lastonline_temp int(11) NOT NULL DEFAULT '0', 
	PRIMARY KEY (userid)
);

INSERT INTO abi_user VALUES ('1','Marcel','79962648e0ed0d8db5963be35a42d74f','','1','1','1143309376','1143309893');


CREATE TABLE abi_votes (
	id int(11) NOT NULL auto_increment, 
	newsid int(11) NOT NULL DEFAULT '0', 
	vote int(2) NOT NULL DEFAULT '0', 
	ip tinytext NOT NULL, 
	time int(11) NOT NULL DEFAULT '0', 
	PRIMARY KEY (id)
);



CREATE TABLE bb1_access (
	boardid int(11) unsigned NOT NULL DEFAULT '0', 
	userid int(11) unsigned NOT NULL DEFAULT '0', 
	can_view_board tinyint(1) NOT NULL DEFAULT '-1', 
	can_enter_board tinyint(1) NOT NULL DEFAULT '-1', 
	can_read_thread tinyint(1) NOT NULL DEFAULT '-1', 
	can_start_topic tinyint(1) NOT NULL DEFAULT '-1', 
	can_reply_topic tinyint(1) NOT NULL DEFAULT '-1', 
	can_post_poll tinyint(1) NOT NULL DEFAULT '-1', 
	can_upload_attachments tinyint(1) NOT NULL DEFAULT '-1', 
	can_download_attachments tinyint(1) NOT NULL DEFAULT '-1', 
	can_post_without_moderation tinyint(1) NOT NULL DEFAULT '-1', 
	can_close_own_topic tinyint(1) NOT NULL DEFAULT '-1', 
	can_use_search tinyint(1) NOT NULL DEFAULT '-1', 
	can_vote_poll tinyint(1) NOT NULL DEFAULT '-1', 
	can_rate_thread tinyint(1) NOT NULL DEFAULT '-1', 
	can_del_own_post tinyint(1) NOT NULL DEFAULT '-1', 
	can_edit_own_post tinyint(1) NOT NULL DEFAULT '-1', 
	can_del_own_topic tinyint(1) NOT NULL DEFAULT '-1', 
	can_edit_own_topic tinyint(1) NOT NULL DEFAULT '-1', 
	can_move_own_topic tinyint(1) NOT NULL DEFAULT '-1', 
	can_use_post_html tinyint(1) NOT NULL DEFAULT '-1', 
	can_use_post_bbcode tinyint(1) NOT NULL DEFAULT '-1', 
	can_use_post_smilies tinyint(1) NOT NULL DEFAULT '-1', 
	can_use_post_icons tinyint(1) NOT NULL DEFAULT '-1', 
	can_use_post_images tinyint(1) NOT NULL DEFAULT '-1', 
	PRIMARY KEY (boardid, userid)
);



CREATE TABLE bb1_acpmenuitemgroups (
	itemgroupid smallint(5) unsigned NOT NULL auto_increment, 
	title varchar(255) NOT NULL, 
	condition text NOT NULL, 
	conditiontype enum('OR','AND') NOT NULL DEFAULT 'OR', 
	showorder smallint(5) unsigned NOT NULL DEFAULT '0', 
	acpmode tinyint(3) unsigned NOT NULL DEFAULT '0', 
	PRIMARY KEY (itemgroupid)
);

INSERT INTO bb1_acpmenuitemgroups VALUES ('1','board','a_can_boards_add;a_can_boards_edit;a_can_boards_del;a_can_boards_empty;a_can_boards_rights;a_can_boards_permissions;a_can_moderator_add;a_can_moderator_del;a_can_moderator_edit','OR','1','1'),('2','users','a_can_users_add;a_can_users_edit;a_can_users_delete;a_can_users_email;a_can_users_merge;a_can_users_access;a_can_users_other;a_can_users_activation','OR','2','1'),('3','threads','a_can_threads_mass_edit;a_can_threads_edit;a_can_threads_moderate;a_can_threads_moderate_posts','OR','3','1'),('4','group','a_can_groups_add;a_can_groups_edit;a_can_groups_edit_own;a_can_groups_del;a_can_groups_variablegroups_set_securitylevel;a_can_boards_permissions;a_can_users_email','OR','4','1'),('5','style','a_can_style_add;a_can_style_edit;a_can_style_del;a_can_style_export;a_can_style_import','OR','5','1'),('9','avatar','a_can_avatars_readfolder;a_can_avatars_edit;a_can_avatars_del;a_can_avatars_add','OR','9','1'),('10','ranks','a_can_ranks_add;a_can_ranks_edit;a_can_ranks_del','OR','10','2'),('6','designpack','a_can_designpack_add;a_can_designpack_edit;a_can_designpack_copy;a_can_designpack_del','OR','6','2'),('7','template','a_can_template_add;a_can_template_edit;a_can_template_copy;a_can_template_del;a_can_templatepack_add;a_can_templatepack_edit;a_can_templatepack_del;a_can_template_import;a_can_template_export;a_can_template_search;a_can_template_cache','OR','7','1'),('8','languagepack','a_can_languagepack_add;a_can_languagepack_edit;a_can_languagepack_del;a_can_languagepack_export;a_can_languagepack_import;a_can_languagepack_translate;a_can_languagepack_delitem;a_can_languagepack_additem;a_can_languagepack_addcategory;a_can_languagepack_delcategory;a_can_languagepack_search;a_can_languagepack_sync','OR','8','2'),('11','smilie','a_can_smilie_add;a_can_smilie_edit;a_can_smilie_del','OR','11','2'),('12','icon','a_can_icon_add;a_can_icon_edit;a_can_icon_del','OR','12','2'),('13','bbcodes','a_can_bbcodes_add;a_can_bbcodes_edit;a_can_bbcodes_del','OR','13','2'),('14','profilefield','a_can_profilefield_add;a_can_profilefield_edit;a_can_profilefield_del','OR','14','2'),('15','database','a_can_database_backup;a_can_database_query;a_can_database_extra','OR','15','1'),('16','other1','a_can_otherstuff_ranks;a_can_otherstuff_threads;a_can_otherstuff_reindex;a_can_otherstuff_delindex;a_can_otherstuff_userposts;a_can_memberslist;a_can_otherstuff_wordmatch;a_can_users_edit;a_can_users_email;a_can_otherstuff_thumbnails;a_can_otherstuff_pmcounters','OR','16','1'),('17','other2','','OR','17','1');


CREATE TABLE bb1_acpmenuitemgroupscount (
	userid int(11) unsigned NOT NULL DEFAULT '0', 
	itemgroupid smallint(5) unsigned NOT NULL DEFAULT '0', 
	count int(11) unsigned NOT NULL DEFAULT '0', 
	lastaccesstime int(11) unsigned NOT NULL DEFAULT '0', 
	PRIMARY KEY (userid, itemgroupid)
);



CREATE TABLE bb1_acpmenuitems (
	itemid smallint(5) unsigned NOT NULL auto_increment, 
	itemgroupid smallint(5) unsigned NOT NULL DEFAULT '0', 
	link varchar(255) NOT NULL, 
	languageitem varchar(255) NOT NULL, 
	linkformat varchar(20) NOT NULL, 
	condition varchar(255) NOT NULL, 
	conditiontype enum('OR','AND') NOT NULL DEFAULT 'OR', 
	showorder smallint(5) unsigned NOT NULL DEFAULT '0', 
	acpmode tinyint(3) unsigned NOT NULL DEFAULT '0', 
	PRIMARY KEY (itemid)
);

INSERT INTO bb1_acpmenuitems VALUES ('1','1','board.php?action=add','BOARD_ADD','','a_can_boards_add','OR','1','1'),('2','1','board.php?action=view','BOARD_EDIT','<b>%s</b>','a_can_boards_edit;a_can_boards_del;a_can_boards_empty;a_can_boards_rights;a_can_boards_permissions;a_can_moderator_add;a_can_moderator_del;a_can_moderator_edit','OR','2','1'),('3','2','users.php?action=add','USERS_ADD','','a_can_users_add','OR','1','2'),('4','2','users.php?action=find','USERS_FIND','<b>%s</b>','a_can_users_edit;a_can_users_delete;a_can_users_merge;a_can_users_access;a_can_users_other;a_can_users_activation','OR','2','1'),('5','2','users.php?action=email&amp;userid=all','USERS_EMAIL_ALL','','a_can_users_email','OR','3','2'),('6','2','users.php?action=rate','USERS_RESET_RATING','','a_can_users_other','OR','4','2'),('7','3','threads.php?action=spinning','THREADS_EDIT','<b>%s</b>','a_can_threads_edit','OR','1','1'),('8','3','threads.php?action=moderate','THREADS_MODERATE','','a_can_threads_moderate','OR','2','2'),('9','3','threads.php?action=moderateposts','THREADS_MODERATE_POST','','a_can_threads_moderate_posts','OR','3','2'),('10','4','group.php?action=add','GROUP_ADD','','a_can_groups_add','OR','1','2'),('11','4','group.php?action=view','GROUP_EDIT','<b>%s</b>','a_can_groups_edit;a_can_groups_edit_own;a_can_groups_del;a_can_groups_add;a_can_boards_permissions;a_can_users_email','OR','2','1'),('12','4','group.php?action=variablegroups_set_securitylevel','GROUP_SECURITYLEVEL','','a_can_groups_variablegroups_set_securitylevel','OR','3','2'),('13','5','style.php?action=add','STYLE_ADD','','a_can_style_add','OR','1','2'),('14','5','style.php?action=view','STYLE_EDIT','','a_can_style_edit;a_can_style_del;a_can_style_export','OR','2','2'),('15','5','style.php?action=import%2Fexport','STYLE_IMPORT_EXPORT','<b>%s</b>','a_can_style_import;a_can_style_export','OR','3','2'),('16','6','designpack.php?action=add','DESIGNPACK_ADD','','a_can_designpack_add','OR','1','2'),('17','6','designpack.php?action=view','DESIGNPACK_EDIT','<b>%s</b>','a_can_designpack_edit;a_can_designpack_copy;a_can_designpack_del','OR','2','2'),('18','7','template.php?action=add','TEMPLATE_ADD','','a_can_template_add','OR','1','2'),('19','7','template.php?action=view','TEMPLATE_EDIT','<b>%s</b>','a_can_template_add;a_can_template_edit;a_can_template_copy;a_can_template_del','OR','2','1'),('20','7','template.php?action=addpack','TEMPLATEPACK_ADD','','a_can_templatepack_add','OR','3','2'),('21','7','template.php?action=viewpack','TEMPLATEPACK_EDIT','','a_can_templatepack_edit;a_can_templatepack_del','OR','4','2'),('22','7','template.php?action=import%2Fexport','TEMPLATE_IMPORT_EXPORT','<b>%s</b>','a_can_template_import;a_can_template_export','OR','5','1'),('23','7','template.php?action=search','TEMPLATE_SEARCH_REPLACE','','a_can_template_search','OR','6','2'),('24','9','avatar.php?action=readfolder','AVATAR_READ','','a_can_avatars_readfolder','OR','1','2'),('25','9','avatar.php?action=add','AVATAR_ADD','','a_can_avatars_add','OR','2','2'),('26','9','avatar.php?action=view','AVATAR_EDIT','','a_can_avatars_edit;a_can_avatars_del','OR','3','2'),('27','10','ranks.php?action=add','RANKS_ADD','','a_can_ranks_add','OR','1','2'),('28','10','ranks.php?action=view','RANKS_EDIT','','a_can_ranks_edit;a_can_ranks_del','OR','2','2'),('29','11','smilie.php?action=add','SMILIE_ADD','','a_can_smilie_add','OR','1','2'),('30','11','smilie.php?action=view','SMILIE_EDIT','','a_can_smilie_edit;a_can_smilie_del','OR','2','2'),('31','12','icon.php?action=add','ICON_ADD','','a_can_icon_add','OR','1','2'),('32','12','icon.php?action=view',

sowas steht da zb!

Beitrag ge?ndert am 28.04.2006 17:13 von alm

bene1989

bene1989 hat kostenlosen Webspace.

17:53, 28.4.2006
Am besten du kopierst den ganzen Spa? und f?gst ihn ein. Du gehst bei phpmyadmin oben in der Leiste auf den Button "SQL". Und danach f?gst du den Spa? in die Textbox ein. Ich wei? jetzt nicht ob es dort auch so eine Begrenzung gibt. Musst du mal ausprobieren.
~~n********r~~
7:39, 29.4.2006
```
# WoltLab Burning Board 2.3.4 Database Backup
# generated: 13.04.2006 10:26

CREATE TABLE abi_actions (
	action tinytext NOT NULL, 
	caption tinytext NOT NULL, 
	navi tinytext NOT NULL, 
	cat tinytext NOT NULL, 
	catname tinytext NOT NULL, 
	visible int(1) NOT NULL DEFAULT '0', 
	extra int(1) NOT NULL DEFAULT '0', 
	extra_descr tinytext NOT NULL, 
	navid int(1) NOT NULL DEFAULT '1', 
	ord int(1) NOT NULL DEFAULT '0'
);

INSERT INTO abi_actions VALUES ('index','Hauptseite','','none','','0','0','','1','0'),('login','Login','','none','','0','0','','1','0'),('logout','Logout','','none','','0','0','','1','0'),('news.show','News-?bersicht','Artikel zeigen','news','Newsmanagement','1','1','Mit Sonderrechten kann ein Benutzer auch die Artikel Anderer einsehen.','1','1'),('news.add','Newseintrag hinzuf?gen','Neuer Artikel','news','Newsmanagement','1','0','','1','1'),('news.edit','Newseintrag bearbeiten','','news','Newsmanagement','0','1','Sonderrechte erlauben einem Benutzer auch fremde Artikel zu l?schen.','1','1'),('news.copy','Artikel kopieren','','news','Newsmanagement','0','0','','1','0'),('news.replace','Suchen & Ersetzen','Suchen & Ersetzen','news','Newsmanagement','1','0','','1','1'),('news.del','Newseintrag l?schen','','news','Newsmanagement','0','1','Sonderrechte erlauben einem Benutzer auch fremde Artikel zu l?schen.','1','1'),('news.pub','News ver?ffentlichen','','news','Newsmanagement','0','1','Mit Sonderrechten lassen sich auch Artikel fremder Benutzer ver?ffentlichen.','1','1'),('news.unpub','News wiederrufen','','news','Newsmanagement','0','1','Mit Sonderrechten lassen sich auch Artikel fremder Benutzer zur?cknehmen.','1','1'),('news.pics','Bildmanager','Bildmanager','news','Newsmanagement','0','1','Sonderrechte erm?glichen auch das Umbenennen, Verschieben und L?schen von Bildern.','1','1'),('cat.show','Newskategorien-?bersicht','Kategorien','news','Newsmanagement','1','0','','1','1'),('cat.add','Newskategorie hinzuf?gen','','news','Newsmanagement','0','0','','1','1'),('cat.edit','Newskategorie bearbeiten','','news','Newsmanagement','0','0','','1','1'),('cat.del','Newskategorie l?schen','','news','Newsmanagement','0','0','','1','1'),('cat.clean','Newskategorie r?umen','','news','Newsmanagement','0','0','','1','1'),('com.show','Kommentar-?bersicht','Kommentare','news','Newsmanagement','1','0','','1','1'),('com.edit','Kommentar bearbeiten','','news','Newsmanagement','0','0','','1','1'),('com.del','Kommentar l?schen','','news','Newsmanagement','0','0','','1','1'),('com.block.show','Kommentar-Sperren ?bersicht','','news','Newsmanagement','0','0','','1','1'),('com.block.add','Kommentar-Sperre hinzuf?gen','','news','Newsmanagement','0','0','','1','1'),('com.block.del','Kommentar-Sperre aufheben','','news','Newsmanagement','0','0','','1','1'),('vote.show','Bewertungen-?bersicht','Bewertungen','news','Newsmanagement','1','0','','1','1'),('vote.del','Bewertung l?schen','','news','Newsmanagement','0','0','','1','1'),('news.source','Quellen','Quellen','news','Newsmanagement','1','1','Mit Sonderrechten lassen sich Quellen auch editieren und l?schen.','1','1'),('user.show','Benutzer-?bersicht','Benutzer zeigen','user','Userverwaltung','1','0','','1','2'),('user.profile','Benutzerprofil zeigen','','user','Userverwaltung','0','0','','1','2'),('user.add','Benutzer hinzuf?gen','Neuer Benutzer','user','Userverwaltung','1','0','','1','2'),('user.edit','Benutzer bearbeiten','','user','Userverwaltung','0','0','Seien Sie vorsichtig bei der Rechtevergabe. Mit dieser Funktion kann der Benutzer jeden beliebigen anderen Account ver?ndern!','1','2'),('user.del','Benutzer l?schen','','user','Userverwaltung','0','0','Seien Sie vorsichtig bei der Rechtevergabe. Mit dieser Funktion kann der Benutzer jeden beliebigen anderen Account l?schen!','1','2'),('user.group.show','Benutzergruppen-?bersicht','Benutzergruppen','user','Userverwaltung','1','0','','1','2'),('user.group.add','Benutzergruppe erstellen','','user','Userverwaltung','0','0','','1','2'),('user.group.edit','Benutzergruppe bearbeiten','','user','Userverwaltung','0','0','','1','2'),('user.group.del','Benutzergruppe l?schen','','user','Userverwaltung','0','0','','1','2'),('user.log','Protokoll einsehen','Protokoll','user','Userverwaltung','1','0','','1','2'),('pers.profile','Ihr Benutzerprofil','Benutzerprofil','pers','Personal','1','0','','1','3');


CREATE TABLE abi_block (
	id int(11) NOT NULL auto_increment, 
	type tinytext NOT NULL, 
	string tinytext NOT NULL, 
	endtime int(11) NOT NULL DEFAULT '0', 
	PRIMARY KEY (id)
);



CREATE TABLE abi_blockip (
	ip tinytext NOT NULL, 
	endtime int(11) NOT NULL DEFAULT '0'
);



CREATE TABLE abi_comment (
	id int(11) NOT NULL auto_increment, 
	newsid int(11) NOT NULL DEFAULT '0', 
	name tinytext NOT NULL, 
	feld1 tinytext NOT NULL, 
	feld2 tinytext NOT NULL, 
	feld3 tinytext NOT NULL, 
	feld4 tinytext NOT NULL, 
	feld5 tinytext NOT NULL, 
	text text NOT NULL, 
	time int(11) NOT NULL DEFAULT '0', 
	ip tinytext NOT NULL, 
	PRIMARY KEY (id)
);



CREATE TABLE abi_group (
	groupid int(11) NOT NULL auto_increment, 
	groupname tinytext NOT NULL, 
	grouprights text NOT NULL, 
	groupsprights text NOT NULL, 
	PRIMARY KEY (groupid)
);

INSERT INTO abi_group VALUES ('1','Chef-Administrator','global','');


CREATE TABLE abi_log (
	time tinytext NOT NULL, 
	userid tinytext NOT NULL, 
	action tinytext NOT NULL
);

INSERT INTO abi_log VALUES ('25-03-2006 18:57:05','1','>>>>>> LOGIN >>>>>>'),('25-03-2006 18:57:36','1','Kategorie ID #1 erstellt'),('25-03-2006 18:58:17','1','Artikel ID #1 erstellt'),('25-03-2006 18:58:20','1','Artikel ID #1 ver?ffentlicht'),('25-03-2006 19:02:21','1','>>>>>> LOGIN >>>>>>');


CREATE TABLE abi_news (
	id int(11) NOT NULL auto_increment, 
	catid int(11) NOT NULL DEFAULT '1', 
	userid int(11) NOT NULL DEFAULT '0', 
	ext_user tinytext NOT NULL, 
	ext_mail tinytext NOT NULL, 
	topic tinytext NOT NULL, 
	subtopic tinytext NOT NULL, 
	text mediumtext NOT NULL, 
	link1 text NOT NULL, 
	link2 text NOT NULL, 
	link3 text NOT NULL, 
	time int(11) NOT NULL DEFAULT '0', 
	pubtime int(11) NOT NULL DEFAULT '0', 
	endtime int(11) NOT NULL DEFAULT '0', 
	pin int(1) NOT NULL DEFAULT '0', 
	allowcoms int(1) NOT NULL DEFAULT '1', 
	allowvote int(1) NOT NULL DEFAULT '0', 
	hot int(1) NOT NULL DEFAULT '0', 
	counter int(11) NOT NULL DEFAULT '0', 
	PRIMARY KEY (id)
);

INSERT INTO abi_news VALUES ('1','1','1','','','test','asdsasd','saddsandsjandsajsndmdsjnmsd,mnsdksdmsdds\r\nasdasd\r\ndssda\r\n\r\nsdsd\r\nsda\r\ns\r\nsda','','','','1143309497','1143309500','0','0','1','1','0','15');
```
[/quote
[qoute]
[/code]
CREATE TABLE abi_newscat (
id int(11) NOT NULL auto_increment,
name tinytext NOT NULL,
icon tinytext NOT NULL,
tfolder tinytext NOT NULL,
KEY id (id)
);

INSERT INTO abi_newscat VALUES ('1','test','','');

CREATE TABLE abi_source (
id int(11) NOT NULL auto_increment,
name tinytext NOT NULL,
url tinytext NOT NULL,
text tinytext NOT NULL,
PRIMARY KEY (id)
);

CREATE TABLE abi_user (
userid int(11) NOT NULL auto_increment,
username tinytext NOT NULL,
password tinytext NOT NULL,
email tinytext NOT NULL,
groupid int(3) NOT NULL DEFAULT '0',
active int(1) NOT NULL DEFAULT '1',
lastonline int(11) NOT NULL DEFAULT '0',
lastonline_temp int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (userid)
);

INSERT INTO abi_user VALUES ('1','Marcel','79962648e0ed0d8db5963be35a42d74f','','1','1','1143309376','1143309893');

CREATE TABLE abi_votes (
id int(11) NOT NULL auto_increment,
newsid int(11) NOT NULL DEFAULT '0',
vote int(2) NOT NULL DEFAULT '0',
ip tinytext NOT NULL,
time int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (id)
);

CREATE TABLE bb1_access (
boardid int(11) unsigned NOT NULL DEFAULT '0',
userid int(11) unsigned NOT NULL DEFAULT '0',
can_view_board tinyint(1) NOT NULL DEFAULT '-1',
can_enter_board tinyint(1) NOT NULL DEFAULT '-1',
can_read_thread tinyint(1) NOT NULL DEFAULT '-1',
can_start_topic tinyint(1) NOT NULL DEFAULT '-1',
can_reply_topic tinyint(1) NOT NULL DEFAULT '-1',
can_post_poll tinyint(1) NOT NULL DEFAULT '-1',
can_upload_attachments tinyint(1) NOT NULL DEFAULT '-1',
can_download_attachments tinyint(1) NOT NULL DEFAULT '-1',
can_post_without_moderation tinyint(1) NOT NULL DEFAULT '-1',
can_close_own_topic tinyint(1) NOT NULL DEFAULT '-1',
can_use_search tinyint(1) NOT NULL DEFAULT '-1',
can_vote_poll tinyint(1) NOT NULL DEFAULT '-1',
can_rate_thread tinyint(1) NOT NULL DEFAULT '-1',
can_del_own_post tinyint(1) NOT NULL DEFAULT '-1',
can_edit_own_post tinyint(1) NOT NULL DEFAULT '-1',
can_del_own_topic tinyint(1) NOT NULL DEFAULT '-1',
can_edit_own_topic tinyint(1) NOT NULL DEFAULT '-1',
can_move_own_topic tinyint(1) NOT NULL DEFAULT '-1',
can_use_post_html tinyint(1) NOT NULL DEFAULT '-1',
can_use_post_bbcode tinyint(1) NOT NULL DEFAULT '-1',
can_use_post_smilies tinyint(1) NOT NULL DEFAULT '-1',
can_use_post_icons tinyint(1) NOT NULL DEFAULT '-1',
can_use_post_images tinyint(1) NOT NULL DEFAULT '-1',
PRIMARY KEY (boardid, userid)
);

CREATE TABLE bb1_acpmenuitemgroups (
itemgroupid smallint(5) unsigned NOT NULL auto_increment,
title varchar(255) NOT NULL,
condition text NOT NULL,
conditiontype enum('OR','AND') NOT NULL DEFAULT 'OR',
showorder smallint(5) unsigned NOT NULL DEFAULT '0',
acpmode tinyint(3) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (itemgroupid)
);

INSERT INTO bb1_acpmenuitemgroups VALUES ('1','board','a_can_boards_add;a_can_boards_edit;a_can_boards_del;a_can_boards_empty;a_can_boards_rights;a_can_boards_permissions;a_can_moderator_add;a_can_moderator_del;a_can_moderator_edit','OR','1','1'),('2','users','a_can_users_add;a_can_users_edit;a_can_users_delete;a_can_users_email;a_can_users_merge;a_can_users_access;a_can_users_other;a_can_users_activation','OR','2','1'),('3','threads','a_can_threads_mass_edit;a_can_threads_edit;a_can_threads_moderate;a_can_threads_moderate_posts','OR','3','1'),('4','group','a_can_groups_add;a_can_groups_edit;a_can_groups_edit_own;a_can_groups_del;a_can_groups_variablegroups_set_securitylevel;a_can_boards_permissions;a_can_users_email','OR','4','1'),('5','style','a_can_style_add;a_can_style_edit;a_can_style_del;a_can_style_export;a_can_style_import','OR','5','1'),('9','avatar','a_can_avatars_readfolder;a_can_avatars_edit;a_can_avatars_del;a_can_avatars_add','OR','9','1'),('10','ranks','a_can_ranks_add;a_can_ranks_edit;a_can_ranks_del','OR','10','2'),('6','designpack','a_can_designpack_add;a_can_designpack_edit;a_can_designpack_copy;a_can_designpack_del','OR','6','2'),('7','template','a_can_template_add;a_can_template_edit;a_can_template_copy;a_can_template_del;a_can_templatepack_add;a_can_templatepack_edit;a_can_templatepack_del;a_can_template_import;a_can_template_export;a_can_template_search;a_can_template_cache','OR','7','1'),('8','languagepack','a_can_languagepack_add;a_can_languagepack_edit;a_can_languagepack_del;a_can_languagepack_export;a_can_languagepack_import;a_can_languagepack_translate;a_can_languagepack_delitem;a_can_languagepack_additem;a_can_languagepack_addcategory;a_can_languagepack_delcategory;a_can_languagepack_search;a_can_languagepack_sync','OR','8','2'),('11','smilie','a_can_smilie_add;a_can_smilie_edit;a_can_smilie_del','OR','11','2'),('12','icon','a_can_icon_add;a_can_icon_edit;a_can_icon_del','OR','12','2'),('13','bbcodes','a_can_bbcodes_add;a_can_bbcodes_edit;a_can_bbcodes_del','OR','13','2'),('14','profilefield','a_can_profilefield_add;a_can_profilefield_edit;a_can_profilefield_del','OR','14','2'),('15','database','a_can_database_backup;a_can_database_query;a_can_database_extra','OR','15','1'),('16','other1','a_can_otherstuff_ranks;a_can_otherstuff_threads;a_can_otherstuff_reindex;a_can_otherstuff_delindex;a_can_otherstuff_userposts;a_can_memberslist;a_can_otherstuff_wordmatch;a_can_users_edit;a_can_users_email;a_can_otherstuff_thumbnails;a_can_otherstuff_pmcounters','OR','16','1'),('17','other2','','OR','17','1');

CREATE TABLE bb1_acpmenuitemgroupscount (
userid int(11) unsigned NOT NULL DEFAULT '0',
itemgroupid smallint(5) unsigned NOT NULL DEFAULT '0',
count int(11) unsigned NOT NULL DEFAULT '0',
lastaccesstime int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (userid, itemgroupid)
);

CREATE TABLE bb1_acpmenuitems (
itemid smallint(5) unsigned NOT NULL auto_increment,
itemgroupid smallint(5) unsigned NOT NULL DEFAULT '0',
link varchar(255) NOT NULL,
languageitem varchar(255) NOT NULL,
linkformat varchar(20) NOT NULL,
condition varchar(255) NOT NULL,
conditiontype enum('OR','AND') NOT NULL DEFAULT 'OR',
showorder smallint(5) unsigned NOT NULL DEFAULT '0',
acpmode tinyint(3) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (itemid)
);

INSERT INTO bb1_acpmenuitems VALUES ('1','1','board.php?action=add','BOARD_ADD','','a_can_boards_add','OR','1','1'),('2','1','board.php?action=view','BOARD_EDIT','%s','a_can_boards_edit;a_can_boards_del;a_can_boards_empty;a_can_boards_rights;a_can_boards_permissions;a_can_moderator_add;a_can_moderator_del;a_can_moderator_edit','OR','2','1'),('3','2','users.php?action=add','USERS_ADD','','a_can_users_add','OR','1','2'),('4','2','users.php?action=find','USERS_FIND','%s','a_can_users_edit;a_can_users_delete;a_can_users_merge;a_can_users_access;a_can_users_other;a_can_users_activation','OR','2','1'),('5','2','users.php?action=email&userid=all','USERS_EMAIL_ALL','','a_can_users_email','OR','3','2'),('6','2','users.php?action=rate','USERS_RESET_RATING','','a_can_users_other','OR','4','2'),('7','3','threads.php?action=spinning','THREADS_EDIT','%s','a_can_threads_edit','OR','1','1'),('8','3','threads.php?action=moderate','THREADS_MODERATE','','a_can_threads_moderate','OR','2','2'),('9','3','threads.php?action=moderateposts','THREADS_MODERATE_POST','','a_can_threads_moderate_posts','OR','3','2'),('10','4','group.php?action=add','GROUP_ADD','','a_can_groups_add','OR','1','2'),('11','4','group.php?action=view','GROUP_EDIT','%s','a_can_groups_edit;a_can_groups_edit_own;a_can_groups_del;a_can_groups_add;a_can_boards_permissions;a_can_users_email','OR','2','1'),('12','4','group.php?action=variablegroups_set_securitylevel','GROUP_SECURITYLEVEL','','a_can_groups_variablegroups_set_securitylevel','OR','3','2'),('13','5','style.php?action=add','STYLE_ADD','','a_can_style_add','OR','1','2'),('14','5','style.php?action=view','STYLE_EDIT','','a_can_style_edit;a_can_style_del;a_can_style_export','OR','2','2'),('15','5','style.php?action=import%2Fexport','STYLE_IMPORT_EXPORT','%s','a_can_style_import;a_can_style_export','OR','3','2'),('16','6','designpack.php?action=add','DESIGNPACK_ADD','','a_can_designpack_add','OR','1','2'),('17','6','designpack.php?action=view','DESIGNPACK_EDIT','%s','a_can_designpack_edit;a_can_designpack_copy;a_can_designpack_del','OR','2','2'),('18','7','template.php?action=add','TEMPLATE_ADD','','a_can_template_add','OR','1','2'),('19','7','template.php?action=view','TEMPLATE_EDIT','%s','a_can_template_add;a_can_template_edit;a_can_template_copy;a_can_template_del','OR','2','1'),('20','7','template.php?action=addpack','TEMPLATEPACK_ADD','','a_can_templatepack_add','OR','3','2'),('21','7','template.php?action=viewpack','TEMPLATEPACK_EDIT','','a_can_templatepack_edit;a_can_templatepack_del','OR','4','2'),('22','7','template.php?action=import%2Fexport','TEMPLATE_IMPORT_EXPORT','%s','a_can_template_import;a_can_template_export','OR','5','1'),('23','7','template.php?action=search','TEMPLATE_SEARCH_REPLACE','','a_can_template_search','OR','6','2'),('24','9','avatar.php?action=readfolder','AVATAR_READ','','a_can_avatars_readfolder','OR','1','2'),('25','9','avatar.php?action=add','AVATAR_ADD','','a_can_avatars_add','OR','2','2'),('26','9','avatar.php?action=view','AVATAR_EDIT','','a_can_avatars_edit;a_can_avatars_del','OR','3','2'),('27','10','ranks.php?action=add','RANKS_ADD','','a_can_ranks_add','OR','1','2'),('28','10','ranks.php?action=view','RANKS_EDIT','','a_can_ranks_edit;a_can_ranks_del','OR','2','2'),('29','11','smilie.php?action=add','SMILIE_ADD','','a_can_smilie_add','OR','1','2'),('30','11','smilie.php?action=view','SMILIE_EDIT','','a_can_smilie_edit;a_can_smilie_del','OR','2','2'),('31','12','icon.php?action=add','ICON_ADD','','a_can_icon_add','OR','1','2'),('32','12','icon.php?action=view',
[/code]
So m?sste es gehen.
Du kannst ja jetzt genau sehen wo die beiden teile sind.
Autor dieses Themas
alm

alm hat kostenlosen Webspace.

11:42, 29.4.2006
hMM IRGENDWIE schecke ich das nich...!
Ginge das vll. das ich das mal irgendendeinem schciken k?nnte(also das sql dok.) und das der mir das dann teilen w?rde?

W?re echt hammer freundlich!
MFg Marcel!
Autor dieses Themas
alm

alm hat kostenlosen Webspace.

12:37, 29.4.2006
Hochhol..

SRy

is aber echt wichtig!
Diskutiere mit und stelle Fragen: Jetzt kostenlos anmelden!

lima-city: Gratis werbefreier Webspace für deine eigene Homepage

Dir gefällt dieses Thema?

Über lima-city

lima-city bietet dir kostenlosen und werbefreien Speicherplatz für Deine Homepage. Sofort anmelden und direkt loslegen mit Webspace, PHP, Datenbanken, günstigen Domains und einer tollen Community!

kostenloser Webspace werbefrei: lima-city

Datenbank wiederherstellen

lima-city → Forum → Programmiersprachen → PHP, MySQL & .htaccess

Dir gefällt dieses Thema?

Über lima-city

Login zum Webhosting ohne Werbung!