Page 1 of 1

updating mysql table schemas

Posted: Thu Oct 28, 2004 2:00 pm
by nleco
I have a local mysql database installation. i've been working remotely through a server, however, am thinking of going back. what's the quickest way to update my table schemas (or add new tables)....

thanks.

Posted: Thu Oct 28, 2004 3:11 pm
by mudkicker
you can use the sql syntax "ALTER TABLE"

Posted: Thu Oct 28, 2004 3:17 pm
by lostboy
dump the current db, drop the old local one, restore the dump

copy the files from the remote servers, if you have access, depends on table types too...innodb needs a true backup/restore to work well