updating mysql table schemas

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
nleco
Forum Newbie
Posts: 9
Joined: Mon Oct 11, 2004 4:50 pm

updating mysql table schemas

Post 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.
User avatar
mudkicker
Forum Contributor
Posts: 479
Joined: Wed Jul 09, 2003 6:11 pm
Location: Istanbul, TR
Contact:

Post by mudkicker »

you can use the sql syntax "ALTER TABLE"
lostboy
Forum Contributor
Posts: 329
Joined: Mon Dec 30, 2002 8:12 pm
Location: toronto,canada

Post 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
Post Reply