Successfully Moved To My New Server
Well, the move has just been completed and apart from some site loading speeds, all seems well. For those that are interested here’s my new server spec:
- Pentium D 830 3.0ghz Dual Core
- 4GB RAM
- 3ware 9550SX-4LP RAID card with two Maxtor 7V300F0 300GB in RAID1
- Dedicated Maxtor 7V300F0 300GB backup drive
If you are looking for advice with hosting your own blog or site, then check out the forum as some good advice can be found there.
Bookmark & Share
WordPress database error: [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 's my new server spec:
<ul>
<li><span class="ticket_body_text"> pentium d 830 ' at line 1]
SELECT ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST ('well, the move has just been completed and apart from some site loading speeds, all seems well. for those that are interested here's my new server spec:
<ul>
<li><span class="ticket_body_text"> pentium d 830 3.0ghz dual core</span></li>
<li><span class="ticket_body_text">4</span>gb ram</li>
<li>3ware 9550sx-4lp raid card with two maxtor 7v300f0 300gb in raid1</li>
<li>d<span class="ticket_body_text">edicated maxtor 7v300f0 300gb backup drive</span></li>
</ul>
if you are looking for advice with hosting your own blog or site, then <a target="_blank" title="connected intenet forum" href="http://www.forum.connectedinternet.co.uk/index.php">check out the forum</a> as some good advice can be found there.')) as bodyscore, (MATCH (post_title) AGAINST ('successfully moved to my new server')) as titlescore, COUNT( DISTINCT tagtax.term_taxonomy_id ) as tagscore, COUNT( DISTINCT cattax.term_taxonomy_id ) as catscore, (0+ (MATCH (post_content) AGAINST ('well, the move has just been completed and apart from some site loading speeds, all seems well. for those that are interested here's my new server spec:
<ul>
<li><span class="ticket_body_text"> pentium d 830 3.0ghz dual core</span></li>
<li><span class="ticket_body_text">4</span>gb ram</li>
<li>3ware 9550sx-4lp raid card with two maxtor 7v300f0 300gb in raid1</li>
<li>d<span class="ticket_body_text">edicated maxtor 7v300f0 300gb backup drive</span></li>
</ul>
if you are looking for advice with hosting your own blog or site, then <a target="_blank" title="connected intenet forum" href="http://www.forum.connectedinternet.co.uk/index.php">check out the forum</a> as some good advice can be found there.')) * 1+ (MATCH (post_title) AGAINST ('successfully moved to my new server')) * 1+ COUNT( DISTINCT tagtax.term_taxonomy_id ) * 1+ COUNT( DISTINCT cattax.term_taxonomy_id ) * 1) as score
from wp_posts
left JOIN wp_term_relationships AS thistag ON (thistag.object_id = 1295 )
left JOIN wp_term_relationships AS tagrel on (tagrel.term_taxonomy_id = thistag.term_taxonomy_id
AND tagrel.object_id = wp_posts.ID)
left JOIN wp_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id
AND tagtax.taxonomy = 'post_tag')
left JOIN wp_term_relationships AS thiscat ON (thiscat.object_id = 1295 )
left JOIN wp_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id
AND catrel.object_id = wp_posts.ID)
left JOIN wp_term_taxonomy AS cattax ON ( catrel.term_taxonomy_id = cattax.term_taxonomy_id
AND cattax.taxonomy = 'category')
where (post_status IN ( 'publish', 'static' ) and ID != '1295') and post_password ='' and post_type IN ('post', 'page')
group by id
having score >= 6 order by score DESC limit 7
