1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Seperating 50 wp databases from a single db

Discussion in 'Databases' started by dmw144, Jun 7, 2010.

0
  1. #1
    I (stupidly) set up approximately 50 wordpress sites using 1 database (i selected the wrong option).

    The database has grown to 1.3 gig and bluehost is having a fit and temp suspended my account (not unreasonably i guess) - how difficult is it to strip out each database and make separate databases - anyone know how much something like this is likely to cost and how long it might take (approx)?

    thx

    dean
     
    dmw144, Jun 7, 2010 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    Get navicat - http://www.navicat.com/.

    You can drag and drop each table into a new database. They offer a free 30 day trial, but it should only take a few minutes to separate them all. You can copy them to a new database on the same server, or new databases on different servers.
     
    jestep, Jun 8, 2010 IP
  3. Nigel Lew

    Nigel Lew Notable Member

    Messages:
    4,642
    Likes Received:
    405
    Best Answers:
    21
    Trophy Points:
    295
    #3
    click export and then select the tables(or one set of prefixes) and export it. Fairly straight forward.

    Nigel
     
    Nigel Lew, Jun 8, 2010 IP
  4. dmw144

    dmw144 Peon

    Messages:
    42
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Thanks Nigel - I have sorted it :)
     
    dmw144, Jun 8, 2010 IP