Advertisement
Guest User

Untitled

a guest
Jul 18th, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.53 KB | None | 0 0
  1. <?php
  2.  
  3. $options = getopt('h:u:p:d:');
  4.  
  5. //if (!isset($options['h']) || !isset($options['u']) || !isset($options['p']) || !isset($options['d'])) {
  6. // die(PHP_EOL . 'Usage: php light-db-dump.php -h{db_host} -u{db_user} -p{db_pass} -d{db_name}' . PHP_EOL . PHP_EOL);
  7. //}
  8.  
  9. $dbName = 'Magento';
  10. //$dbUser = 'root';
  11. //$dbPass = '123123q';
  12. //$dbHost = 'localhost';
  13.  
  14. //$dbName = $options['d'];
  15. //$dbUser = $options['u'];
  16. //$dbPass = $options['p'];
  17. //$dbHost = $options['h'];
  18.  
  19. //tables will be installed with no data
  20. $noDataTables = array(
  21. 'enterprise_customer_sales_flat_order',
  22. 'enterprise_customer_sales_flat_order_address',
  23. 'enterprise_customer_sales_flat_quote',
  24. 'enterprise_customer_sales_flat_quote_address',
  25. 'enterprise_reminder_rule_coupon',
  26. 'enterprise_sales_order_grid_archive',
  27. 'enterprise_sales_shipment_grid_archive',
  28. 'sales_flat_order',
  29. 'sales_flat_order_address',
  30. 'sales_flat_order_grid',
  31. 'sales_flat_order_item',
  32. 'sales_flat_order_payment',
  33. 'sales_flat_order_status_history',
  34. 'sales_flat_shipment',
  35. 'sales_flat_shipment_comment',
  36. 'sales_flat_shipment_grid',
  37. 'sales_flat_shipment_item',
  38. 'sales_flat_shipment_track',
  39. 'sales_order_aggregated_created',
  40. 'sales_order_aggregated_updated',
  41. 'sales_order_coupon',
  42. 'sales_order_status',
  43. 'sales_order_status_label',
  44. 'sales_order_status_state',
  45. 'sales_order_tax',
  46. 'sales_order_tax_item',
  47. 'sales_payment_transaction',
  48. 'sales_shipping_aggregated',
  49. 'sales_shipping_aggregated_order',
  50. 'salesrule',
  51. 'salesrule_coupon',
  52. 'salesrule_coupon_usage',
  53. 'salesrule_customer',
  54. 'salesrule_customer_group',
  55. 'salesrule_label',
  56. 'salesrule_product_attribute',
  57. 'salesrule_website',
  58. 'sales_bestsellers_aggregated_daily',
  59. 'sales_bestsellers_aggregated_monthly',
  60. 'sales_bestsellers_aggregated_yearly',
  61. 'sales_flat_quote',
  62. 'sales_flat_quote_address',
  63. 'sales_flat_quote_address_item',
  64. 'sales_flat_quote_item',
  65. 'sales_flat_quote_item_option',
  66. 'sales_flat_quote_payment',
  67. 'sales_flat_quote_shipping_rate',
  68. 'customer_address_entity',
  69. 'customer_address_entity_datetime',
  70. 'customer_address_entity_decimal',
  71. 'customer_address_entity_int',
  72. 'customer_address_entity_text',
  73. 'customer_address_entity_varchar',
  74. 'customer_entity',
  75. 'customer_entity_datetime',
  76. 'customer_entity_decimal',
  77. 'customer_entity_int',
  78. 'customer_entity_text',
  79. 'customer_entity_varchar',
  80. 'customer_flowpassword',
  81. 'captcha_log',
  82. 'catalog_compare_item',
  83. 'catalog_product_entity_text', //FOR THIS TABLE ONLY NON-EMPTY, NON-NULL VALUES WILL BE DUMPED IN THE LAST STEP
  84. 'catalogsearch_query',
  85. 'catalogsearch_fulltext',
  86. 'core_cache',
  87. 'core_cache_tag',
  88. 'core_email_queue',
  89. 'core_session',
  90. 'coupon_aggregated',
  91. 'coupon_aggregated_order',
  92. 'coupon_aggregated_updated',
  93. 'cron_schedule',
  94. 'custom_quote_visitor_log',
  95. 'dataflow_batch_export',
  96. 'dataflow_batch_import',
  97. 'enterprise_cms_page_revision',
  98. 'enterprise_logging_event',
  99. 'enterprise_logging_event_changes',
  100. 'enterprise_reminder_rule_log',
  101. 'index_event',
  102. 'index_process_event',
  103. 'log_customer',
  104. 'log_quote',
  105. 'log_summary',
  106. 'log_summary_type',
  107. 'log_url',
  108. 'log_url_info',
  109. 'log_visitor',
  110. 'log_visitor_info',
  111. 'log_visitor_online',
  112. 'newsletter_subscriber',
  113. 'report_compared_product_index',
  114. 'report_event',
  115. 'report_viewed_product_aggregated_daily',
  116. 'report_viewed_product_aggregated_monthly',
  117. 'report_viewed_product_aggregated_yearly',
  118. 'report_viewed_product_index',
  119. 'review_detail',
  120. 'review_store',
  121. 'review_entity_summary',
  122. 'tax_order_aggregated_created',
  123. 'tax_order_aggregated_updated',
  124. 'wishlist',
  125. 'wishlist_item',
  126. 'wishlist_item_option',
  127. );
  128.  
  129. //tables that will not be installed
  130. $ignoreTables = array(
  131. );
  132.  
  133. $firstPart = '';
  134. foreach (array_merge($noDataTables, $ignoreTables) as $table) {
  135. $firstPart .= "--ignore-table='{$dbName}'.'{$table}' ";
  136. }
  137.  
  138. $secondPart = '';
  139. foreach ($noDataTables as $table) {
  140. $secondPart .= "{$table} ";
  141. }
  142.  
  143. echo exec("mysqldump --single-transaction --skip-lock-tables -f {$firstPart} {$dbName} > db-copy.sql");
  144. echo exec("mysqldump --single-transaction --skip-lock-tables -f --no-data {$dbName} {$secondPart} >> db-copy.sql");
  145.  
  146. echo exec("mysqldump --single-transaction --skip-lock-tables -f {$dbName} catalog_product_entity_text --no-create-info --where=\"value is not null and value <> ''\" >> db-copy.sql");
  147.  
  148. exec("env GZIP=-9 tar cvzf db-copy.tar.gz db-copy.sql");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement