Below is how I am loading a 30gb dump file. What is the best way to verify it works? Should I check for errors in nohup.out? If an error happens will it stop?

 nohup mysql < all_db1.sql  &
  • One thing to do: SHOW TABLE STATUS; in each database -- before and after. They should look similar. – Rick James Jan 8 at 0:35
  • With 45,000 tables I am looking for a more automated way. Will replication always fail when I use it to catch up – Chris Muench Jan 8 at 3:11
  • Look through the Percona toolkit. – Rick James Jan 8 at 5:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.