LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 12-27-2013, 02:40 AM   #1
byran cheung
Member
 
Registered: Sep 2013
Posts: 321

Rep: Reputation: Disabled
copy all mysql thngs to another server


I have a redhat server , there are mysql databases running on it , I just would like to copy everything of mysql (database , permission , user id ... etc ) to another server .

I search from web , one method is mysqldump database from it and then import to another server , could advise if this method could copy Everything includes permission , user id to another server ?

what I worry is just that I don't not to miss anything when migration. Thanks a lot .


http://dev.mysql.com/doc/refman/5.0/...databases.html
 
Old 12-27-2013, 01:54 PM   #2
custangro
Senior Member
 
Registered: Nov 2006
Location: California
Distribution: Fedora , CentOS , RHEL
Posts: 1,977
Blog Entries: 1

Rep: Reputation: 209Reputation: 209Reputation: 209
I've always done this...

Code:
mysqldump --user=root --password=password -A > mysql_bkup.sql
Then on the other database server...

Code:
mysql --user=root --password=password < mysql_bkup.sql
YMMV, so I'd test this on a test VM machine first.

Another thing you can do is use rsync to sync the directories over to another machine...but I don't recommend this.

Since you have Red Hat, you can ask support for assistance with this
 
Old 12-27-2013, 03:03 PM   #3
Habitual
LQ Addict
 
Registered: Jan 2011
Posts: 8,241
Blog Entries: 11

Rep: Reputation: 2287Reputation: 2287Reputation: 2287Reputation: 2287Reputation: 2287Reputation: 2287Reputation: 2287Reputation: 2287Reputation: 2287Reputation: 2287Reputation: 2287
Can you clarify "copy" and "migrate".

Are you moving the db to a new host or merely just copying the data (say, as an experience building exercise)?
 
Old 12-28-2013, 11:57 AM   #4
jefro
Moderator
 
Registered: Mar 2008
Posts: 16,350

Rep: Reputation: 2376Reputation: 2376Reputation: 2376Reputation: 2376Reputation: 2376Reputation: 2376Reputation: 2376Reputation: 2376Reputation: 2376Reputation: 2376Reputation: 2376
Read some of these for more info.

http://dba.stackexchange.com/questio...ver-to-another
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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



Similar Threads
Thread Thread Starter Forum Replies Last Post
data copy from mysql to samba server Zafermalik Linux - Server 5 07-18-2011 04:06 PM
copy support-files/mysql.server, how do I tommytomato Fedora 2 11-13-2009 10:58 PM
How do I make a copy of mysql database intale(located) on linux server jenny1668 Linux - Newbie 1 10-02-2006 07:02 AM
How to copy mysql db's from hardisk to new server? nbier Linux - Software 4 09-01-2004 03:24 PM


All times are GMT -5. The time now is 06:55 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration