How can I export compressed databases in MySQL?

[Marcos Vinícius Vieira dos Santos]

Hello everyone,

I have to export my databases and I get large files for my dump.

How can I export compressed databases in MySQL?

I use:  #mysqldump --default-character-set=latin1 -u'name_user' -p'pass'  
'database_name'  $path/file_name.sql;


Thanks,

Marcos Santos





  Abra sua conta no Yahoo! Mail, o único sem limite de espaço para 
armazenamento!
http://br.mail.yahoo.com/

Store MySQL data files and log files (log bin) separated!!!

[Marcos Vinícius Vieira dos Santos]

Hello everyone,

I am compiling mysql source and need stored MySQL data files and log files (log 
bin) separated. For example:

/var/log/mysql  /* log files

and 

/sgdb/data  /* data files


 I used --localstatedir in ./configure but both data files and log files was  
stored  together. 

How do this


Thanks


Marcos Santos




  Abra sua conta no Yahoo! Mail, o único sem limite de espaço para 
armazenamento!
http://br.mail.yahoo.com/