Please register or login. There are 0 registered and 1167 anonymous users currently online. Current bandwidth usage: 326.30 kbit/s December 13 - 09:50am EST 
Hardware Analysis
      
Forums Product Prices
  Contents 
 
 

  Latest Topics 
 

More >>
 

    
 
 

  You Are Here: 
 
/ Forums / Linux /
 

  Migrating MySQL database from one server two another (bot... cPanel & MyAdmin) 
 
 Author 
 Date Written 
 Tools 
Richard Jun 22, 2005, 04:01pm EDT Reply - Quote - Report Abuse
Private Message - Add to Buddy List Replies: 5 - Views: 12626
I need to move a entire database from one server to another.

(actualy they could be on the same server, but different accounts, so may as well be a different server).

It seems pretty straigt forward to back up a databse, along with tables and contents.

But I can't figure out how to reinstate/import it on to the new server.

I could re build the tables by hand and import the data, but that would be a lot of work, and computers are supposed to do the hardwork for you. ;)

Does anyone here know how to do it with MyAdmin/cPanel, or of a third party tool that could help?


Thanks.




Want to enjoy fewer advertisements and more features? Click here to become a Hardware Analysis registered user.
Vitaliy (Administrator) Jun 22, 2005, 04:14pm EDT Reply - Quote - Report Abuse
Private Message - Add to Buddy List

Edited: Jun 22, 2005, 04:17pm EDT

 
>> Re: Migrating MySQL database from one server two another (both Linux with cPanel & MyAdmin)
From command line, you can do:

mysqldump databasename >file.sql

to dump database to a file, and:

mysql newdatabasename <file.sql

to restore it.

You should also look into MySQL Administrator which is a very nice GUI tool that lets you do backups, among other things. You can download it from http://www.mysql.com/products/administrator/

Richard Jun 22, 2005, 07:11pm EDT Reply - Quote - Report Abuse
Private Message - Add to Buddy List

Edited: Jun 22, 2005, 07:12pm EDT

 
>> Re: Migrating MySQL database from one server two another (both Linux with cPanel & MyAdmin)
Thanks Vitaliy,

That seems easy enough, problem is I'm using two cheapo shared hosting accounts (from the same company) and don't have accses to the command line (only cPanel and MyAdmin).

I also don't have permisions to install MySQL Administrator. :(

After posting this thread I noticed cPanel has a neat little utility to do just what I need, backup and reinstate, but for some reason it's been disabled.

Seems stupid, they stipulate that you are resbonsible for backing up your data, then disable the backup utility. WTH is going on there?? Surley there can't be a security risk in backing up your data?

I'll email them tommrow and see.


Vitaliy (Administrator) Jun 22, 2005, 10:36pm EDT Reply - Quote - Report Abuse
Private Message - Add to Buddy List  
>> Re: Migrating MySQL database from one server two another (both Linux with cPanel & MyAdmin)
MySQL Administrator is a Windows GUI application that you can install on your own computer. You can then connect to your MySQL database with a username/password and do backup/restore.

Richard Jun 23, 2005, 07:40am EDT Reply - Quote - Report Abuse
Private Message - Add to Buddy List  
>> Re: Migrating MySQL database from one server two another (both Linux with cPanel & MyAdmin)
ahh, right I see, I'll give it a go.

Thanks.


Richard Jun 25, 2005, 07:31am EDT Reply - Quote - Report Abuse
Private Message - Add to Buddy List  
>> Re: Migrating MySQL database from one server two another (both Linux with cPanel & MyAdmin)
I found this PHP script which looks pretty good:

http://www.forum.ukhost4u.com/viewtopic.php?t=923&highlight=backup

Though I won't need to use it this time.

I contacted my host, asking why the backup feture was disabled, apparently it's becasue it was using too much CPU resources.

The nice guy in tech support is moving the files for me. Thats pretty good service:

http://www.low-cost-space.com



Write a Reply >>


 

    
 
 

  Topic Tools 
 
RSS UpdatesRSS Updates
 

  Related Articles 
 
 

  Newsletter 
 
A weekly newsletter featuring an editorial and a roundup of the latest articles, news and other interesting topics.

Please enter your email address below and click Subscribe.