Prime 357

We'll learn something

Site Menu

  • Home
  • Recent Posts
  • Forum
    • Programming Languages
      • C++
    • Website Design & Content Management
      • Wordpress >> Drupal
  • Blogs
  • Topics
    • C++
    • Changing hosts - Dummies Guide
    • Wordpress >> Drupal
  • Download Centre
  • Contact us
Home Changing Hosts - a Dummies Guide Actual Processes Involved


Image - OpenID

User login

What is OpenID?
  • Log in using OpenID
  • Cancel OpenID login
  • Create new account
  • Request new password

Navigation

  • Recent posts

Topics

  • C++ (The Book)
  • Changing Hosts - a Dummies Guide
    • So you want to change your hosting company
    • Actual Processes Involved
      • Reduce File Size
      • Backup old host database(s)
      • Import SQL file into new database
      • Addon Domain(s)
      • FTP Accounts
      • Transferring files
  • Wordpress to Drupal

Recent comments

  • Thanks..
    37 weeks 1 day ago
  • Hmmm,Interesting one,thx for
    38 weeks 2 days ago
  • Buyer beware
    39 weeks 1 day ago
  • REPLY:Actual Processes Involved
    39 weeks 2 days ago
  • Back to Ruby
    48 weeks 4 days ago
  • Links provided
    1 year 11 weeks ago
  • Module for wordpress to Drupal 6.x
    1 year 11 weeks ago
  • The wordpress plugin looks
    1 year 13 weeks ago
  • Good point..... You're
    1 year 13 weeks ago
  • Many thanks. If I'm going to
    1 year 13 weeks ago

New forum topics

  • Imported posts only visible to user1
  • What should the port number be
  • WordPress MU?
  • funny little bug in mac version
  • Error: Unable to Insert into Node_revisions table when converting from wordpress 2.6.0 to drupal 6.4
more

Sponsored links

Steve's Stuff
All about my running and from time to time other stuff

Improve Memory
All about memory techniques, excellent and relevant articles.

Reduce File Size

Submitted by Steve on Tue, 8 Jul, 2008 - 16:32
  • CMS
  • drupal
  • hosting
  • accesslog,
  • all tables starting with 'cache' and
  • watchdog.

Screen shot - Empty Tables

The emptying out process is not absolutely necessary but you will note that the table 'accesslog' holding 24,000 odd records accounts for nearly half of all records in the database. Simply click the 'Empty' button alongside the relevant table name. As is usual with this type of operation you must confirm that you do in fact do want to empty the table. The term used is 'truncate' which means empty the table.

Screen shot - Confirm Empty

Note that we are not deleting the table, merely emptying the records.

Repeat this for all the tables to be emptied as listed above (also highlighted in the image above).

‹ Actual Processes Involved up Backup old host database(s) ›
  • Printer-friendly version
  • Add new comment
  • 1905 reads
Tue, 16 Jun, 2009 - 15:06
#1
Ahm (not verified)
Hmmm,Interesting one,thx for

Hmmm,Interesting one,thx for explaining all that,Actually i was working on webhosting,but couldn't stop myself to comment on it,i get some interesting information also from other posts,thx for all that,it can be very helpful u know...Try to tell us that is their any other way also to do that kind of process?

Top
  • reply
  • Post reply

 Subscribe in a reader

free hit counter


RoopleTheme