If I have amast/salve pair where the slave is replicating from
the master then do the table types have to be the same ?
Specifically can I have a myisam table on the master and replicate to
a bdb table on the slave ?
The reasoning behind this is to try and find a *fast* was to convert
a MYISAM t
> CREATE TABLE new_table ()
> TYPE=BDB;
> INSERT INTO new_table SELECT * FROM old_table;
> CREATE INDEX ... ON new_table;...
> ALTER TABLE new_table ADD PRIMARY KEY (...);...
> RENAME old_table TO old_table_bak;
> RENAME new_table TO old_table;
>
> That should cause a downtime of less than a seco
> Yeah, just go with InnoDB. :-)
any good ? I took a look at the documentation, but it all seemed somewhat
heavyweight for my liking...
I have an application that runs very nicely at the moment - we have one minor
problem which is that we have one insert into two tables which may not hapen
prope
> mysql> show databases;
> +-+
> | Database|
> +-+
> | CarbonUFSVolumeInfo |
> | mnta|
> | mntb|
> | vi.recover |
> +-+
> 4 rows in set (0.04 sec)
Umm, those look very much like files
> We are discussing the 'mysql' client which is often used to write
> scripts that run under the
> UNIX shell.
...
> If you write a script that has two semi-colons in a row, the second one
> is ignored and no error message is given.
Err, not true (in amysql script anyway)
I think you are tryi
> am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show
> characters of language such as hebrew/arabic?
My best suggestion would be to store all your test in Unicode UTF-8 format
and use the type BLOB in the table in order to store it. We do this
and can quite happily mix
> You need to create a new user and group for mysql.
> Open your OSX manuals and start reading.
Additional hint - nidump and niload will do the trick (assuming
it works like alll other NeXT systems, which it seems to).
-pcf.
-
> Is it possible to use MySQL with a chinese charset (utf8) ?
You need to use BLOB or TEXT types and do a little bit of work yourself
to manage them, but basically it does work fine. mySQL just treats it
as binary data.
-pcf.
-
> >p.s. PLEASE can you put a [mysql] tag on the list???
> Please not, it wastes space on the screen.
not a lot of space - and does have the great advantage that we
can then filter out the mysql stuff into a separate mailbox whihc
(on standard UNIX mail) isnt possible without it.
-pcf.
---
