| View previous topic :: View next topic |
| Author |
Message |
Beamin1
-
Joined: 25 Oct 2003
Posts: 27
|
 Posted: Fri Aug 27, 2004 8:58 am Post subject: phpbb database restore |
 |
|
Currently having problems trying to restore my phpbb database... the size is around 30 mgs... after about 2 mins I get "page cannot be displayed"
In CGI scripts Ive set the timeout to 800 and still getting it... is there anything else I can do to try to get this done?
Thanks in advance, Beamin1 |
|
| Back to top |
  |
 |
TRUSTAbyss
-
Joined: 29 Oct 2003
Posts: 3752
Location: USA, GA
|
| Posted: Fri Aug 27, 2004 10:37 am Post subject: |
|
|
Increase the Server Timeout to about 300 seconds , this will make sure
that the script runs long enough to be updated to the SQL Server. LateR!
If that doesn't work , open your php.ini and increase Max Execution time
to 300 , than it should update to the MySQL server next time you query it. |
|
| Back to top |
 |
|
Beamin1
-
Joined: 25 Oct 2003
Posts: 27
|
| Posted: Fri Aug 27, 2004 12:06 pm Post subject: |
|
|
ok set server timeout to 900(after trying everything below it)
and in php.ini exe time is set to 300 and set input time to 600
Still getting same prob... how high can I go and are there any other settings I can tweak...Ive lost a weeks worth of work if I cant get this done so ANY ideas are greatly appreciated...
Beamin1 |
|
| Back to top |
|
|
TRUSTAbyss
-
Joined: 29 Oct 2003
Posts: 3752
Location: USA, GA
|
| Posted: Fri Aug 27, 2004 12:53 pm Post subject: |
|
|
After changing your php.ini , it is recommended that you restart Abyss
in order for the changes to take effect , if that doesn't work , than your
just out of luck and you lost your forum data. Have A Nice Day !
Edit: Did you say 30 MB's , its going to take longer to update that to
the MySQL server , put the seconds to like 1200 seconds , Later! |
|
| Back to top |
|
|
Beamin1
-
Joined: 25 Oct 2003
Posts: 27
|
| Posted: Fri Aug 27, 2004 12:57 pm Post subject: |
|
|
is there nothing else that can be done to get this to work??? Ive spent a week converting 5 years worth of data ... and cant imagine having to start over again from scratch... the file I have is 30 mgs and has all the data in it as a text file... but atm Im not getting any help on the phpbb forums as to how to use that other than through the admin control panel.... which is still getting timed out... how high can I go with my time settings????
I have to come up with something or I may never look at another computer again.... |
|
| Back to top |
|
|
TRUSTAbyss
-
Joined: 29 Oct 2003
Posts: 3752
Location: USA, GA
|
| Posted: Fri Aug 27, 2004 1:03 pm Post subject: |
|
|
As high as you want , I recommend 3600 seconds , thats a full hour , it
should give the script plenty of time to update , also , do you have the
old database file from the mysql folder still , that may help ? |
|
| Back to top |
|
|
Beamin1
-
Joined: 25 Oct 2003
Posts: 27
|
| Posted: Fri Aug 27, 2004 1:16 pm Post subject: |
|
|
no I dont have the mysql DB files.. when I tried to export them my PC hung up and when I went back to the server(not my AWS) the DB was empty... all the tables were there but the data was gone....still havent heard from the host if theres a possible bacup but I dount there is since the data was only there for a matter of hours before i lost it.....
Here is a sample of the file I have..... | Quote: | #
# phpBB Backup Script
# Dump of tables for bod
#
# DATE : 27-08-2004 07:11:51 GMT
#
#
# Table Data for phpbb_categories
#
INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES('2', 'Public Forums', '10');
INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES('3', 'Member Forums', '20');
INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES('4', 'Class Forums', '30');
INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES('5', 'Upper Command', '40');
INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES('6', 'Admin', '50');
#
# Table Data for phpbb_config
#
INSERT INTO phpbb_config (config_name, config_value) VALUES('config_id', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES('board_disable', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES('sitename', 'yourdomain.com');
INSERT INTO phpbb_config (config_name, config_value) VALUES('site_desc', 'A _little_ text to describe your forum');
INSERT INTO phpbb_config (config_name, config_value) VALUES('cookie_name', 'phpbb2mysql');
INSERT INTO phpbb_config (config_name, config_value) VALUES('cookie_path', '/');
INSERT INTO phpbb_config (config_name, config_value) VALUES('cookie_domain', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES('cookie_secure', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES('session_length', '3600');
INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_html', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_html_tags', 'b,i,u,pre');
INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_bbcode', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_smilies', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_sig', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_namechange', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_theme_create', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_avatar_local', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_avatar_remote', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_avatar_upload', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES('enable_confirm', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES('override_user_style', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES('posts_per_page', '25');
INSERT INTO phpbb_config (config_name, config_value) VALUES('topics_per_page', '50');
INSERT INTO phpbb_config (config_name, config_value) VALUES('hot_threshold', '25');
INSERT INTO phpbb_config (config_name, config_value) VALUES('max_poll_options', '10');
INSERT INTO phpbb_config (config_name, config_value) VALUES('max_sig_chars', '255');
INSERT INTO phpbb_config (config_name, config_value) VALUES('max_inbox_privmsgs', '50');
INSERT INTO phpbb_config (config_name, config_value) VALUES('max_sentbox_privmsgs', '25');
INSERT INTO phpbb_config (config_name, config_value) VALUES('max_savebox_privmsgs', '50');
INSERT INTO phpbb_config (config_name, config_value) VALUES('board_email_sig', 'Thanks, The Management');
INSERT INTO phpbb_config (config_name, config_value) VALUES('board_email', 'forums@bod.phpwebhosting.com');
INSERT INTO phpbb_config (config_name, config_value) VALUES('smtp_delivery', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES('smtp_host', 'mail.bod.phpwebhosting.com');
INSERT INTO phpbb_config (config_name, config_value) VALUES('smtp_username', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES('smtp_password', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES('sendmail_fix', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES('require_activation', '2');
INSERT INTO phpbb_config (config_name, config_value) VALUES('flood_interval', '30');
INSERT INTO phpbb_config (config_name, config_value) VALUES('board_email_form', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES('avatar_filesize', '6144');
INSERT INTO phpbb_config (config_name, config_value) VALUES('avatar_max_width', '80');
INSERT INTO phpbb_config (config_name, config_value) VALUES('avatar_max_height', '80');
INSERT INTO phpbb_config (config_name, config_value) VALUES('avatar_path', 'images/avatars');
INSERT INTO phpbb_config (config_name, config_value) VALUES('avatar_gallery_path', 'images/avatars/gallery');
INSERT INTO phpbb_config (config_name, config_value) VALUES('smilies_path', 'images/smiles');
INSERT INTO phpbb_config (config_name, config_value) VALUES('default_style', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES('default_dateformat', 'D M d, Y g:i a');
INSERT INTO phpbb_config (config_name, config_value) VALUES('board_timezone', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES('prune_enable', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES('privmsg_disable', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES('gzip_compress', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES('coppa_fax', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES('coppa_mail', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES('record_online_users', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES('record_online_date', '1093465944');
INSERT INTO phpbb_config (config_name, config_value) VALUES('server_name', 'bod.phpwebhosting.com');
INSERT INTO phpbb_config (config_name, config_value) VALUES('server_port', '80');
INSERT INTO phpbb_config (config_name, config_value) VALUES('script_path', '/forums/');
INSERT INTO phpbb_config (config_name, config_value) VALUES('version', '.0.10');
INSERT INTO phpbb_config (config_name, config_value) VALUES('version5', '.0.10.1');
INSERT INTO phpbb_config (config_name, config_value) VALUES('board_startdate', '1093465787');
INSERT INTO phpbb_config (config_name, config_value) VALUES('default_lang', 'english');
#
# Table Data for phpbb_forums
#
INSERT INTO phpbb_forums (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order, forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments) VALUES('1', '2', 'General Discussion', 'Open EQ Discussion', '0', '10', '3388', '499', '6521', NULL, '0', '0', '0', '0', '0', '1', '1', '3', '3', '1', '1', '0');
INSERT INTO phpbb_forums (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order, forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments) VALUES('2', '2', 'Trading Post', 'In game trading', '0', '20', '3129', '842', '3132', NULL, '0', '0', '0', '0', '0', '1', '1', '3', '3', '1', '1', '0');
INSERT INTO phpbb_forums (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order, forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments) VALUES('3', '2', 'Retired Bod', 'Retired and former BoD', '0', '30', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '1', '3', '3', '1', '1', '0');
INSERT INTO phpbb_forums (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order, |
I am by far a guru with sql.. does this look like its even close to salvagable???? |
|
| Back to top |
|
|
TRUSTAbyss
-
Joined: 29 Oct 2003
Posts: 3752
Location: USA, GA
|
| Posted: Fri Aug 27, 2004 1:20 pm Post subject: |
|
|
Just try my suggestion and let it query for up to one hour or more , im sure
it will work just give it some time , I too had problems like this and when I
increased my timeout speeds , it worked great , give it some time. Ok ?
Last edited by TRUSTAbyss on Fri Aug 27, 2004 1:33 pm; edited 1 time in total |
|
| Back to top |
|
|
Beamin1
-
Joined: 25 Oct 2003
Posts: 27
|
| Posted: Fri Aug 27, 2004 1:28 pm Post subject: |
|
|
| Aye Im letting it sit forever.. but it only takes about a 3 mins to timeout via the phpbb admin panel... phpmyadmin wont even open this file, its too large... is there any other way(program) I could try to use to run it?? or run it from a a command line somewhere? |
|
| Back to top |
|
|
Beamin1
-
Joined: 25 Oct 2003
Posts: 27
|
| Posted: Fri Aug 27, 2004 3:05 pm Post subject: |
|
|
| ok now Im getting internal server error 500? |
|
| Back to top |
|
|
trinity
-
Joined: 11 Nov 2003
Posts: 20
Location: Tampa, FL
|
| Posted: Sat Aug 28, 2004 8:09 am Post subject: |
|
|
If you are running MySQL and AWS for Windows, I would suggest the following procedure for future backups:
1. Shutdown Abyss and the MySQL server.
2. Copy the Db folder for the Db found in /mysql/data/
When you are ready to restore your Db
3. Create an empty database using the same name as before.
4. Create your database user with global permissions to access that database.
5. Shutdown Abyss and the MySQL server
6. Copy the files into the Db folder of your new installation of MySQL
7. Restart Abyss and MySQL
I have done this recently to restore an IPB database, so there should be no reason it wouldn't work for phpBB. Of course, this doesn't help you now... but it's a lot easier than exporting and importing a database, even when using phpMyAdmin (in the future).
_________________
Please feel free to visit my websites:
BNBT EasyTracker | The Trinity Forums | The Piscean Realm of ZionMatrix |
|
| Back to top |
  |
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
