How can I export compressed databases in MySQL?

2008-03-31 Thread 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

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

2008-03-11 Thread 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