hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Web Hosting : How to move transfer mySQL databases to new server?
Reply

Forum Jump

How to move transfer mySQL databases to new server?

Reply Post New Thread In Web Hosting Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 05-14-2007, 12:20 PM
smsmasters smsmasters is offline
Junior Guru
 
Join Date: Apr 2003
Posts: 190

How to move transfer mySQL databases to new server?


Hi,

I managed to copy one of my websites onto my new VPS using "Copy an account from another server" in WHM, however, it did not copy the mySQL database.

Is this normal?

What is the best way to move a mySQL database?

__________________
SmsMasters.co.uk - The latest technology news and information updated daily. Online since 2002.



Sponsored Links
  #2  
Old 05-14-2007, 12:33 PM
Jedito Jedito is offline
Web Hosting Master
 
Join Date: Apr 2001
Location: Paradise
Posts: 11,527
If you have SSH access do this

mysqldump -u username -p --databases mydatabase > mydatabase.sql

to backup and

mysql -u userame -p database < dump_file

To restore it.

__________________
Shared Web Hosting - Reseller Hosting - Semi-Dedicated Servers - SolusVM/XEN VPS
LiteSpeed Powered - R1Soft Continuous Data Protection - 24/7 Chat/Phone/Helpdesk Support - US/EU/Asia Servers
Cpanel/WHM - Softaculous - R1soft Backup - Litespeed - Cloudlinux -Site Builder- SSH support - Account Migration
DowntownHost LLC - In Business since 2001 - Toll Free:*1-877-384-6781*

  #3  
Old 05-14-2007, 12:57 PM
milleniahost milleniahost is offline
Newbie
 
Join Date: May 2007
Location: Miami, FL
Posts: 11
Or via phpmyadmin, simply export the database and then import it again via phpmyadmin. Might not work depending on the database size but it is easy to do

__________________
MilleniaHost.Com - 100% Satisfaction Guaranteed or your money back.
CPANEL Hosting with Fanatical Support, check us out.

Sponsored Links
  #4  
Old 05-14-2007, 01:23 PM
jonwatson jonwatson is offline
Web Hosting Master
 
Join Date: Jul 2006
Location: Nova Scotia Canada!
Posts: 783
To answer the first part of the OP's post: no, that is not normal, however the WHM transfer process has lots of problems with it.

__________________
jonwatson.ca

  #5  
Old 05-14-2007, 01:45 PM
ImageLeet ImageLeet is offline
Web Hosting Master
 
Join Date: Oct 2006
Posts: 898
yes its normal as cPanel bakup utility can be configured to take backups including MySql but its not always the case.
you can always export database from phpmyadmin on old host and import it from phpmyadmin on new host

__________________
Imageleet.com - Premium Hosting Solutions Since 2006
Shared Hosting, FFmpeg Hosting, Linux VPS and Dedicated Solutions.
SSD, Litespeed powered, R1soft, cPanel | Softaculous | Rvsitebuilder + FFmpeg, Mencoder, Mplayer, Flvtool2, x264
http://www.imageleet.com

  #6  
Old 05-14-2007, 02:04 PM
atexit8 atexit8 is offline
Web Hosting Evangelist
 
Join Date: Mar 2003
Location: eastern USA
Posts: 539
I can vouch for moving database with PhpMyAdmin.

Worked flawlessly when I moved website from one server to another with different versions of MySQL at my webhost.

  #7  
Old 05-14-2007, 02:13 PM
SparkSupport SparkSupport is offline
Web Hosting Master
 
Join Date: May 2006
Posts: 646
Mysql incompatiblity occurs only when restoring from a higher version to a lower one but vice-verca it works without any flaws.

__________________
SparkSupporT
http://sparksupport.com
sales@sparksupport.com
1- 408-335-0493

Reply

Related posts from TheWhir.com
Title Type Date Posted
Google Releases Hosted Database Service Cloud SQL to General Availability Web Hosting News 2014-02-12 13:46:02
Google Cloud Provides Support For Native MySQL Connections Web Hosting News 2013-11-01 14:36:06
WiredTree Upgrades Resources for VPS and Hybrid Hosting Plans Web Hosting News 2013-08-07 14:21:37
Web Hosting Sales and Promos Roundup - April 12, 2013 Web Hosting News 2013-04-12 16:11:36
Web Host AIT Releases New Version of Server Management Control Panel Web Hosting News 2012-08-27 13:23:00


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?