Database moved


Page 1 of 1
 
 

Post Database moved

#1  Tormie 26 Mar 2007 19:33

Hi friends   , I was bored of the slowness that sometimes affects the site so I decided to move the database on another server. The database of Posetteforever is not on a machine that has only its database, but there are many databases on the same PC. I suppose that something on that PC is slowing all the database, like a forum not working wll, so I create another database on a different PC hoping that this one runs better. This problem has occurred again in the past and probably will occur again in the future. If you notice periods of slowness of the site in a period, for example a week, please contact me and I'll do the same. I hope that the transfer went well, if you see something strange contact me as well  

Tormie
 




____________
 
avatar
it.png Tormie Gender: Male
Posette enthusiast
Posette enthusiast
Life + 1
Life + 1
Renderosity Ban
Renderosity Ban
 
Joined: March 2003
Posts: 8279
Tomatoes 72502
Lemons 50450
hearts 5031

  • Back to top Page bottom
 

Post Re: Database moved

#2  JanReinar 26 Mar 2007 19:47

All looks more fast Davide!   You really improve the speed!
 




____________
Here we go!

 
avatar
blank.gif JanReinar Gender: Male
Posette enthusiast
Posette enthusiast
Life + 1
Life + 1
Old Timer
Old Timer
 
Joined: December 2003
Location: Rio de Janeiro
Posts: 2385
Tomatoes 21250
Lemons 11861
hearts 358

  • Back to top Page bottom
 

Post Re: Database Moved

#3  GrouchoCaesar 26 Mar 2007 22:11

Ahhh, the things you do for us, sir. Much appreciated.
 




____________
Am I the only one who thinks they named it Windows because it is a major pane? BA-DUM BOOM!!
 
avatar
new_zealand.png GrouchoCaesar Gender: Male
Forums Veteran
Forums Veteran
Life + 1
Life + 1
 
Joined: November 2006
Location: New Zealand
Posts: 351
Tomatoes 3170
Lemons 1807
hearts 45

  • Back to top Page bottom
 

Post Re: Database moved

#4  ahjah 26 Mar 2007 23:21

Good job! Works good so far
 




____________
Image
 
avatar
blank.gif ahjah Gender: Male
Posette enthusiast
Posette enthusiast
Life + 1
Life + 1
Chief
Chief
Old Timer
Old Timer
 
Joined: April 2003
Location: detmold/germany
Posts: 2798
Tomatoes 4130
Lemons 517
hearts 2130

  • Back to top Page bottom
 

Post Re: Database moved

#5  ahjah 27 Mar 2007 03:54

  When clicking the statistics, there's:

"Warning: filemtime(): Stat failed for ./includes/stat_modules/average_posts_per_user/info.txt (errno=2 - No such file or directory) in /home/content/t/o/r/tormentor/html/includes/functions_stats.php on line 50

Warning: filemtime(): Stat failed for ./includes/stat_modules/average_posts_per_user/info.txt (errno=2 - No such file or directory) in /home/content/t/o/r/tormentor/html/includes/functions_stats.php on line 116"

and:

"Could not update Info Cache

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE module_id = 2' at line 4

UPDATE phpbb_stats_modules SET module_info_cache = 'a:2:{s:16:"condition_result";b:;s:19:"default_update_time";i:0;}', module_info_time = WHERE module_id = 2

Line : 121
File : functions_stats.php"

An old file path left somewhere, maybe
 




____________
Image
 
avatar
blank.gif ahjah Gender: Male
Posette enthusiast
Posette enthusiast
Life + 1
Life + 1
Chief
Chief
Old Timer
Old Timer
 
Joined: April 2003
Location: detmold/germany
Posts: 2798
Tomatoes 4130
Lemons 517
hearts 2130

  • Back to top Page bottom
 

Post Re: Database moved

#6  Tormie 27 Mar 2007 08:54

     I'll check soon ! Now time for errands
 




____________
 
avatar
it.png Tormie Gender: Male
Posette enthusiast
Posette enthusiast
Life + 1
Life + 1
Renderosity Ban
Renderosity Ban
 
Joined: March 2003
Posts: 8279
Tomatoes 72502
Lemons 50450
hearts 5031

  • Back to top Page bottom
 

Post Re: Database moved

#7  Tormie 27 Mar 2007 09:00

It's ok now But it was strange :      Thank you Andreas
 




____________
 
avatar
it.png Tormie Gender: Male
Posette enthusiast
Posette enthusiast
Life + 1
Life + 1
Renderosity Ban
Renderosity Ban
 
Joined: March 2003
Posts: 8279
Tomatoes 72502
Lemons 50450
hearts 5031

  • Back to top Page bottom
 

Post Re: Database moved

#8  ahjah 27 Mar 2007 12:56

  
 




____________
Image
 
avatar
blank.gif ahjah Gender: Male
Posette enthusiast
Posette enthusiast
Life + 1
Life + 1
Chief
Chief
Old Timer
Old Timer
 
Joined: April 2003
Location: detmold/germany
Posts: 2798
Tomatoes 4130
Lemons 517
hearts 2130

  • Back to top Page bottom
 


HideWas this topic useful?
Link this topic
URL
BBCode
HTML

Page 1 of 1
 



Users browsing this topic: 0 Registered, 0 Hidden and 0 Visitors
Registered Users: None