At 5:59 PM +0100 2000-06-15, Geoff Beaumont wrote:
>Is there any way of converting an entire database from isam to myisam
>tables, other than changing each table individually?
>
>I've tried giving wildcards to the alter table command, but it just returns
>syntax errors.
>
>System is:
>WinNT4sp6
>MySQL 3.23.18-alpha
Under UNIX, you could do this:
mysql -e "show tables" --skip-column-names -s db_name \
| sed 's/.*/ALTER TABLE & TYPE=MYISAM;/' > junk
That gives you a file of ALTER TABLE commands that you can
feed into mysql to execute (after you check it to make sure
it looks like what you want):
mysql db_name < junk
Does Windows have something like the sed (stream editor)
command you can use?
--
Paul DuBois, paul@stripped
