----- Original Message -----
> From: "Manivannan S." <manivannan_s@stripped>
>
> How to reduce the ibdata1 file size in both LINUX and WINDOWS
> machine.
This is by design - you cannot reduce it, nor can you remove added datafiles.
If you want to shrink the ibdata files, you must stop all connections to the server, take
a full backup, stop the server, remove the datafiles (and maybe change the config),
restart the server (will take time to recreate emtpy datafiles) and then import the
backup.
For new tables, you can turn on the option innodb_file_per_table - then every (new) table
gets it's own datafile; and when you drop the table, that datafile also gets deleted.
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
