Skip to content

Instantly share code, notes, and snippets.

@mohamadaliakbari

mohamadaliakbari/sdm.tarafdari.com-dev-version.md

Created May 19, 2018 08:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mohamadaliakbari/e752e00400d904e0d0da8edc80ae171d to your computer and use it in GitHub Desktop.
Save mohamadaliakbari/e752e00400d904e0d0da8edc80ae171d to your computer and use it in GitHub Desktop.
Download ZIP
Create database dev version for sdm.tarafdari.com
Raw
sdm.tarafdari.com-dev-version.md
  • Create sdm_temp from main sdm backup.
  • List all tables with their rows: SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'sdm_temp' order by table_rows;
  • Truncate all non-core tables with huge data.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment