Database management
Moderator: moderator
Database management
How does an administrator level user delete multiple records and pack the recipient database?
Just as a follow up, the docs do not cover the packing of a database table and it's indexes.
You can do this in a number of ways
a) You can install a tools such as MySQL Administrator and use the maintanance option on the table you wich to pack.
b) You can use the following SQL command from within a command line tool
optimize table [table name]
I find that installing MySQL Administrator is very useful as it gives a good overview of the system and allows system based scheduled backups to be setup.
You can do this in a number of ways
a) You can install a tools such as MySQL Administrator and use the maintanance option on the table you wich to pack.
b) You can use the following SQL command from within a command line tool
optimize table [table name]
I find that installing MySQL Administrator is very useful as it gives a good overview of the system and allows system based scheduled backups to be setup.