View Single Post
  #4 (permalink)  
Old Apr 2nd, 2008, 22:55
CloudedVision's Avatar
CloudedVision CloudedVision is offline
Nerdy Moderator
Join Date: Feb 2008
Location: In My Own Little World
Age: 14
Posts: 942
Blog Entries: 8
Thanks: 2
Thanked 21 Times in 21 Posts
Send a message via AIM to CloudedVision Send a message via MSN to CloudedVision Send a message via Skype™ to CloudedVision
Re: migrating databases

figured out what was wrong. i was on a shared server so all the databases had to start with the prefix "otherroad_"

So after trying to find MySQL query browser's seemingly nonexistant rename database feature, I google, got some quick and dirty method that completely erased my data. After recovering it, I finally created the correctly named database and did a mysql dump via command line to the new database. Then I was able to successfully migrate the database.

All that work for a couple of tables.
__________________
echo "Take it easy, ".$CloudedVision;
.links { site: other-road-design; blog: only-nerds-allowed; project: resource-fish; organization: ARMIES6; }
<quote>&quot;I think it's wrong that only one company makes the game Monopoly&quot; - <name>Steven Wright</name></quote>
Reply With Quote