Newbie Replication Issues

2002-11-18 Thread Rick Root
I have a few questions about Replication. I've already read the basic replication page here: http://www.mysql.com/doc/en/Replication_HOWTO.html I am running MySQL-MAX 3.23.53 for Linux on my master server, and the same version on Windows 2000 for the slave. #1 - Can I replicate from Linux to

The mysql.db table

2002-11-14 Thread Rick Root
he proper way to REMOVE a user from the system to delete them from the mysql.user table? Ie, "delete from user where user='foo'"? Thanks! Rick Root - Before posting, please check: http://www.mysql.com/manua

MySQL and Open Directory RDF Data (UTF-8)

2002-11-14 Thread Rick Root
Has anyone here tried to put Open Directory RDF data (ie, www.dmoz.org) into MySQL? I've done this fairly successfully with the exception of the non-English characters (primarily the stuff in the "World" category). The data is in UTF-8 which is a character set that MySQL doesn't seem to suppo

Upgrading MySQL from 3.23.41 to 3.23.53a

2002-11-13 Thread Rick Root
@frodo MySQL]# So what should I do? Do I need to actually remove the old MySQL first and then install the new one? - Rick Root - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Moving a MySQL database

2002-11-13 Thread Rick Root
I need to move a whole bunch of web sites from one server to another. This means moving cold fusion, MySQL, qmail, etc.. fun stuff. What's the best way to move *ALL* of the MySQL databases on my system? Do I basically just shut down the database, tar up the /var/lib/mysql directory and move it t