User:Clouserw/AMODBrefresh: Difference between revisions

no edit summary
No edit summary
No edit summary
Line 46: Line 46:


<p>We then need to truncate all the tables in solitude on stage or dev, or drop and recreate it.</p>
<p>We then need to truncate all the tables in solitude on stage or dev, or drop and recreate it.</p>
 
<pre>
DATABASE='solitudedb'; echo mysql -Nse 'show tables' $DATABASE | grep -v schema_version | while read table; do mysql -e "set foreign_key_checks = 0; truncate table $table;  set foreign_key_checks = 1;" $DATABASE ; done'
</pre>
<p>
<p>
Since deleting payment accounts will de-list apps, the search index needs to be updated to reflect this
Since deleting payment accounts will de-list apps, the search index needs to be updated to reflect this
2

edits