WPMU move to localhost; prob with DB import | Wordpress Support | Forum Archive

The free forums are no longer in use. It remains available as read-only archive.

Avatar
Lost password?
Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
The forums are currently locked and only available for read only access
sp_Feed Topic RSSsp_TopicIcon
WPMU move to localhost; prob with DB import
December 24, 2010
7:31 pm
Avatar
Jefferson
New Member
Members
Forum Posts: 2
Member Since:
December 24, 2010
sp_UserOfflineSmall Offline

Hi all,

 

Working on cloning a copy of a MU install onto my local machine. Here's what's happening:

 

*Successfully generating backup on server and downloading tar file.

*Successfully dropping tar, XClone.php and TAR.php into directory I want site installed into on my local machine.

*Successfully creating new, empty DB via PHPMyAdmin on local machine for cloned site.

*Successfully getting past localhost/XClone.php step--getting "Files successfully extracted. Please click here to import database."

*Not successful at this step, despite getting a message that the import finished successfully. Also, from the time I click "Import" to the display of the success message is about half a second--that can't be right for the 20mb sql file generated by XCloner.

*Lastly, check the new DB and there is nothing in it. When I call the localhost URL (it's a virtual host), the site appears, but it is the http://www.mysite.com address instead of http://www.myclonedsite.dev address.

 

Any ideas? Need anymore info? Very promising plugin; just gotta figure this out.

 

Thank you!

December 24, 2010
11:55 pm
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

Hi there! Have you tried checking the "incremental sql import" option from your XCloner.php restore screen?

 

Try that and see if it helps with the database import

 

Ovidiu

December 25, 2010
2:48 am
Avatar
Jefferson
New Member
Members
Forum Posts: 2
Member Since:
December 24, 2010
sp_UserOfflineSmall Offline

Thanks for the quick response. No, I hadn't tried that. Here's what I've done since:

 

*Tried your suggestion, same result. No entries in DB, but files installed.

*Once I tried the above, went back to local-site/XCloner.php. Found the "Import MySQL File" dropdown and choose the main DB, not information_schema. Choose "Skip files restore..." option. That did work...took about three minutes and gave me the % count while it processed. However, same result when I tried local-site address in URL bar.

*Went back to local-site/XCloner.php and attempted to use the same settings above but with information_schema dropdown option. That resulted in an error that the table hadn't been created. Seemed that every record would generate that error.

*So, same result after I tried all the above. I'm regularly flushing the DNS cache via Terminal and restarting.

*Did some investigating in the DB and found that in the siteurl record, the original, non-local site url was still there. Despite changing that, same result when I tried to go to the site.

 

Ok, what do we think? Is it something I'm doing wrong, or something wonky with a unique configuration. I'd do a little more investigating, but brain is a bit fried now.

Thanks for the help. Happy holidays.

 

-Jeff

December 25, 2010
10:31 am
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

OK, so the database was imported however you are still having issues seeing the site right? 

Could you check your wp-config.php file and look for a relocate option, do you have it present?

 

If yes, and the url's configured there point to the new site, then you might have a redirection issue coming from somewhere else, check your .htaccess file.

 

Are you able to access the wp-admin area or is it the same issue?

Ovidiu

Forum Timezone: America/Chicago
Most Users Ever Online: 867
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
mlguru: 30
Django29: 29
Andy: 21
D: 21
Marcus: 20
Jamie F: 19
Member Stats:
Guest Posters: 738
Members: 10030
Moderators: 2
Admins: 3
Forum Stats:
Groups: 3
Forums: 7
Topics: 2397
Posts: 8236
Newest Members:
Emmanuel Joachim
Moderators: TriP: 0, Steve Burge: 0
Administrators: Ovidiu Liuta: 2484, Victor Drover: 1, Valentin Barbu: 0