There are some other things you can do with innodb. Bit longer instructions and I am pretty lazy. So I asked google to find someone who typed it for me. Here you go:
http://forums.mysql.com/read.php?35,121880,121886 Also, pretty easy to move your installation onto a new disk that is bigger. All your settings and stuff are stored in text files, for the most part. I will let you google that for yourself if you feel inclined to do it. To: [email protected] CC: [email protected] From: [email protected] Date: Fri, 10 May 2013 18:02:16 +0200 Subject: [Baruwa] Rif: Re: Rif: Re: Rif: Re: compacting database mysql baruwa because i have 3 Gb free space in server and when i ha installed baruwa i had about 8Gb i would like not to take time to install it again in other server more big and start from zero i would like to recover space from deletion of all messages but it doesn't seem possibile and i don't believe Da: Jeremy McSpadden <[email protected]> Per: Baruwa users list <[email protected]>, Data: 10/05/2013 17:59 Oggetto: Re: [Baruwa] Rif: Re: Rif: Re: compacting database mysql baruwa Inviato da: [email protected] Space is cheap. Not sure why your trying to recover a few hundred MBs. -- Jeremy McSpadden Flux Labs, Inc | http://www.fluxlabs.net | Endless Solutions Office : 850-250-5590x101 | Cell : 850-890-2543 | Fax : 850-254-2955 On May 10, 2013, at 10:48 AM, "[email protected]" <[email protected]> wrote: from shell mysql i have tryed this command: ALTER TABLE messages "ENGINE"='InnoDB'; i cannot recover the space. it's very strange that there is not possible to compact database mysql and recover space thanks Da: marco rosenstein <[email protected]> Per: Baruwa users list <[email protected]>, Data: 10/05/2013 17:23 Oggetto: Re: [Baruwa] Rif: Re: compacting database mysql baruwa Inviato da: [email protected] Sounds like you have a InnoDB table, not MyISAM. You can make OPTIMIZE TABLE work on other engines by starting mysqld --skip-new To: [email protected] CC: [email protected] From: [email protected] Date: Fri, 10 May 2013 17:18:11 +0200 Subject: [Baruwa] Rif: Re: compacting database mysql baruwa the exact message is: TABLE DOES NOT SUPPORT OPTIMIZE,DOING RECREATE+ANALYZE Da: "Morgan, Jeffrey R" <[email protected]> Per: "[email protected]" <[email protected]>, Data: 10/05/2013 17:15 Oggetto: Re: [Baruwa] compacting database mysql baruwa Inviato da: [email protected] Have you run ‘OPTIMIZE TABLE’? See http://stackoverflow.com/questions/3927690/howto-clean-a-mysql-innodb-storage-engine/4056261#4056261 for some helpful information (and some considerations regarding the growth of ibdata1 From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, May 10, 2013 10:34 AM To: [email protected] Subject: [Baruwa] compacting database mysql baruwa hi i have deleted all messages from tables MESSAGES & ARCHIVE from mysql database baruwa i have launched baruwa-admin dbclean >/dev/null 2>&1# and it had taken about1 hour but the disk space is same what can i do to free compact database so i will have more free space Thanks Fabio_______________________________________________ http://pledgie.com/campaigns/12056 _______________________________________________ http://pledgie.com/campaigns/12056_______________________________________________ http://pledgie.com/campaigns/12056 _______________________________________________ http://pledgie.com/campaigns/12056_______________________________________________ http://pledgie.com/campaigns/12056 _______________________________________________ http://pledgie.com/campaigns/12056
_______________________________________________ http://pledgie.com/campaigns/12056
