Skip to content

Instantly share code, notes, and snippets.

@akawajid
akawajid / edit_large_db_schema_in_windows.md
Created July 22, 2023 17:36
Editing a Large MySQL Database Schema or Dump File in Windows

When dealing with large MySQL database schema or dump files in Windows, it can be challenging to edit them directly due to their size. However, by utilizing Git Bash and a copy command in cmd, we can easily split, edit, and merge these files more conveniently.

If you are already using Git for Windows, you should have Git Bash installed.

  1. Use the split command in Git Bash to split a file: split dbSchemaFile.sql -b 500m

  2. Make the necessary changes to the schema as required.

  3. Merge the edited files back into a single .sql file using