Help! Need to move Data base

Posted by  in Tuesday, June 13th 2006   
6 Comments

I’m in the process of moving Tricia’s Musings over to it’s new location http://www.feverishthoughts.com and I think I know what I’m doing. Maybe … we’ll see. Anyway, I’ve copied all of the files and I’m ready to move them over to the new site but I’m in the process of trying to move the sql database.

Any help out there? Do I just use the export function in phpmyadmin? exporting it to the new databases name?

The site is still going to be on the same hosting server. It will just be under a new domain on that server.

Another idea. Can I just use the change directory function in wordpress’ option section? Then move the files and somehow the magic within wordpress will let my sql database know that the address of the site is different but the data base should remain the same?

Is anyone out there? If you have tried something like this before, by all means help me out.

Thank you!

Related Reading:

The Weaver's Inkle Pattern Directory: 400 Warp-Faced WeavesThe Weaver's Inkle Pattern Directory: 400 Warp-Faced Weaves
Magellan RoadMate RV9165T-LM - 7-Inch GPS Navigator for RVersMagellan RoadMate RV9165T-LM - 7-Inch GPS Navigator for RVers
Richard Pryor Collection: 4 Film Favorites (Greased Lightning / Moving / The Mack / Uptown Saturday Night)Richard Pryor Collection: 4 Film Favorites (Greased Lightning / Moving / The Mack / Uptown Saturday Night)
Hosting the Presence: Unveiling Heaven's AgendaHosting the Presence: Unveiling Heaven's Agenda
We're Moving (First-Time Stories)We're Moving (First-Time Stories)

Share and Enjoy

  • Facebook
  • Twitter
  • Pinterest
  • Google Plus
  • YahooBuzz
  • Delicious
  • Digg
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Topics: Blogging, Data Recovery, Data Storage, Web and Technology, Wordpress
Tags: , , , , , , , ,




Related Post

Spread the word

Add to your technorati favourite

SUBSCRIBE to this post



6 users responded to this post

Mr. Fabulous said in June 13th, 2006 at 5:40 am    

Oh, hon, I wish I could help you, but my head hurts just thinking about it.

Good luck! :(

David said in June 13th, 2006 at 7:55 am    

Much depends on what type of sql dbase it is and whether or not you use relative or fixed references to the dbase location and most importantly if the name of the dbase and the access codes are the same.

The dbase itself does not care about the domain while the access code may use a dns lookup to find the physical address of the machine on which the dbase is located.

In most apps the address is a relative address on the same machine thus not important. If the dbase is the same and the access codes are the same than exporting from one machine to the other will not create any problems.

Ed said in June 13th, 2006 at 9:56 am    

You should be able to use the WordPress interface to export this to a file, and then, having setup WordPress there, import the file into the database there.

Joefish said in June 13th, 2006 at 10:59 am    

I hate to dispute David, but the database does care about your URL. You’ll need to export your db using either PHPMyAdmin or Skippy’s Backup plugin. Then you’ll need to open the .sql file in a text editor to replace all references to the old domain with appropriate references to the new domain before importing it on your new domain.

The WP Codex has detailed instructions on the entire process here: http://codex.wordpress.org/Moving_WordPress

I’m pretty handy with this sort of thing. If you need assistance, I’d be happy to help.

ABlondeBlogger said in June 13th, 2006 at 5:05 pm    

I wish I could be of help, but I’m clueless when it comes to this stuff. Good luck with the move!

jean said in June 14th, 2006 at 4:36 am    

its actually very simple, if you can generate a sql script using phpmyadmin copy/paste and click on go.
if you have any doubt email me.

http://www.irin.co.uk

Leave Your Comments Below

Comments are moderated. Your comments are welcome, but if you leave comment spam your comment and url(s) will be deleted!

«
»