Open GoogleCodeExporter opened 8 years ago
s/Observer/Observe/
Original comment by pauli.pr...@gmail.com
on 8 Feb 2012 at 4:37
Pre-migration timestamps were restored, for a mysql database, via the following
process:
# spinning up new server from the backup image, (or load the pre-migration
backup of your production database into a server somewhere)
# connect to the pre-migration backup database
# generate update statements with the following query:
<pre> select concat("update dmsf_file_revisions set updated_at = '",
updated_at, "' where id = ",id,";") from dmsf_file_revisions;</pre>
# place this statement in a file, query.sql, and create update file from the
commandline, like this:
<pre>mysql -u dbuser -ppasswd db_name < query.sql > updates.sql</pre>
# test update statements in a backup of your post-migration production database
# if testing is ok, run sql update on production:
<pre> mysql -u dbuser -ppasswd db_name < updates.sql </pre>
Original comment by pauli.pr...@gmail.com
on 8 Feb 2012 at 9:28
Original issue reported on code.google.com by
pauli.pr...@gmail.com
on 8 Feb 2012 at 4:37