LinuxQuestions.org
LinuxAnswers - the LQ Linux tutorial section.
Go Back   LinuxQuestions.org > Forums > Enterprise Linux Forums > Linux - Enterprise
User Name
Password
Linux - Enterprise This forum is for all items relating to using Linux in the Enterprise.

Notices

Reply
 
Search this Thread
Old 07-25-2013, 09:50 PM   #1
fruitwerks
Member
 
Registered: Apr 2009
Posts: 74

Rep: Reputation: 15
Moving large mySQL database


Hi All, this is not exactly an e-class question, but I think this section would provide the best answer.

First off, I have a 3gb database and no shell / ssh access to the source machine. I have root access on the target. I have tried using the provided export methods (cpanel backups!) but they do not produce a viable database dump.

Short of stopping mysql, creating a tar of the database and copying it over to the target, I am at a loss, and as mentioned I do not have this level of access.

Is there a way to pull the database to the source machine directly from a remote mysql connection? Or some other method I haven't mentioned? Something like a manual one-shot replicate?

Thank You!
 
Old 07-26-2013, 01:36 AM   #2
j-ray
Senior Member
 
Registered: Jan 2002
Location: germany
Distribution: ubuntu
Posts: 1,425

Rep: Reputation: 100Reputation: 100
Could you run a phpMyAdmin on your box and connect it to the db you want to copy? Then you could export the db thru phpMyAdmin...

Can you connect to the db server with a local mysql client maybe? Probably the server is not configured to allow that.

Last edited by j-ray; 07-26-2013 at 01:37 AM.
 
Old 08-01-2013, 06:49 AM   #3
chrism01
Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.5, Centos 5.10
Posts: 16,264

Rep: Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028
https://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
mysqldump will create a valid backup and you can give it a remote host to access.
You will need the mysql root (aka dba) acct to backup all the DBs OR the owner acct for each db (ie schema) you want to backup.
 
Old 08-01-2013, 08:50 AM   #4
fruitwerks
Member
 
Registered: Apr 2009
Posts: 74

Original Poster
Rep: Reputation: 15
Thanks all, after posting, I did remember that mysqldump did allow for the host argument. Using this method I was able to get a good dump. cPanel dumps were no good, although they were almost as big, mysqldump was the winner.
 
  


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
[SOLVED] Moving only ONE MySQL database to a different folder, is it possible? lpallard Linux - Server 2 12-30-2012 12:01 PM
Moving and replacing entries in a MySQL database kaplan71 Linux - Software 4 04-21-2008 09:06 PM
SUSE / MySQL --Very Large Database 1kyle Suse/Novell 1 06-30-2006 04:07 PM
Moving mySQL database subnet_rx Linux - Software 12 06-30-2004 04:41 PM
Transfering a large MySql database E-Oreo Programming 3 06-04-2004 07:15 AM


All times are GMT -5. The time now is 04:37 AM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration