Re: mysql dump global read lock

2015-12-19 Thread Lisa Smith
Artem, You have --add-locks listed which will run LOCK TABLES prior to each table dump. --single-transaction is for InnoDB tables and ensures that they are copied in a consistent state. I hope this helps! On Thu, Dec 17, 2015 at 4:24 PM, Artem Kuchin wrote: > Hello! > > Hereis my mysqldump com

Re: mysql\innodb_table_stats.ibd. Cannot open tablespace

2016-01-22 Thread Lisa Smith
Hi Neil, When you say you delete the current database, do you mean the database files only? Are you doing a complete restore? On Fri, Jan 22, 2016 at 1:23 PM, Neil Tompkins wrote: > Hi, > > Hoping someone can help me identify why I keep having to restore my > database. You can see below, that

Workbench MySQL Enterprise Backup Error

2016-03-22 Thread Lisa Smith
Hello all, I have not run across this problem where Workbench will not let me access the "Online Backup" link and claims that my version of MySQL Enterprise Backup is 0.0.0 (it is 4.0.0). I had backups running and scheduled through Workbench previously. Yesterday I changed my data files to anothe