MySQL Question and Answers

How do you start and stop MySQL on Windows? – net start MySQL, net stop MySQL
How do you start MySQL on Linux? – /etc/init.d/mysql start
Explain the difference between mysql and mysqli interfaces in PHP? – mysqli is the object-oriented version of mysql [...]

Read Full Post »

How do I reclaim Space from the INNODB (Ibdata) file?

This is the major issue with the Innodb engine, the bulk delete/truncate operation will deleted the data but it is not reclaiming the space from the Innodb file. There are some techniques to reclaim the space but please make sure you must have the extra space on your servers.
1. Alter Database Set Engine = Innodb
2. [...]

Read Full Post »