phpBB Sverige

phpBB-support, snack och diskussioner på svenska
https://phpbb.se/forum/

Hur delar jag backup filen

https://phpbb.se/forum/viewtopic.php?t=5479

Sida 2 av 4

Re: Hur delar jag backup filen

Postat: 2008-05-28 16:35
av Bernstig
verkade fungera till viss del..... allt utom själv inläggen och användana följde med :evil: dock står det antal inlägg i dom olika delarna.

Re: Hur delar jag backup filen

Postat: 2008-05-28 16:38
av Holger
Låt dumpern köra valda tabeller (phpbb_users och phpbb_posts/phpbb_posts_text)

Re: Hur delar jag backup filen

Postat: 2008-05-28 20:04
av Bernstig
Holger skrev:Låt dumpern köra valda tabeller (phpbb_users och phpbb_posts/phpbb_posts_text)
hur gör jag det? är helt ny på detta.

Re: Hur delar jag backup filen

Postat: 2008-05-28 21:30
av Holger
Jag tror det heter "Choose tables to restore"

Re: Hur delar jag backup filen

Postat: 2008-05-29 12:01
av Bernstig
provade att ladda upp 800mb backupen och köra den igenom mysqldumper och det funkade :o

Men när man loggar in så hänvisar den vidare till det gamla forumet, gick in i phpbb_config och ändrade adressen men då klagar den på att språk paketet fattas, ja ja bara att installera om phpbb2 med swe språk och börja om :wink:

Tack för all hjälp, kommer särkerligen med fler frågor

Re: Hur delar jag backup filen

Postat: 2008-05-29 12:39
av Marcus
Härligt att det löste sig.

Re: Hur delar jag backup filen

Postat: 2008-05-29 12:54
av Holger
Jamen, löste det sig verkligen då? Hade du kvar all data?

Re: Hur delar jag backup filen

Postat: 2008-05-29 13:14
av Bernstig
Holger skrev:Jamen, löste det sig verkligen då? Hade du kvar all data?
vet inte riktigt än... håller på att köra in backupen igen, men den vissade att databasen var på 350mb samma som orginal forumet visar dock varför det blir 800mb när jag plockar ut den vet jag inte.

Återkommer när backupen är färdig.

Re: Hur delar jag backup filen

Postat: 2008-05-29 13:24
av Holger
Den blir större eftersom den innehåller alla SQL-kommandon.

Re: Hur delar jag backup filen

Postat: 2008-05-29 13:56
av Bernstig
Holger skrev:Den blir större eftersom den innehåller alla SQL-kommandon.
okej då har man lärt sig något nytt :D

Re: Hur delar jag backup filen

Postat: 2008-05-29 14:51
av Bernstig
nu är backupen klar men när jag loggar in står det forumet är låst och jag kommer ingenstans, annas verkar allt funka utom bilderna men det är väl fel adress till dom.

Re: Hur delar jag backup filen

Postat: 2008-05-29 14:59
av Holger
Har du ändrat all information i phpbb_config tabellen?

Re: Hur delar jag backup filen

Postat: 2008-05-29 15:03
av Bernstig
Holger skrev:Har du ändrat all information i phpbb_config tabellen?
Plockade ut phpbb_config med hjälp av phpmyadmin och ändrade där det stog den gammla forums adressen och la in den nya och nu hoppar den inte till orginal forumet utan stannar kvar på nya domänen.

I config filen ligger allt med 4 gånger? ska det göra det?
INSERT INTO `phpbb_config` VALUES ('board_disable', '0');
Så ser det ut i config filen

Re: Hur delar jag backup filen

Postat: 2008-05-29 15:07
av Bernstig
Hela config filen

Kod: Markera allt

-- Struktur för tabell `phpbb_config`
-- 

