Entry

How can I update my development database with data from the production server?

May 18th, 2000 20:30
Nathan Wallace, indrek siitan

Does the information change in your internal database? if not, you can
just acquire the required privileges and run these 2 commands from a
machine that can access both the databases and has MySQL clients
installed:

  mysqldump --opt -uuser -ppasswd -hwebsite.host database > /some/file
  mysql -uuser -ppasswd -hinternal.host database < /some/file

that will dump the database into /some/file and load it into your local
mysql database. the file includes drop table statements, so it deletes
the local table (and all the information in it) before re-creating and
populating it.