What to do when the Database becomes Full?

  • transpersonal

    (@transpersonal)


    14 years, 11 months ago

    Hi,

    Right now my database is filling up rather quickly, at the moment it is 5.3 MB. I’m not sure what the database limit is but what do I do when the database fills up completely? Is this even possible or can the database be infinitely large in size? If so then is it possible to add additional databases to a wordpress site?

Viewing 4 replies - 1 through 4 (of 4 total)
  • E-TARD The LifeCaster

    (@etardwebcam)

    14 years, 3 months ago

    I’m asking the same dam ?s
    My DB maxs out at 200MB
    I ask my host what do i do when i hit that 200MB with my WP
    they toled me i dont know?

    i asked them can one WP blog access more then one DB
    they toled me that WP does not Support at this time
    so i dont know what one does when there DB is full but i would like to know.

    vtxyzzy

    (@vtxyzzy)

    14 years, 3 months ago

    BE SURE TO BACK UP YOUR DATABASE BEFORE ATTEMPTING THESE FIXES!

    This thread has some tips on removing excess baggage from your database.

    This page has database suggestions as well as other tips for speeding up a blog.

    If you can, run this query to see if you have a lot of revisions:

    SELECT post_type,count(1) FROM 'wp_posts'
group by post_type
ORDER BY 'wp_posts'.'post_type' ASC

    If you do, you might be able to save space by running the query shown here:

    http://lesterchan.net/wordpress/2008/07/17/how-to-turn-off-post-revision-in-wordpress-26/

    MichaelH

    (@michaelh)

    14 years, 3 months ago

    A new host might provide you with more space.

    Related:
    Moving WordPress

    E-TARD The LifeCaster

    (@etardwebcam)

    14 years, 3 months ago

    Hay Tahnks for the tips
    I never new that the revisions add up over time
    I do have one plugin called “wassup” thats taking up a lot of space & wish i could just make it pull from some other DB.
    with my host i can make as many DBs as i want they just cant go over 200MB.

    I wish WP can use more then one DB.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘What to do when the Database becomes Full?’ is closed to new replies.