host table in mysql database

Hi there, I'm cleaning up MySQL permissions on one of my servers, and I see that in the mysql.host table, there are 8 rows. All 8 rows contain specific hosts in the 'Host' column (i.e. no wildcards) and specific databases in the 'Db' column. Further, all rows in all privilege columns in the hos

Replication error: 'Could not initialize master info'

the master as outlined in the manual. Both master and slave are currently using databases with ISAM tables rather than MyISAM tables (although the 'mysql' database is, of course, MyISAM). I'm not using InnoDB tables. Can anyone give me an idea of how to troubleshoo

Re: Replication error: 'Could not initialize master info'

Hi list, My original post concerning this issue is below - it was a week or so ago. No replies were forthcoming, but I'm pleased and a bit embarrassed (so simple) to say that I have figured it out, and my slave is now replicating from the master. The problem was that the mysql data directory wa

'mysqladmin slave-st(art|op)' - is it implemented?

rough the change logs for version 4, and can't find any mention of them in there... Can anyone tell me whether these options for mysqladmin are implemented? If not, can anyone tell me whether I can tell mysqld to stop or start replicating from a shell script rather than the mysql client? Than

Re: 'mysqladmin slave-st(art|op)' - is it implemented?

Hello again, Turns out it is implemented - but it's 'stop-slave' and 'start-slave'. Shoulda done a 'mysqladmin --help'. Grepping the source found it. - GW. >Date: Wed, 29 Jan 2003 11:19:06 +1100 >To: [EMAIL PROTECTED] >From: Guy Waugh <[EMAIL PR

Best way to duplicate a table in a running database?

o i haven't had to touch it much yet ;-) Thanks, Guy. -- Guy Waugh <[EMAIL PROTECTED]>, tel. 61+2 6620 3196 Unix Team, Information Technology Services Southern Cross University Military Rd, Lismore NSW 2480 Australia. -- --