Hur delar jag backup filen

[Bernstig]

verkade fungera till viss del..... allt utom själv inläggen och användana följde med dock står det antal inlägg i dom olika delarna.

[Holger]

Låt dumpern köra valda tabeller (phpbb_users och phpbb_posts/phpbb_posts_text)

[Bernstig]

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.

[Holger]

Jag tror det heter "Choose tables to restore"

[Bernstig]

provade att ladda upp 800mb backupen och köra den igenom mysqldumper och det funkade

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

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

[Marcus]

Härligt att det löste sig.

[Holger]

Jamen, löste det sig verkligen då? Hade du kvar all data?

[Bernstig]

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.

[Holger]

Den blir större eftersom den innehåller alla SQL-kommandon.

[Bernstig]

Den blir större eftersom den innehåller alla SQL-kommandon.

okej då har man lärt sig något nytt

[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.

[Holger]

Har du ändrat all information i phpbb_config tabellen?

[Bernstig]

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

[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');

[tumba25]

Det ska inte finnas dubletter i tabellen phpbb_config. Om du har tillgång till phpMyAdmin kan du raderad dubletterna direkt i den.