Share your knowledge at the LQ Wiki.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
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!


  Search this Thread
Old 12-27-2013, 03:40 AM   #1
byran cheung
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 .
Old 12-27-2013, 02:54 PM   #2
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...

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

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, 04:03 PM   #3
LQ 5k Club
Registered: Jan 2011
Location: Nowhere near you, thank God.
Distribution: OSX Sierra
Posts: 8,573
Blog Entries: 15

Rep: Reputation: Disabled
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, 12:57 PM   #4
Registered: Mar 2008
Posts: 17,101

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


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 05:06 PM
copy support-files/mysql.server, how do I tommytomato Fedora 2 11-13-2009 11:58 PM
How do I make a copy of mysql database intale(located) on linux server jenny1668 Linux - Newbie 1 10-02-2006 08:02 AM
How to copy mysql db's from hardisk to new server? nbier Linux - Software 4 09-01-2004 04:24 PM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 06:42 PM.

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