Support » Networking WordPress » Database problems moving WPMU live site to local dev server

  • Hi all. So I have an Ubuntu 10.4 LAMP stack running at home that I’m trying to move a copy of a live WP 3.0.1 site to for development work. The WP install on the live site was a WPMU site that was upgraded to 3.0 a while back. I’m having a few issues at this point. Here’s what I’ve done and what I’m encountering.

    Copied entire live site folders and files to dev server. Using phpmyadmin, exported DB as sql file. On the dev server, I created a db with the same name, user, and privileges as those on the live server. I’ve changed the domain to site.dev and set up virtual hosts in order to get to this domain. Changed all instances of site.org to site.dev in all tables in the DB. Double checked wp_config to make sure the settings are correct.

    When I navigate to site.dev, it attempts to load and eventually gets to a page that says the server is redirecting in a way that will never complete. I suspect this is because I have define( 'NOBLOGREDIRECT', 'http://site.dev' );
    in wp_config.

    I can log into the backend of WP on the dev site, but there’s some weirdness here too. First, at the top of the dashboard, I’m seeing:

    `Warning! WordPress encrypts user cookies, but you must add the following lines to wp-config.php for it to be more secure.
    Before the line /* That’s all, stop editing! Happy blogging. */ please add this code:

    define( ‘NONCE_KEY’, ‘p9}<U=dID:Ni[cF#g+OJ6br<Z ktyK]xE]|p$C0GaQkI}W4$Af1e*?7uH^%x%i&' );

    I’ve added this to wp_config a dozen times but this just won’t go away. Also, when I look at the post listing or the page listing or the media library, it appears as if everything is listed in there. On the live site, there are 20 pages – Home, About, Contact, etc.. – and in the backend of the live site it says I have 20 pages, and the filter says All(20) Published(20). On the dev site it says I have 20 pages, with the filters All(20) Published (20). But over to the right, I’m seeing “Displaying 1 – 20 of 10,797”, and in the actual list everything is showing up, posts, media files, pages. Same thing on the posts listing screen and the media libray, all say displaying 1-20 of 10,797.

    There’s also no thumbnails available for images, my themes aren’t showing any previews and other oddities. Any thoughts on any of this much appreciated.

  • The topic ‘Database problems moving WPMU live site to local dev server’ is closed to new replies.