I Failed the Turing Test

  • Web Development
  • Database
  • DevOps
  • Python
  • JavaScript
  • Machine Learning
  • Big Data
  • Blockchain

Import MySQL database but ignore specific tables

Posted on 2018-03-132019-10-22Author VintaPosted in Database, DevOps

You could just exclude tables you do not need.

$ brew install gnu-sed --with-default-names
$ sed -r '/INSERT INTO `(table_to_skip_1|table_to_skip_2|table_to_skip_3)`/d' db.20180101.sql > db.reduced.sql

ref:
https://stackoverflow.com/questions/16735344/mysql-import-database-but-ignore-specific-table

Tagged: cli toolsmysql

Post navigation

← ngrok: Share your localhost services with friends
Find circular imports in Python →

Say Hello

TwitterFacebookLinkedInGitHubRSS

Recent Posts

  • Solidity: Multicall - Aggregate Multiple Contract Calls
  • Solidity: abi.encode() vs abi.encodePacked() vs abi.encodeWithSignature() vs abi.encodeCall()
  • Build Docker Images using Google Cloud Build from Your GitHub Repository
  • Solidity: Read Contract Storage by Slots with Foundry
  • How to Stay Safe Online: Tips for Personal Security
  • Solidity: CREATE vs CREATE2
  • Solidity: calldata, memory, and storage
  • hardhat-deploy: Upgradeable Contracts with Linked Libraries
  • Deploy Ethereum RPC Provider Load Balancer with HAProxy in Kubernetes (AWS EKS)
  • Deploy graph-node (The Graph) in Kubernetes (AWS EKS)
  • Amazon EKS: Setup Cluster Autoscaler
  • Amazon EKS: Setup aws-load-balancer-controller for Kubernetes Ingress
  • The Graph: Subgraph and GRT Token
  • Amazon EKS: Setup kubernetes-external-secrets with AWS Secret Manager
  • Amazon EKS: Create a Kubernetes cluster via ClusterConfig

Categories

  • Big Data (13)
  • Blockchain (10)
  • Database (15)
  • DevOps (33)
  • JavaScript (8)
  • Machine Learning (17)
  • Misc (6)
  • Python (48)
  • Web Development (40)

Tags

amazon web services apache spark aws cloudfront aws dynamodb aws eks aws lambda aws s3 cache celery chat bot ci cli tools codetengu concurrency database migrations datetime debug django django models docker editor elasticsearch env ethereum ethers.js feature engineering foundry functional programming github go google bigquery google cloud platform graphql haproxy http io java javascript kubernetes linux linux sysadmin machine learning maven mongodb mysql networking nginx node.js profiling python recommender system redis scala search security smart-contract solidity subgraph testing tls transaction typescript visual studio code web crawler wordpress

Search

© 2025 I Failed the Turing Test. Stork Theme by JustGoodThemes.