Textpattern CMS

#1 2012-08-13 18:52:21

tester

Member

Registered: 2012-08-01

Posts: 10

Rsyncing MySQL

This may sound like a dumb question, but I am fairly new to MySQL. Is there a way to accomplish what rsync does, with the database so that I do not have to export and import the entire database to my local copy? I am fine with using shell commands, actually I prefer that to phpmyadmin. I also noticed a 2MB limit on imports on phpmyadmin, is that a phpmyadmin thing or a MySQL issue?

ETA: I guess replication is also an option but I am having a tough time wrapping my head around how that works. Whatever it is, it does not necessarily have to be rsync if that is not the best option. Or maybe rsync is part of a process, just throwing some ideas out there, in case that helps with the assistance. :)

Last edited by tester (2012-08-13 19:03:22)

#2 2012-08-14 00:35:00

bici

Member

From: vancouver

Registered: 2004-02-24

Posts: 2,086

Website Mastodon

Re: Rsyncing MySQL

from the shell

mysqldump --user=USERNAME -p -Q --database DBNAME > ~/backup/mysql/DBNAME/DATE.sql

to sync the backup/ dir = eg:

rsync -rltpqz --delete ~/backup/mysql/ lass.lass.dropbox.com:SQL_BCKUPS/mysql/

---

…. texted postive