0
votes
1answer
51 views

Increase the speed of mysqldump

Are there any flags or tricks to speed up mysqldump for backups? Here is what we are currently using: mysqldump --skip-opt --flush-logs --routines --triggers --allow-keywords --create-options ...
0
votes
2answers
80 views

How to proceed setting up a secondary mysql linux slave?

I have a mysql database master and slave in production. I want to setup additional mysql slave. There is around 15 Terabyte of data in the database and there are MYISAM and InnoDB tables in the ...
4
votes
2answers
506 views

mysql error 1062 'duplicate entry' when restoring backup

Sorry, I seen similar threads but I still couldn't find it addressing my issue plus, I needed some more info on this. Requirement: To create an exact replica 'db4' of an existing DB 'db3'. Procedure ...
1
vote
0answers
1k views

How do I set my root account in mysql to be accessed locally?

I am running into a bit of a problem here. I have a mysql server setup on an Ubuntu 12.04 distro. After the initial install I have been using MySQL Workbench to do all my db creation and ...
1
vote
1answer
925 views

Mysql - innoDb - is in the future! Current system log sequence number

I have this error in my syslog. I restored an older dump to solve this problem, after some reading. Now The errors in syslog are far less than before. But still a few times an hour I get Sep 1 ...
1
vote
2answers
430 views

What is the best way to take backup of live mysql database for MyIsam tables

I don't want to convert the tables to InnoDB what is the best way to take safe backup of my live site? I've gone thru many posts in this site. I think there isn't unless we down the site in case of ...
1
vote
2answers
97 views

MySQL Replication Server Error

My replication server showing the following error,Please go through the query and tell me your comments.The insert query is working in live DB server Properly , but showing error in replication DB ...
1
vote
2answers
312 views

Backing up MySQL DB wtih mixture of innodb and myisam tables

I have a large database (almost 1GB) and it has a mixture of innodb and myisam tables. Does anyone have any general tips when backing it up or more specifically the commands i should send to ...