Importing a database dump into new blog.

  • OK, here’s a long one.
    I used to have a blog at a site; Danwa.net that I had updated nearly religiously for three years. This year I splurged. I bought my own domain (www.balloflightning.com) so I had more freedom with large files etc.
    In the efforts of starting anew, I began the blog at balloflightning.com from scratch. My Danwa account and Danwa wordpress has been running iffy at best lately, so I want to take my three years of posts (which I have in a database dump–in an SQL file) and reimport them into my blog at balloflightning.com with the hopes of funnelling them into the category of Time Capsule.
    Two problems I see could arise.
    #1, the database dump from Danwa is with a fairly old version of WP, and the one at balloflightning.com is one of the newer versions. I am not sure how compatible the tables will be with each other.
    #2, since I have already started over at balloflightning.com, I have posts #’s ranging up to around 100 I think. A direct import might or might not overwrite my NEW first 100 posts, with my OLD first 100 posts.
    OK, that’s all I can think of right now. If anyone knows how to take my older version of WP database SQL file and import it into my new, already in progress WP without overwriting posts or causing a significant crash it would be much appreciated. I’m not a computer god here, so please, dumb things down for me! ??
    Thanks!
    PS, I haven’t gone to the Wiki yet, but is there a hack/plugin for backing up posts BEFORE I do anything risky like a database import?

Viewing 15 replies - 1 through 15 (of 15 total)

  • https://www.tamba2.org.uk/wordpress/
    Look on the right.

    Thread Starter czar21

    (@czar21)

    I think I understand how the process works, but what I would not be doing is a fresh upgrade. I’m kind of trying to take two databases from different versions of WP and smash them together so that I keep all the posts/comments from both databases. Forgive me if I’m wrong, but the Tamba tutorial is just for moving posts over to a fresh WP with no posts on the new domain as of that time?
    Still possible to take a older database and mash it into an already existing newer database?
    Forgive my ignorance please.

    Thread Starter czar21

    (@czar21)

    OK, here’s what I did so far.
    Went into phpAdmin and backed up my database as of now.
    Then I clicked on the SQL tab and directed it to upload my .sql file.
    This is what it spat out…
    Database balloflight running on localhost
    Error
    SQL-query :
    CREATE TABLE ae_data (
    id int( 11 ) NOT NULL auto_increment,
    type varchar( 20 ) NOT NULL default ”,
    code varchar( 30 ) NOT NULL default ”,
    itemtitle varchar( 150 ) NOT NULL default ”,
    authors varchar( 150 ) NOT NULL default ”,
    url varchar( 150 ) NOT NULL default ”,
    image varchar( 150 ) NOT NULL default ”,
    comment text NOT NULL ,
    dateadded date NOT NULL default ‘0000-00-00’,
    recom tinyint( 4 ) NOT NULL default ‘0’,
    PRIMARY KEY ( id )
    ) TYPE = MYISAM AUTO_INCREMENT = 6
    MySQL said:
    Table ‘ae_data’ already exists
    Something worked, because ae_data is the table that used to house my Amazon links (hack) and they transferred over to the database… nothing else did.
    Anything anyone see I did wrong?

    Thread Starter czar21

    (@czar21)

    Bump.

    Thread Starter czar21

    (@czar21)

    Bump.

    delete the table ae_data?

    I’m doing this right now.
    if the tables are identical, i keep the one’s installed by the installer, and fill them with content.
    if there’s already content, i delete is and then fill it with my own data.
    so far, it’s going well.
    F.

    Thread Starter czar21

    (@czar21)

    OK, getting further now…
    I’m just running the INSERT lines rather than trying to take the whole database dump and stick it in the new database.
    Still having a problem though…
    “SQL-query :
    INSERT INTO wp_categories
    VALUES ( 1, ‘General’, ‘general’, ”, 0 )
    MySQL said:
    Duplicate entry ‘1’ for key 1″
    How do I get the database to skip over those, but then propogate them correctly with new ID values?

    Thread Starter czar21

    (@czar21)

    Bump.

    Thread Starter czar21

    (@czar21)

    Bump.
    Is there any program that runs in Windows that allows for quick editing of ID tags in a database?

    crackerboy

    (@crackerboy)

    bump.

    i’m in a similar situation. i’m trying to import an old blog db into a new on. i get this sql error after following the backup/import directions…

    MySQL said: Documentation
    #1064 – 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 ‘cat_ID int(4) NOT NULL auto_increment,
    cat_name` varchar(55

    crackerboy – if you send me your sql file, I will see what I can do here locally. If I get it to work, I’ll return the original, the amended with what I did and a fresh exported file.

    tamba2 at gmail dot com

    czar – I’ll have a go as well if yours is still an issue ?

    crackerboy

    (@crackerboy)

    just sent it over. thanks in advance.

    verycommerce

    (@verycommerce)

    This is EXACTLY what I’m trying to do – anyone here have any success?

    I’m not trying to do anything so difficult; only trying to export data from my live site into a new blog in a separate directory in the addon domain. When I run the new blog, it redirects to the live blog and tells me my database needs to be updated.

    How do I get this to work? I just want the live data in my new blog!

Viewing 15 replies - 1 through 15 (of 15 total)
  • The topic ‘Importing a database dump into new blog.’ is closed to new replies.