Re: Prinitng MySQL Structure from ssh

2006-04-07 Thread alexj
hey, run mysqldump from your command prompt and not you mysql prompt. [EMAIL PROTECTED]:~> mysqldump --no-data osc -u admin -- MySQL dump 10.9 -- -- Host: localhostDatabase: osc Thanx Alex On Fri, 7 Apr 2006, Mark Sargent wrote: > alexj wrote: > > try mysqldump --no-da

Re: Prinitng MySQL Structure from ssh

2006-04-07 Thread alexj
try mysqldump --no-data -u Thanx Alex On Fri, 7 Apr 2006, Mark Sargent wrote: > Hi All, > > we have cli access to our MySQL database via ssh in the Admin GUI > and were wondering how to print the complete structure of a DB. I > searched the documents on MySQL homepage but couldn't find anythi

Re: Multi Master Replication

2006-02-27 Thread alexj
On Mon, 27 Feb 2006, Marvin Wright wrote: Hi, I'm having a few problems at the moment with replication. We are in the process of migrating a cache to 2 new database machines. As the data is a cache its very large is refreshed constantly. Currently we have 2 machines, 1 master and 1 slave.

Re: Database backups

2006-01-25 Thread alexj
On Mon, 23 Jan 2006, George Law wrote: Just a quick question regarding mysql backups. I know myisam tables are portal from machine to machine, but I know there are some differences Between innodb tables. I am running mysql 5.0.18 on suse linux 10. I have innodb set up so it stores each table

Re: replication

2006-01-25 Thread alexj
On Wed, 25 Jan 2006, [iso-8859-1] Morten Kalles?e wrote: Hi on a slave, is it possible to only stop the SQL Thread? (Slave_SQL_Running: Yes/No) i need to do some testing with my script and i got to make sure it reads that value correctly. Please follow this link http://dev.mysql.com/doc/