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

  • Links working
    23 hours 10 min ago
  • Thanks... I may be able to
    1 day 4 hours ago
  • 3306 by default
    1 day 15 hours ago
  • Is this the right place to
    1 day 15 hours ago
  • Figured
    3 weeks 6 days ago
  • I'm guessing at this stage
    3 weeks 6 days ago
  • WordPress MU?
    4 weeks 1 min ago
  • Thanks
    10 weeks 1 day ago
  • I'm running the conversion
    11 weeks 4 days ago
  • Can't reproduce
    11 weeks 6 days ago

New forum topics

  • 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
  • index.php?
more

Who's online

There are currently 0 users and 1 guest online.

Who's new

  • oODeathStormOo
  • leruffiant
  • Emtee
  • mnogodet
  • ZioMimmo

Reduce File Size

Submitted by Steve on Tue, 8 Jul, 2008 - 17: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
  • Login or register to post comments
  • 321 reads

 Subscribe in a reader

free hit counter


RoopleTheme