Advertisement
Guest User

Untitled

a guest
Oct 15th, 2019
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. -- Run in bash terminal, not in mysql> cli
  2. -- "local" = db_name (refers to Local by Flywheel database in thiis case)
  3.  
  4. -- EXPORT (specific table/rows)
  5. mysqldump -u root -p local wpsv_postmeta --where="post_id IN ('3514719','3514721','3514723','3514725','3514727')" > wpsv_postmeta_sample.sql
  6.  
  7. -- IMPORT
  8. mysql -u root -p local < wpsv_postmeta_sample.sql
  9.  
  10. -- zip
  11. zip test.zip testfile1.txt
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement