1. Find out the database location on the system. It is at /var/lib/mysql on my CentOS 5.2. Change to that directory:
cd /var/lib/mysql
2. Stop mySQL server:
/etc/init.d/mysql stop
3. Rename the name of the database.
mv mydb.old mydb.new
4. Rename the table files in the new database directory:
cd mydb.new
mv oldtable.frm newtable.frm
mv oldtable.MYD newtable.MYD
mv oldtable.MYI newtable.MYI
5. Start mySQL server:
/etc/init.d/mysql start
Monday, February 2, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment