Tagged Questions
0
votes
1answer
26 views
passing --single-transaction in mysqldump command line tool
I'm using MySQL GUI tool to backup my innodb database and I use the option '--single-transaction' to get a consistent copy as backup.
I have however, noticed that if I backup using command line ...
0
votes
0answers
20 views
'Offline' MySQL backup - server not starting
The MySQL server is no longer starting because the partition is too full. The issue seems to be ibdata (40GB). I wanted to follow these instructions (at 'InnoDB Infrastructure Cleanup')
Now I already ...
2
votes
1answer
29 views
To make a LVM backup of a MySQL database, would I have to reduce the logical volume size?
I am trying to learn how to do a Ubuntu LVM backup of a MySQL database.
For this test I installed a fresh copy of Ubuntu 12.04.2 LTS on a new box, along with MySQL 5.5. The box has one hard drive. ...
1
vote
4answers
172 views
Daily and Differential Backups
Is there a program with which I can create daily MySQL, PostgreSQL and MariaDB backups with these requirements:
The first time, make a full backup.
The second time, only the changes since the last ...
0
votes
0answers
36 views
Backup daily for MySQL, MariaDB or PostgreSQL [duplicate]
Good day:
I wonder if there is a program with which I can create daily backups with these requirements:
The first time, make a full backup.
The second time, only the changes since the last backup, ...
1
vote
1answer
24 views
xtrabackup backup grants?
I'm using MySQL 5.5 + Opensuse 12.3 .
After face an issue with mysqldump (appear be a bug with OpenSuse Mysql distribution) I have looking for others backup solution.
I found the xtrabackup from ...
1
vote
2answers
40 views
Live backup without lock
In our company we have a lot of MySQL databases. Some of these are critical and we want to take a back-up of all databases. These databases can't be locked because the application can change these ...
0
votes
1answer
36 views
Reinstall MySql but keep database tables and data
Please help!
There are server issues and MySql is no longer running on our server (Ubuntu). The service is not recognized and needs to be reinstalled. Unfortunately, the database has not been ...
2
votes
1answer
27 views
Which MySQL directories to back up using FTP
My server has been hacked and I only have FTP access to recover my data before reinstalling the OS.
Which/where are the directories that needs to be backed up? Will MySQL be recovered back to its ...
0
votes
2answers
57 views
How does mysql transaction works?
I already know how to use transactions, what I want to know is how MySQL transaction handles data being processed...
For example, consider the following:
1. I have 2 databases (db1 and db2) ...
1
vote
1answer
26 views
MySQL: parallel restores at same time from backup files?
Slightly related to this question, but for MySQL: Would it be possible/wise to execute 2 parallel restores from a single backup?
Is it possible/wise to do a parallel restore of two independent ...
0
votes
2answers
128 views
MySQL backup InnoDB
I have a VoIP server running 24x7. At low peak hour at lease 150+ users are connected. My server has MySQL running with InnoDB engine on Windows 2008 platform. I like to take at least 2 times full ...
2
votes
1answer
92 views
Backing up a 400-500 GB database on MySQL/Amazon RDS?
We have an Amazon RDS small instance for a MySQL datawarehousing database.
Database size will be around 400-500 GB very shortly.
What is the best way to backup our database?
Can it be done ...
0
votes
0answers
58 views
How to do point in time recovery of binary log files into .sql file
I have written a shell script to do an incremental backup of MySQL database.
For point in time recovery I'm using the binary logs generated in /var/lib/mysql directory.
For point-in-time recovery, Im ...
1
vote
3answers
123 views
There is any option for mysqldump to ignore databases for backup in mysql
we have 40 databases in our server.
we want to take 36 databases backup using mysqldump.
how can i ignore remainig 4 databases in mysqldump command.
there is any option for mysqldump to ignore ...
2
votes
3answers
137 views
How to retrieve master log position and master log file in shell script
I'm writing a shell script for point in time recovery for MySQL database.For the below statement I need to specify the start position and end position of a log file.
mysqlbinlog ...
0
votes
0answers
107 views
Mysql Incremental Backup and point in time recovery
I'm writing a shell script using the concept of binary logs for point in time recovery.
Now, the scenario is such that a full-backup will happen every alternate day and Incremental backup should be ...
1
vote
2answers
400 views
Which hot backup tools for MySQL InnoDB database : Percona XtraBackup, Zmanda Recovery Manager Enterprise or Community or…?
I manage a PHP/MySQL website :
max 500 simultaneous users / average of 4000 per hour in update/read
1 MySQL Community Server (5.1) - (Xeon / 16 Go RAM)
InnoDB Storage engine on 100 tables for 1.4 Go ...
1
vote
1answer
126 views
MySQL Point in Time Recovery For Just a Single Schema?
Is it possible to simply restore a single schema and bring it to a point in time (Say three hours ago) without bringing the entire database back?
I can think of a lengthy method of backing up each ...
0
votes
1answer
328 views
What is the proper way to backup MySQL database with rsnapshot?
I want to backup my website that contains both user uploaded images and data stored in MySQL database such that they are always consistent with each other in any particular point of time. While ...
0
votes
1answer
72 views
Backup plan for MySQL NDB cluster databse not innoDB
I have a Database which will grow more than 250GB all data is in NDB engine(2 datanodes) and no other mysql engine used for data store.
What are the best approaches or plans for MySQL Cluster NDB ...
0
votes
2answers
290 views
How to increase fast backup and restore of 500GB database using mysqldump?
There is a database A size of 500GB. Tables in database A contains both MyISAM and INNODB tables. MyISAM tables are master tables and Innodb tables are main transaction tables.
Backup and restore ...
0
votes
1answer
130 views
mysql duplicate entry error 1062 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 ...
0
votes
1answer
37 views
mysqlbackup mysql enterprise utility issue
I recent took a backup using mysqlbackup.
While restoring it, I noticed that the files that were copied into datadir are with root:root (user:group) instead of mysql:mysql.
Is anything wrong with ...
0
votes
3answers
71 views
Where can I learn about MySQL master/slave, master/master, or clustering setups?
What are the best resources you've read or watched about setting up master/slave or clustering for database replication?
I don't know much about this. I have a database that is getting rather large ...
1
vote
2answers
165 views
MySQL Enterprise Backup error: Log scan was only able to reach xxxx
I use MySQL Enterprise Backup to make incremental backups, but when I apply a restore (copy-back), I can't remake a backup.
I get this error:
mysqlbackup: ERROR: Log scan was only able to reach ...
3
votes
1answer
83 views
Backup and off-site restore setup
I've been reading a lot of threads about different backup options for MySQL and was hoping for some more insight so I can settle on one.
Our current situation is ~100 GB of InnoDB and MySAM data in ...
1
vote
1answer
169 views
How to run a cold backup with Linux/tar without shutting down MySQL slave?
I run the following before tar-ing up the data directory:
STOP SLAVE;
FLUSH TABLES WITH READ LOCK;
FLUSH LOGS;
However, tar will sometimes complain that the ibdata* and ib_logfiles* files are ...
3
votes
1answer
1k views
Is Percona xtrabackup the right choice for my 500GB MySQL backup?
I have a MySQL db with 500GB, consisting mainly of Innodb tables, and one big (200GB) MyISAM table. My current backup strategy is copying the db files to an external harddrive. This causes a downtime ...
2
votes
1answer
438 views
Does the Amazon RDS backup/snapshot service lock tables?
We have a database that is 100+GB. Most tables use the InnoDB engine.
A regular dump takes 1-2 hours.
If we moved to Amazon RDS, would this backup cause table locks?
Does Amazon use a simple ...
0
votes
5answers
52 views
Copy my data from a existing db to a new db
I have a database which has my data's that I have been working for months. Now, I want to delete that db. What concern's me is that the data's that I have might come in handy in the future ...
2
votes
1answer
104 views
How do I ensure consistent MySQL backups?
How can we ensure MySQL backups are consistent when they are taken as full backups as well as incremental backups using binlogs?
According to me, I record the COUNT(*) from random tables after ...
0
votes
1answer
675 views
Can we back up mysql databases by copying files?
I tried to reinstall mysql on my machine, but it keeps failing. Everytime it fails, it does this locking and that locking and future effort would fail again.
Finally I decided to do truly clean ...
1
vote
1answer
118 views
Access denied Error in MySQL and Drupal
We are trying to deploy a Drupal application on our production server.
We see this strange error Lost connection to MySQL server at ''Access denied root@ipaddres password(yes) after deploying.
We ...
1
vote
1answer
142 views
Failed to restore mysql database with zmanda
I want to setup a slave from my backup version of mysql using zmanda (it's a full backup).
I've followed this guide.
Result of mysql-zrm-reporter
backup_set backup_date ...
3
votes
2answers
216 views
Writing transactions to .MYD file to take Backup
I'm trying to backup MySQL DB by archiving the data directory of required databases.
I'm doing FLUSH TABLES WITH READ LOCK before taking the backup, but even then some of the transactions were not ...
2
votes
3answers
732 views
MySQL backup with no downtime
I'm running a M/S replication of MySQL 5.5 / innoDB (over ubuntu).
My DB is pretty large: ~250GB.
I'm looking for a backup tool/service that will do the following:
full backup
no downtime / locks ...
4
votes
1answer
560 views
What's the fastest way to replicate a MySQL database from one machine to another?
What's the fastest way to replicate a MySQL database from one machine to another? The two machines are connected via LAN. How to do it without mysqldump?
If using mysqldump, is the fastest way
$ ...
0
votes
1answer
121 views
Backup and trimming data idea
Our main table, tblLink, will have its primary key as foreign in a few other tables too and one of the tables will be tblMainData which over time will be millions of rows.
We would like to maintain ...
3
votes
1answer
84 views
Does MySQL Enterprise Backup work across Operating Systems?
The problem with testing is that one can never be sure (it may seem to work and then you find some thing changed later). A definitive statement from the vendor would definitely be helpful (I cannot ...
2
votes
1answer
260 views
How to write a shell script to check the mysql database backup status.
I have mysql production databases running in main server(Linux) and from this server every night the backup is taken into local server.
Now i want to find a shell script to check if all the databases ...
0
votes
2answers
264 views
Creating a test database from Production database (different machines & servers)
I'd like to set up a test database on a separate server. Production database is MS SQL Server and the test server is a *nix box so I'd like to have the test server running either PostgreSQL or MySQL.
...
3
votes
1answer
449 views
MySQL Server Backup
I was wondering if there was any way of making a backup of an entire MySQL Server at regular intervals to a specific location. (If the version is required I can get it easily).
If there is, I must ...
0
votes
1answer
576 views
How to Create Snapshot Backups in MySQL
I've seen a lot of people talking about snapshots backup, even I'm reading a book about mysql but nobody explain the code how to make a snapshots backup. This is what the book says:
flush tables ...
1
vote
1answer
2k views
Problem with View When Restoring a MySQL Backup
I have a database (InnoDB) with some tables, views and routines...
Periodically I do a backup using the command line:
mysqldump -u user -ppassword --routines db_name > backup.sql
But I have a ...
3
votes
2answers
430 views
Difference between backup methods: Oracle and MySQL
I was reading that Oracle databases have cold, warm, full and redo backups.
Questions
How is it possible that MySQL doesn't have as many options?
I have read that MySQL has cold backups (it puts ...
1
vote
2answers
118 views
Is this an appropriate development environment MySQL backup strategy?
I'm a web developer and I use primarily my own laptop at work. We use an SVN repository for our project codebases, and deploy our changes to an internal development server for testing.
Our system ...
3
votes
1answer
458 views
How to backup a MySQL database without slowing the application?
I'm an application developer and wondering about our database backup strategy. Right now our sysadmins backup our database every 8 hours. I don't really know how the do it, but while the backup is ...
3
votes
1answer
232 views
Xen snapshots and live Innodb tables?
I am wondering if I can trust my host doing it's nightly snapshots with live Innodb tables.
From what I have read:
"Innodb is ACID-compliant, so you can "safely" use fs snapshot with Innodb tables."
...
3
votes
1answer
443 views
Quick MySQL Backup (1 file per table)
I asked a relevant question few months back and got answer with wide variety of options for backup.
But this time I have different scenario and I have got a database with 7 tables and 1 of them has ...
