Importing posts using a modified .sql file from one blog to another

  • I’ve got a blog running, (mariosblog.co.uk) and I want to import 20 or so historic blog posts from another blog I had which is now not running (URL was mariodecristofano.com/cisco) I do have access to PHPMYADMIN on both installations, but not the WP install on the old site. I do have all the old site files FTP’ed over to my desktop. I’ve gone into PHPMYADMIN on the old site and exported the database.

    I’ve then modified that file using notepad to change the URL from mariodecristofano.com to mariosblog.co.uk

    I’ve then gone into PHPMYADMIN on the mariosblog.co.uk and created a new database ready to import the posts into. I then tried to import the sql file and I get the error

    No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration

    I’ve ensured the php.ini file has been modified to allow files up to 20mb to be uploaded (the SQL file is only 6mb so I don’t think its file size problems)

    I’d be terribly grateful if anyone had any comments? I’m using 2.4.7 of apache and 4.0.10deb of PHPMyAdmin

Viewing 1 replies (of 1 total)
  • Thread Starter mariodc2016

    (@mariodc2016)

    Ok update: I’ve managed to import all the old posts into a separate database. So I have my blog, and then an additional database with these old posts. I want to import those posts alongside my existing ones (without wiping the existing ones) but I know I can’t do it at the minute as there’ll be conflicts because there’ll be post ID’s both starting with 1 etc – can you help?

Viewing 1 replies (of 1 total)
  • The topic ‘Importing posts using a modified .sql file from one blog to another’ is closed to new replies.