CREATE TABLE `phpbb_config` (
  `config_name` varchar(255) default NULL,
  `config_value` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Data i tabell `phpbb_config`
-- 

INSERT INTO `phpbb_config` VALUES ('config_id', '1');
INSERT INTO `phpbb_config` VALUES ('allow_autologin', '1');
INSERT INTO `phpbb_config` VALUES ('allow_avatar_local', '1');
INSERT INTO `phpbb_config` VALUES ('allow_avatar_remote', '1');
INSERT INTO `phpbb_config` VALUES ('allow_avatar_upload', '1');
INSERT INTO `phpbb_config` VALUES ('allow_bbcode', '1');
INSERT INTO `phpbb_config` VALUES ('allow_html', '1');
INSERT INTO `phpbb_config` VALUES ('allow_html_tags', 'b,i,u,pre');
INSERT INTO `phpbb_config` VALUES ('allow_namechange', '0');
INSERT INTO `phpbb_config` VALUES ('allow_sig', '1');
INSERT INTO `phpbb_config` VALUES ('allow_smilies', '1');
INSERT INTO `phpbb_config` VALUES ('allow_theme_create', '0');
INSERT INTO `phpbb_config` VALUES ('avatar_filesize', '16000');
INSERT INTO `phpbb_config` VALUES ('avatar_gallery_path', 'images/avatars/gallery');
INSERT INTO `phpbb_config` VALUES ('avatar_max_height', '80');
INSERT INTO `phpbb_config` VALUES ('avatar_max_width', '80');
INSERT INTO `phpbb_config` VALUES ('avatar_path', 'images/avatars');
INSERT INTO `phpbb_config` VALUES ('board_disable', '0');
INSERT INTO `phpbb_config` VALUES ('board_email', 'forum@740klubben.se');
INSERT INTO `phpbb_config` VALUES ('board_email_form', '1');
INSERT INTO `phpbb_config` VALUES ('board_email_sig', '-----------------------------------------------\r\n\nSkickades fr?n Svenska Volvo 7/900-klubben\r\n\nhttp://www.740klubben.se');
INSERT INTO `phpbb_config` VALUES ('board_startdate', '1038579596');
INSERT INTO `phpbb_config` VALUES ('board_timezone', '2');
INSERT INTO `phpbb_config` VALUES ('board_timezone', '2');
INSERT INTO `phpbb_config` VALUES ('cookie_domain', 'svenskavolvo7900klubben.se/phpBB2/index.php');
INSERT INTO `phpbb_config` VALUES ('cookie_name', 'phpbb');
INSERT INTO `phpbb_config` VALUES ('cookie_path', '');
INSERT INTO `phpbb_config` VALUES ('cookie_secure', '0');
INSERT INTO `phpbb_config` VALUES ('cookie_secure', '0');
INSERT INTO `phpbb_config` VALUES ('coppa_fax', '');
INSERT INTO `phpbb_config` VALUES ('coppa_mail', '');
INSERT INTO `phpbb_config` VALUES ('default_dateformat', 'Y-m-d G:i');
INSERT INTO `phpbb_config` VALUES ('default_lang', 'swedish');
INSERT INTO `phpbb_config` VALUES ('default_style', '1');
INSERT INTO `phpbb_config` VALUES ('enable_confirm', '1');
INSERT INTO `phpbb_config` VALUES ('flood_interval', '5');
INSERT INTO `phpbb_config` VALUES ('gzip_compress', '1');
INSERT INTO `phpbb_config` VALUES ('hot_threshold', '25');
INSERT INTO `phpbb_config` VALUES ('login_reset_time', '10');
INSERT INTO `phpbb_config` VALUES ('max_autologin_time', '0');
INSERT INTO `phpbb_config` VALUES ('max_inbox_privmsgs', '150');
INSERT INTO `phpbb_config` VALUES ('max_login_attempts', '10');
INSERT INTO `phpbb_config` VALUES ('max_poll_options', '40');
INSERT INTO `phpbb_config` VALUES ('max_savebox_privmsgs', '500');
INSERT INTO `phpbb_config` VALUES ('max_sentbox_privmsgs', '300');
INSERT INTO `phpbb_config` VALUES ('max_sig_chars', '500');
INSERT INTO `phpbb_config` VALUES ('override_user_style', '1');
INSERT INTO `phpbb_config` VALUES ('posts_per_page', '25');
INSERT INTO `phpbb_config` VALUES ('privmsg_disable', '0');
INSERT INTO `phpbb_config` VALUES ('prune_enable', '0');
INSERT INTO `phpbb_config` VALUES ('rand_seed', '5d9406b3ba652ed7270ddadb07a61ccc');
INSERT INTO `phpbb_config` VALUES ('record_online_date', '1208321704');
INSERT INTO `phpbb_config` VALUES ('record_online_users', '316');
INSERT INTO `phpbb_config` VALUES ('require_activation', '1');
INSERT INTO `phpbb_config` VALUES ('script_path', '');
INSERT INTO `phpbb_config` VALUES ('search_flood_interval', '3');
INSERT INTO `phpbb_config` VALUES ('search_min_chars', '3');
INSERT INTO `phpbb_config` VALUES ('sendmail_fix', '1');
INSERT INTO `phpbb_config` VALUES ('server_name', 'svenskavolvo7900klubben.se/phpBB2/index.php');
INSERT INTO `phpbb_config` VALUES ('server_port', '80');
INSERT INTO `phpbb_config` VALUES ('session_length', '3600');
INSERT INTO `phpbb_config` VALUES ('site_desc', 'M?tesplats f?r Svenska Volvo 7/900-klubben');
INSERT INTO `phpbb_config` VALUES ('sitename', 'Svenska Volvo 7/900 Klubbens forum');
INSERT INTO `phpbb_config` VALUES ('smilies_path', 'images/smiles');
INSERT INTO `phpbb_config` VALUES ('smtp_delivery', '1');
INSERT INTO `phpbb_config` VALUES ('smtp_host', '83.140.162.241');
INSERT INTO `phpbb_config` VALUES ('smtp_password', '');
INSERT INTO `phpbb_config` VALUES ('smtp_username', '');
INSERT INTO `phpbb_config` VALUES ('topics_per_page', '50');
INSERT INTO `phpbb_config` VALUES ('version', '.0.22');
INSERT INTO `phpbb_config` VALUES ('config_id', '1');
INSERT INTO `phpbb_config` VALUES ('allow_autologin', '1');
INSERT INTO `phpbb_config` VALUES ('allow_avatar_local', '1');
INSERT INTO `phpbb_config` VALUES ('allow_avatar_remote', '1');
INSERT INTO `phpbb_config` VALUES ('allow_avatar_upload', '1');
INSERT INTO `phpbb_config` VALUES ('allow_bbcode', '1');
INSERT INTO `phpbb_config` VALUES ('allow_html', '1');
INSERT INTO `phpbb_config` VALUES ('allow_html_tags', 'b,i,u,pre');
INSERT INTO `phpbb_config` VALUES ('allow_namechange', '0');
INSERT INTO `phpbb_config` VALUES ('allow_sig', '1');
INSERT INTO `phpbb_config` VALUES ('allow_smilies', '1');
INSERT INTO `phpbb_config` VALUES ('allow_theme_create', '0');
INSERT INTO `phpbb_config` VALUES ('avatar_filesize', '16000');
INSERT INTO `phpbb_config` VALUES ('avatar_gallery_path', 'images/avatars/gallery');
INSERT INTO `phpbb_config` VALUES ('avatar_max_height', '80');
INSERT INTO `phpbb_config` VALUES ('avatar_max_width', '80');
INSERT INTO `phpbb_config` VALUES ('avatar_path', 'images/avatars');
INSERT INTO `phpbb_config` VALUES ('board_disable', '0');
INSERT INTO `phpbb_config` VALUES ('board_email', 'forum@740klubben.se');
INSERT INTO `phpbb_config` VALUES ('board_email_form', '1');
INSERT INTO `phpbb_config` VALUES ('board_email_sig', '-----------------------------------------------\r\n\nSkickades fr?n Svenska Volvo 7/900-klubben\r\n\nhttp://www.740klubben.se');
INSERT INTO `phpbb_config` VALUES ('board_startdate', '1038579596');
INSERT INTO `phpbb_config` VALUES ('board_timezone', '2');
INSERT INTO `phpbb_config` VALUES ('cookie_domain', 'svenskavolvo7900klubben.se/phpBB2/index.php');
INSERT INTO `phpbb_config` VALUES ('cookie_name', 'phpbb');
INSERT INTO `phpbb_config` VALUES ('cookie_path', '');
INSERT INTO `phpbb_config` VALUES ('cookie_secure', '0');
INSERT INTO `phpbb_config` VALUES ('coppa_fax', '');
INSERT INTO `phpbb_config` VALUES ('coppa_mail', '');
INSERT INTO `phpbb_config` VALUES ('default_dateformat', 'Y-m-d G:i');
INSERT INTO `phpbb_config` VALUES ('default_lang', 'swedish');
INSERT INTO `phpbb_config` VALUES ('default_style', '1');
INSERT INTO `phpbb_config` VALUES ('enable_confirm', '1');
INSERT INTO `phpbb_config` VALUES ('flood_interval', '5');
INSERT INTO `phpbb_config` VALUES ('ghgggh', 'gfgfgf');
INSERT INTO `phpbb_config` VALUES ('gzip_compress', '1');
INSERT INTO `phpbb_config` VALUES ('hot_threshold', '25');
INSERT INTO `phpbb_config` VALUES ('login_reset_time', '10');
INSERT INTO `phpbb_config` VALUES ('max_autologin_time', '0');
INSERT INTO `phpbb_config` VALUES ('max_inbox_privmsgs', '150');
INSERT INTO `phpbb_config` VALUES ('max_login_attempts', '10');
INSERT INTO `phpbb_config` VALUES ('max_poll_options', '40');
INSERT INTO `phpbb_config` VALUES ('max_sentbox_privmsgs', '300');
INSERT INTO `phpbb_config` VALUES ('max_sig_chars', '500');
INSERT INTO `phpbb_config` VALUES ('override_user_style', '1');
INSERT INTO `phpbb_config` VALUES ('posts_per_page', '25');
INSERT INTO `phpbb_config` VALUES ('privmsg_disable', '0');
INSERT INTO `phpbb_config` VALUES ('prune_enable', '0');
INSERT INTO `phpbb_config` VALUES ('rand_seed', '5d9406b3ba652ed7270ddadb07a61ccc');
INSERT INTO `phpbb_config` VALUES ('record_online_date', '1208321704');
INSERT INTO `phpbb_config` VALUES ('record_online_users', '316');
INSERT INTO `phpbb_config` VALUES ('require_activation', '1');
INSERT INTO `phpbb_config` VALUES ('script_path', '');
INSERT INTO `phpbb_config` VALUES ('search_flood_interval', '3');
INSERT INTO `phpbb_config` VALUES ('search_min_chars', '3');
INSERT INTO `phpbb_config` VALUES ('config_id', '1');
INSERT INTO `phpbb_config` VALUES ('allow_autologin', '1');
INSERT INTO `phpbb_config` VALUES ('allow_avatar_local', '1');
INSERT INTO `phpbb_config` VALUES ('allow_avatar_remote', '1');
INSERT INTO `phpbb_config` VALUES ('allow_avatar_upload', '1');
INSERT INTO `phpbb_config` VALUES ('allow_bbcode', '1');
INSERT INTO `phpbb_config` VALUES ('allow_html', '1');
INSERT INTO `phpbb_config` VALUES ('allow_html_tags', 'b,i,u,pre');
INSERT INTO `phpbb_config` VALUES ('allow_namechange', '0');
INSERT INTO `phpbb_config` VALUES ('allow_sig', '1');
INSERT INTO `phpbb_config` VALUES ('allow_smilies', '1');
INSERT INTO `phpbb_config` VALUES ('allow_theme_create', '0');
INSERT INTO `phpbb_config` VALUES ('avatar_filesize', '16000');
INSERT INTO `phpbb_config` VALUES ('avatar_gallery_path', 'images/avatars/gallery');
INSERT INTO `phpbb_config` VALUES ('avatar_max_height', '80');
INSERT INTO `phpbb_config` VALUES ('avatar_max_width', '80');
INSERT INTO `phpbb_config` VALUES ('avatar_path', 'images/avatars');
INSERT INTO `phpbb_config` VALUES ('board_disable', '0');
INSERT INTO `phpbb_config` VALUES ('board_email', 'forum@740klubben.se');
INSERT INTO `phpbb_config` VALUES ('board_email_form', '1');
INSERT INTO `phpbb_config` VALUES ('board_email_sig', '-----------------------------------------------\r\n\nSkickades fr?n Svenska Volvo 7/900-klubben\r\n\nhttp://www.740klubben.se');
INSERT INTO `phpbb_config` VALUES ('board_startdate', '1038579596');
INSERT INTO `phpbb_config` VALUES ('board_timezone', '2');
INSERT INTO `phpbb_config` VALUES ('cookie_domain', 'svenskavolvo7900klubben.se/phpBB2/index.php');
INSERT INTO `phpbb_config` VALUES ('cookie_name', 'phpbb');
INSERT INTO `phpbb_config` VALUES ('cookie_path', '');
INSERT INTO `phpbb_config` VALUES ('cookie_secure', '0');
INSERT INTO `phpbb_config` VALUES ('coppa_fax', '');
INSERT INTO `phpbb_config` VALUES ('coppa_mail', '');
INSERT INTO `phpbb_config` VALUES ('default_dateformat', 'Y-m-d G:i');
INSERT INTO `phpbb_config` VALUES ('default_lang', 'swedish');
INSERT INTO `phpbb_config` VALUES ('default_style', '1');
INSERT INTO `phpbb_config` VALUES ('enable_confirm', '1');
INSERT INTO `phpbb_config` VALUES ('flood_interval', '5');
INSERT INTO `phpbb_config` VALUES ('ghgggh', 'gfgfgf');
INSERT INTO `phpbb_config` VALUES ('gzip_compress', '1');
INSERT INTO `phpbb_config` VALUES ('hot_threshold', '25');
INSERT INTO `phpbb_config` VALUES ('login_reset_time', '10');
INSERT INTO `phpbb_config` VALUES ('max_autologin_time', '0');
INSERT INTO `phpbb_config` VALUES ('max_inbox_privmsgs', '150');
INSERT INTO `phpbb_config` VALUES ('max_login_attempts', '10');
INSERT INTO `phpbb_config` VALUES ('max_poll_options', '40');
INSERT INTO `phpbb_config` VALUES ('max_sentbox_privmsgs', '300');
INSERT INTO `phpbb_config` VALUES ('max_sig_chars', '500');
INSERT INTO `phpbb_config` VALUES ('override_user_style', '1');
INSERT INTO `phpbb_config` VALUES ('posts_per_page', '25');
INSERT INTO `phpbb_config` VALUES ('privmsg_disable', '0');
INSERT INTO `phpbb_config` VALUES ('prune_enable', '0');
INSERT INTO `phpbb_config` VALUES ('rand_seed', '5d9406b3ba652ed7270ddadb07a61ccc');
INSERT INTO `phpbb_config` VALUES ('record_online_date', '1208321704');
INSERT INTO `phpbb_config` VALUES ('record_online_users', '316');
INSERT INTO `phpbb_config` VALUES ('require_activation', '1');
INSERT INTO `phpbb_config` VALUES ('script_path', '');
INSERT INTO `phpbb_config` VALUES ('search_flood_interval', '3');
INSERT INTO `phpbb_config` VALUES ('search_min_chars', '3');
INSERT INTO `phpbb_config` VALUES ('config_id', '1');
INSERT INTO `phpbb_config` VALUES ('allow_autologin', '1');
INSERT INTO `phpbb_config` VALUES ('allow_avatar_local', '1');
INSERT INTO `phpbb_config` VALUES ('allow_avatar_remote', '1');
INSERT INTO `phpbb_config` VALUES ('allow_avatar_upload', '1');
INSERT INTO `phpbb_config` VALUES ('allow_bbcode', '1');
INSERT INTO `phpbb_config` VALUES ('allow_html', '1');
INSERT INTO `phpbb_config` VALUES ('allow_html_tags', 'b,i,u,pre');
INSERT INTO `phpbb_config` VALUES ('allow_namechange', '0');
INSERT INTO `phpbb_config` VALUES ('allow_sig', '1');
INSERT INTO `phpbb_config` VALUES ('allow_smilies', '1');
INSERT INTO `phpbb_config` VALUES ('allow_theme_create', '0');
INSERT INTO `phpbb_config` VALUES ('avatar_filesize', '16000');
INSERT INTO `phpbb_config` VALUES ('avatar_gallery_path', 'images/avatars/gallery');
INSERT INTO `phpbb_config` VALUES ('avatar_max_height', '80');
INSERT INTO `phpbb_config` VALUES ('avatar_max_width', '80');
INSERT INTO `phpbb_config` VALUES ('avatar_path', 'images/avatars');
INSERT INTO `phpbb_config` VALUES ('board_disable', '0');
INSERT INTO `phpbb_config` VALUES ('board_email', 'forum@740klubben.se');
INSERT INTO `phpbb_config` VALUES ('board_email_form', '1');
INSERT INTO `phpbb_config` VALUES ('board_email_sig', '-----------------------------------------------\r\n\nSkickades fr?n Svenska Volvo 7/900-klubben\r\n\nhttp://www.740klubben.se');
INSERT INTO `phpbb_config` VALUES ('board_startdate', '1038579596');
INSERT INTO `phpbb_config` VALUES ('board_timezone', '2');
INSERT INTO `phpbb_config` VALUES ('cookie_domain', 'svenskavolvo7900klubben.se/phpBB2/index.php');
INSERT INTO `phpbb_config` VALUES ('cookie_name', 'phpbb');
INSERT INTO `phpbb_config` VALUES ('cookie_path', '');
INSERT INTO `phpbb_config` VALUES ('cookie_secure', '0');
INSERT INTO `phpbb_config` VALUES ('coppa_fax', '');
INSERT INTO `phpbb_config` VALUES ('coppa_mail', '');
INSERT INTO `phpbb_config` VALUES ('default_dateformat', 'Y-m-d G:i');
INSERT INTO `phpbb_config` VALUES ('default_lang', 'swedish');
INSERT INTO `phpbb_config` VALUES ('default_style', '1');
INSERT INTO `phpbb_config` VALUES ('enable_confirm', '1');
INSERT INTO `phpbb_config` VALUES ('flood_interval', '5');
INSERT INTO `phpbb_config` VALUES ('ghgggh', 'gfgfgf');
INSERT INTO `phpbb_config` VALUES ('gzip_compress', '1');
INSERT INTO `phpbb_config` VALUES ('hot_threshold', '25');
INSERT INTO `phpbb_config` VALUES ('login_reset_time', '10');
INSERT INTO `phpbb_config` VALUES ('max_autologin_time', '0');
INSERT INTO `phpbb_config` VALUES ('max_inbox_privmsgs', '150');
INSERT INTO `phpbb_config` VALUES ('max_login_attempts', '10');
INSERT INTO `phpbb_config` VALUES ('max_poll_options', '40');
INSERT INTO `phpbb_config` VALUES ('max_sentbox_privmsgs', '300');
INSERT INTO `phpbb_config` VALUES ('max_sig_chars', '500');
INSERT INTO `phpbb_config` VALUES ('override_user_style', '1');
INSERT INTO `phpbb_config` VALUES ('posts_per_page', '25');
INSERT INTO `phpbb_config` VALUES ('privmsg_disable', '0');
INSERT INTO `phpbb_config` VALUES ('prune_enable', '0');
INSERT INTO `phpbb_config` VALUES ('rand_seed', '5d9406b3ba652ed7270ddadb07a61ccc');
INSERT INTO `phpbb_config` VALUES ('record_online_date', '1208321704');
INSERT INTO `phpbb_config` VALUES ('record_online_users', '316');
INSERT INTO `phpbb_config` VALUES ('require_activation', '1');
INSERT INTO `phpbb_config` VALUES ('script_path', '');
INSERT INTO `phpbb_config` VALUES ('search_flood_interval', '3');
INSERT INTO `phpbb_config` VALUES ('search_min_chars', '3');
INSERT INTO `phpbb_config` VALUES ('agreed_var', 'Volvo');
INSERT INTO `phpbb_config` VALUES ('agreed_val', 'Turbo');
INSERT INTO `phpbb_config` VALUES ('coppa_var', 'Klubben');
INSERT INTO `phpbb_config` VALUES ('allow_quickreply', '1');
INSERT INTO `phpbb_config` VALUES ('anonymous_show_sqr', '0');
INSERT INTO `phpbb_config` VALUES ('anonymous_sqr_mode', '0');
INSERT INTO `phpbb_config` VALUES ('anonymous_open_sqr', '0');

Re: Hur delar jag backup filen

Postat: 2008-05-29 15:10
av tumba25
Det ska inte finnas dubletter i tabellen phpbb_config. Om du har tillgång till phpMyAdmin kan du raderad dubletterna direkt i den.
Alla tidsangivelser är UTC+02:00 Europe/Stockholm
Sida 2 av 4

Drivs av phpBB® Forum Software © phpBB Limited

Swedish translation by phpBB Sweden © 2006-2027