Hi,

0. stop the web server or avoid hitting the db !

> 1). Backup everything! :)

the mysqldump should suffice.

> 2). do the alter

The alter does already a create table with new data and then exchance
table. You need 2x the storage space though.

3. do the opposite of 0.


--
Pooly
Webzine Rock : http://www.w-fenec.org/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to