×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: PHP
Posted by: bejoy balan
Added: Nov 6, 2014 10:33 AM
Views: 20
mysqldump cms and static pages blocks in magento
  1. 1> Export from your development server:
  2.  
  3. mysqldump -u [username] -p[password] [database] cms_page cms_page_store cms_block cms_block_store | grep INSERT | sed 's/INSERT INTO/REPLACE INTO/' > cms-export.sql
  4. Note: Don’t forget to add prefix to cms_* tables if you have prefixed your tables.
  5.  
  6. 2> Import to your live/destination server:
  7.  
  8. mysql -u [username] -p[password] [database] < cms-export.sql