You can dump the database, do a search/replace on the url, drop the tables and then import the edited sql file.
Have just tried that and I get an error about a syntax.
Is there any easier way without editing the mysql file as i am useless with sql?
reference for any changes to WP directory structure or domain name http://codex.wordpress.org/Moving_WordPress
I’ve followed those instructions and when I go to re-import the database I get this
Error
SQL query:
— phpMyAdmin SQL Dump
— version 2.8.2.4
— http://www.phpmyadmin.net
—
— Host: localhost:3306
— Generation Time: Jun 22, 2009 at 10:22 AM
— Server version: 5.0.79
— PHP Version: 5.2.6
—
— Database: thedevil_wordpress
—
CREATE DATABASE thedevil_wordpress DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
MySQL said:
#1007 – Can’t create database ‘thedevil_wordpress’; database exists
Any one able to help? 😐
It looks like there is a link in your sql that is trying to create the database and it fails because it’s already created. If you used phpMyAdmin and just exported the tables in the database, then you shouldn’t have that line in the sql to create the db.
It may help if you view one of the videos in the following post and pay attention to the part where I export the db tables, search/replace in the sql file, and then import the tables back into the db.
http://educhalk.org/blog/?p=82
COLLATE utf8_general_ci;
USE thedevil_wordpress;
and a CREATE was in mysql database.
I removed that and it worked.
Thanks for the help!
