snubbr.com

GoDaddy reviews : Advise I try GoDaddy?? Easy way to move a MySQL DB between hosts?

Get GoDaddy web hosting for just $1.99. Click here to use coupon...

Special $7.49 .COM sales. Click here for this special deal...


My host fucked me and I signed up for a new one. I need to move all my sites, including the data bases to the new host. What is the best way to move the DB's? Should I just back them up and then restore them to the new host?..

Comments (6)



I just download the .sql file then copy and paste into the new hosts mysql database..

Comment #1



Do you just export it, create a new DB on the new host and import it back?..

Comment #2



I'm assuming you have access to the old host still since you're asking if you can just export it. You could do that but if you're running cpanel you can just transfer the whole site in WHM panel including dbs...

Comment #3



Cpanel on the old site, GoDaddy's gay interface on the new site..

I usually won't use anything that doesn't have cpanel, but GoDaddy is the only host with reasonable month to month and this is just some temporary side stuff that I don't want on my main hosting account. The old host I had them on is MidPhase and they are shitty...

Comment #4



If you're using phpMyAdmin export it as SQL without compression, which is usually selected by default, and it'll bring you to a page with a text area with the code in it. Copy and paste that into a text file..

Then on your other server, open up whatever database management software GoDaddy uses. Find a query button, it should bring you to a page with a text area - then just copy and paste the code from your text file..

It'll automatically re-create your table structure and insert all of your data...

Comment #5



The phpMyAdmin method works very well.

Alternatively, if you have shell access, On your current server ... Run the SSH command ...

Mysqldump -uUSERNAME -pPASSWORD DATABASE > dump.txt.

Upload it to the new server and run.

Mysqldump -u<username> -p<password> <database name> < dump.txt.

That should have you set on the new server ....

If the database is pretty big, you might want to consider using bigdump..

BigDump: The Staggered MySQL Dump Importer.

Anarkist..

Comment #6


This question was taken from a support group/message board and re-posted here so others can learn from it.

 

Categories: Home | Diet & Weight Management | Vitamins & Supplements | Herbs & Cleansing |

Sexual Health | Medifast Support | Nutrisystem Support | Medifast Questions |

Web Hosting | Web Hosts | Website Hosting | Hosting |

Web Hosting | GoDaddy | Digital Cameras | Best WebHosts |

Web Hosting FAQ | Web Hosts FAQ | Hosting FAQ | Hosting Group |

Hosting Questions | Camera Tips | Best Cameras To Buy | Best Cameras This Year |

Camera Q-A | Digital Cameras Q-A | Camera Forum | Nov 2010 - Cameras |

Oct 2010 - Cameras | Oct 2010 - DSLRs | Oct 2010 - Camera Tips | Sep 2010 - Cameras |

Sep 2010 - DSLRS | Sep 2010 - Camera Tips | Aug 2010 - Cameras | Aug 2010 - DSLR Tips |

Aug 2010 - Camera Tips | July 2010 - Cameras | July 2010 - Nikon Cameras | July 2010 - Canon Cameras |

July 2010 - Pentax Cameras | Medifast Recipes | Medifast Recipes Tips | Medifast Recipes Strategies |

Medifast Recipes Experiences | Medifast Recipes Group | Medifast Recipes Forum | Medifast Support Strategies |

Medifast Support Experiences |

 

(C) Copyright 2010 All rights reserved.