Review your favorite Linux distribution.
Go Back > Forums > Enterprise Linux Forums > Linux - Enterprise
User Name
Linux - Enterprise This forum is for all items relating to using Linux in the Enterprise.


  Search this Thread
Old 07-25-2013, 10:50 PM   #1
Registered: Apr 2009
Posts: 77

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, 02:36 AM   #2
Senior Member
Registered: Jan 2002
Location: germany
Distribution: ubuntu, mint, suse
Posts: 1,550

Rep: Reputation: 137Reputation: 137
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 02:37 AM.
Old 08-01-2013, 07:49 AM   #3
LQ Guru
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.9, Centos 7.3
Posts: 17,411

Rep: Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397
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, 09:50 AM   #4
Registered: Apr 2009
Posts: 77

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.


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 01:01 PM
Moving and replacing entries in a MySQL database kaplan71 Linux - Software 4 04-21-2008 10:06 PM
SUSE / MySQL --Very Large Database 1kyle SUSE / openSUSE 1 06-30-2006 05:07 PM
Moving mySQL database subnet_rx Linux - Software 12 06-30-2004 05:41 PM
Transfering a large MySql database E-Oreo Programming 3 06-04-2004 08:15 AM > Forums > Enterprise Linux Forums > Linux - Enterprise

All times are GMT -5. The time now is 11:47 AM.

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