Re: Changing root password

2002-01-16 Thread Richard Ward
If you have just finished installing, then root has no current password and you can leave out the -p altogether: root@localhost bin]# ./mysqladmin -u root password 'new-password' good luck Richard Ward >>> "Jay Paulson" <[EMAIL PROTECTED]> 01/16/02 12:57AM

2 masters 1 slave replication

2002-01-14 Thread Richard Ward
servers store information about the mail they send in their individual databases, and theoretically would replicate the information down to the database server where queries can be run on all the data. Is this type of replication possible? Thanks Richard Ward

Re: new bee - Mysql Database Update Problem

2002-01-14 Thread Richard Ward
It seems like you have hit a file size limit. Soalris has a 2 Gig ( or is it 4Gig) file size limit which is restricting your database. You could get past this by breaking up your data into different segments, eg. group the data by month and store it in monthly tables, reducing the size of the dat

Re: bin files

2001-11-22 Thread Richard Ward
file is) file by hashing out the line with: log-bin server-id = x (where x is a number) to #log-bin #server-id hope this helps. cheers richard ward >>> "Richard Clarke" <[EMAIL PROTECTED]> 11/22/01 11:06PM >>> So I have found out that mysql creates bin