Re: backup InnoDB db to another server

2007-11-30 Thread David Campbell
Jørn Dahl-Stamnes wrote: On Friday 30 November 2007 17:12, Jeff Mckeon wrote: Ok, so what would be the command to get a mysqldump of DB1 from 10.10.0.1 into file DB1backup.sql on 10.10.0.2? What about running mysqldump on 10.10.0.2? or scp dump.sql [EMAIL PROTECTED]:. Onliner mysqldump

Re: preferred way to backup a 20GB MySQL database

2007-11-27 Thread David Campbell
Andras Kende wrote: Hi, What is the preferred way to backup a 20GB database daily, without taking offline ? MySQL 4.1 MyISAM - (will be updated to MySQL 5) 133 table(s) Sum 115,416,561 latin1_swedish_ci 20.1 GB Mysqlhotcopy -- MySQL General Mailing List For list archives:

Re: secure mysql port

2007-11-13 Thread David Campbell
Kelly Opal wrote: Hi Is there any way to restrict access to the tcp port on mysql. I only want my 5 class C's to be able to access the port but it is a public server. Iptables Dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Replication Issue with Upgrade from 4.0.x to 5.0.x

2007-11-13 Thread David Campbell
[EMAIL PROTECTED] wrote: I'm in process of upgrading a master server from 4.0.24-log to 5.0.22-log in a single master-slave environment. I've previously upgraded the slave to 5.0.22-log and restarted replication without issue. The current master is running on RH9 and the slave is running on

Re: NFS

2007-11-07 Thread David Campbell
Charles Jardine wrote: I am planning to set up a system in which mysql servers access their data via NFS. All the computers involved run Solaris 10. NFS version 4 will be used. I plan to ensure that no NFS share is ever mounted by more than one client computer, and that no client computer ever

Re: Virtual Hosting Privileges

2007-11-04 Thread David Campbell
Grant Peel wrote: Hi all, This is my first post to this list so bear with me if I ramble on a bit. I have been reading as much as I can on this subject and am yet to feel confident about an answer so I thought I would throw it at this list and see what comes back. One thing I should

Re: Mysql and filesystems question

2007-10-29 Thread David Campbell
B. Keith Murphy wrote: I dashed off this email too fast. What I meant to say was I am migrating our data partitions for MySQL from reiserfs to xfs because xfs has faster write rates than reiserfs. Those fast writes come at a price. There is no way I'd have any important data on XFS. Dave

Re: High Traffic Sites

2007-10-22 Thread David Campbell
Erich C. Beyrent wrote: Craig, Thank you for your insight. Having never worked with clustering solutions, what kinds of headaches might one see with that solution? Does anyone know of any white papers that might shed some light into the pros and cons of each solution? You *did* look at