database download problem

Allgemeiner Support zum phpBB 2 Board und phpBB 2 Modifikationen
Forumsregeln
Auch wenn hier der Support für phpBB 2 weiterhin aufrecht erhalten bleibt, weisen wir darauf hin, dass das phpBB 2 nicht mehr offiziell unterstützt und weiterentwickelt wird!
Antworten
uzay
Beiträge: 17
Registriert: Fr 24.Sep, 2004 18:03

database download problem

Beitrag von uzay »

phpbb2 plus 1,52

Forum 8000 user

database download
OK
phpbb_db_backup-----

--->TexPad open Page at last

last user to see your

8000 user, 5338 user ok, 5339 user error

INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_session_topic, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_setbm, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_from_flag, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd, user_sub_forum, user_split_cat, user_last_topic_title, user_sub_level_links, user_display_viewonline, user_birthday, user_next_birthday_greeting, user_gender, user_color_group, user_lastlogon, user_totaltime, user_totallogon, user_totalpages, user_calendar_display_open, user_calendar_header_cells, user_calendar_week_start, user_calendar_nb_row, user_calendar_birthday, user_calendar_forum, user_warnings, user_passwd_change, user_badlogin, user_blocktime, user_block_by, user_split_global_announce, user_split_announce, user_split_sticky, user_split_news, user_split_topic_split, user_absence, user_absence_mode, user_absence_text, user_announcement_date_display, user_announcement_display, user_announcement_display_forum, user_announcement_split, user_announcement_forum) VALUES('5338', '1', 'orfius', '20254545446546546546546', '1095774112', '75', '20', '1095465440', '1086555805', '0', '0', '3.50', NULL, 'turkish', 'd M D Y, H: i', '0', '0', '1086012962', NULL, '0', '0', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', '', '0', 'uyurmu777@msn.com', '', '', '', NULL, '', '', '', '', '', '', '', '', NULL, '1', '1', '1', '2', '2', '999999', '0', '0', '0', '10546546322', NULL, NULL, NULL, '0', '7', '1', '5', '1', '1', NULL, '10954546950', '0', '0', NULL, '1', '1', '1', '1', '0', '0', '0', '', '1', '1', '1', '1', '1');
<br />
<b>Fatal error</b>: Maximum execution time of 30 seconds exceeded in <b>/home/httpd/vhosts/--------------/admin/admin_db_utilities.php</b> on line <b>629</b><br />
Benutzeravatar
oxpus
Administrator
Beiträge: 28735
Registriert: Mo 27.Jan, 2003 22:13
Wohnort: Bad Wildungen
Kontaktdaten:

Beitrag von oxpus »

Do not use the Database Backup Tool from the ACP. This will run into timeouts and/or not backup all tables.
Better use phpMyAdmin or MySQL-Front (if your hoster allows external access to the data base).
These tools are able to backup huge data bases.
Karsten Ude
-={ Das Mädchen für alles }=-
Kein Support per Messenger, Email oder PN! Unaufgeforderte Nachrichten werden ignoriert!
No support per Messenger, Email or PM. Each unasked message will be ignored!
uzay
Beiträge: 17
Registriert: Fr 24.Sep, 2004 18:03

Beitrag von uzay »

When there are few user and few messages, database is backing up. But when the number of user and messages are getting more in forum, it is not.

Thanks .
Antworten