mysqldump : MySQL's Standard Dump/Backup Utility

learn more… | top users | synonyms

0
votes
1answer
138 views

Upgrading mysql myisam 5.1 to mysql 5.6: force innodb on restore?

I inherited a DB using myisam on mysql 5.1 because of the need for fulltext search. I now read that fulltext search is available on mysql 5.6 innodb. Doing this would solve a lot of problems, as long ...
0
votes
1answer
117 views

mysqldump dump file size

I have used mysql-administrator to back up my mediawiki and bugzilla database. Now there is an issue with charsets I can't fix. So I deciced to try mysqldump with -single-transaction --routines ...
1
vote
0answers
51 views

mysqldump issues with DreamHost

Background: I sought to rename a database on Dreamhost web hosting VPS account. I also wanted to rename a database user for the database to be created above. I followed the approached detailed at ...
0
votes
0answers
596 views

Incorrect definition of table mysql.event after migrating database to mariadb

I did a mysqldump to dump all databases into a .sql file, then installed a mariadb server. There are no errors after the installation. But after restoring the databases, I started to observe the ...
0
votes
1answer
96 views

Mysql replication dump without down time? empty sql file

I try to create dump as replication master data and use followed command to create dump, but sql file only contains paramters and there is no data and structure. The command is : mysqldump ...
2
votes
1answer
138 views

Which are the minimum privileges required to get a backup of a MySQL database schema?

Which are the minimum privileges required to get a backup of a MySQL database schema? I am interested only on the schema, not on the data. Are SELECT privileges required?
1
vote
1answer
91 views

Is there a Successor or an Alternative to mk-parallel-dump?

Just read about mk-parallel-dump in a possibly-outdated version of High Performance MySQL. Sounded great, but when I went to download it I found out that it's deprecated with no equivalent command in ...
0
votes
1answer
168 views

Why does importing a MySQL dump cause so many I/O?

I imported 100 SQL-format dump files. The total size was 20 GB. The resulting .ibd files after the import had a total size of 40 GB. mysqld.exe wrote 1.1 TB and read 120 GB on the disk. Why so many ...
1
vote
1answer
201 views

MySQLdump on specific db date

I'm new in here and i don't really know where to start but here is my concern. I need to backyp a MySQL DB running under windows once a week. For e.g every friday i need to backup and transfer to ...
2
votes
1answer
123 views

Backup everything except one record

I want to backup my database except t1 table's one record (where option='siteurl'). I'm trying mysqldump's --where command. mysqldump -u root --skip-extended-insert --where "option='siteurl'" ...
1
vote
2answers
345 views

Can't restore mysqldump database backup in Ubuntu 12.04

I'm trying to restore a database backup created using mysqldump. If I do: $ mysqldump -u ROOT -p DATABASE_NAME < DATABASE.SQL the database remains empty, even though I get some screen output ...
0
votes
3answers
480 views

Converting live MyISAM table to InnoDB

I have a table that tracks web traffic. The table is constantly written and read from. Since table is pretty big in size I have to make sure the application will not "freeze" in the process of ...
0
votes
0answers
29 views

mysqldump: Got error: 0: when retrieving data from server

I get a the error in the header when the server tries to replicate itself after the backup completes. I have looked at error indexes, but failed to see an explanation for the error code 0. I was ...
0
votes
0answers
122 views

mysqldump & upload to mysql speed impact due to SSD and innoDb?

I am testing an AWS Medium Instance with CentOS (AWS AMI) and comparing it with Hetzner's EX40-SSD (http://www.hetzner.de/hosting/produkte_rootserver/ex40ssd). Software setup on both is comparable( ...
0
votes
0answers
39 views

taking backup of database on remote server gives error

I am currently on a Ubuntu machine (IP is 192.168.1.3) I have databases here I want to export all these databases to another machine in my network I used following command mysqldump --all-databases ...
0
votes
1answer
591 views

Restoring a single database from mysql enterprise full backup

I am having command to restore all databases from full dump taken by enterprise full backup .Can anyone help me how to restore single database from full dump .
0
votes
0answers
54 views

Accidentally I had deleted a database from production server working with MySQL

I have its backup as a full and an incremental backup took using enterprise backup. Is it possible to restore a specific database or else what should I do as an immediate action?
0
votes
1answer
73 views

synchronizing local and server database

I am developing a billing system software. For this I have created a database it contains many tables database and this is in local system all transactions data will be stored in local systems ...
1
vote
2answers
2k views

How can I synchronize data between two RDS MySQL databases

I have 2 Amazon RDS MySQL instances, one is MySql v5.5 and the new one is 5.6. I want to upgrade the 5.5 to the 5.6 but you cannot do upgrades at this time, so we are trying to migrate the data. I ...
4
votes
2answers
2k views

Best practices for backing up a MySQL DB

I've recently discovered that our production web servers that run off MySQL are not being backed up regularly (or at all). I'm used to backing up SQL Server DB's but don't have a ton of experience ...
1
vote
1answer
67 views

Where Mysqldump gets data from

How mysqldump is processing backup? From which all files is it reads data for creating dump? Is the process differs if storage engines are different?
0
votes
0answers
44 views

Drupal database differential restore mysql

I have several Drupal sites hosted on my shared hosting server. Each site has a dev, test and production instances, with separate Docroots and Apache Vhosts and separate mysql db instances. ...
1
vote
2answers
544 views

ERROR 1166 (42000) at line 65203: Incorrect column name ''

I have a big snapshot database size is about 44GB in mydata.sql. When I run it overnight, it show this error message: $ mysql -u root < mydata.sql ERROR 1166 (42000) at line 65203: Incorrect ...
-3
votes
1answer
57 views

How can I move one table from one database to other database [closed]

I want to move one table in one database to other database using mysql dump on linux terminal How can I go about it ?
0
votes
0answers
34 views

MySQL connection lock during backup(mysqldump)

Daily durign backup(mysqldump) window. Nagios read only user getting connection time-out(while other users can connect). As soon as backup completes nagios user gets connected. What might be the ...
0
votes
1answer
265 views

Deadlock from mysqldump --single-transaction, is it possible?

Is it possible to get a deadlock if you ran mysqldump with the argument --single-transaction ? or any other complication ? If it is used to backup a live site with many other querys running at the ...
1
vote
1answer
272 views

mysqldump―output details

I am about to write a little program to process database dump files created by mysqldump and I would like to make sure that my expectations about the »anatomy« of mysqldump's output are right. So ...
0
votes
0answers
91 views

mysqldump with multiple thread

How can I dump Percona mysql server database with multiple thread ? I don't want to use any third party tool or script for safety. Suggest me best, fastest,and safe way to dump and restore my largest ...
1
vote
3answers
745 views

Backup / Export data from MySQL 5.5 attachments table keeps failing!

Can anyone please help! - I have a large table in a MySQL 5.5 database. It is a table which holds a mixture of blobs/binary data and just data rows with links to file paths. It has just over a million ...
0
votes
1answer
99 views

MySQL data retained after OS reinstall

Something strange happened today. I reinstalled my OS and then when I reinstalled MySQL workbench some of my old data was still there. I think the actual local db is empty, but all the connections, ...
0
votes
1answer
83 views

Optimizing and maintaining test databases for a web development team

Right now when we test, we mysqldump from the production database, load it into the test database server, and then use scripts to scrub sensitive data. As the database is getting bigger, this process ...
0
votes
0answers
501 views

How to speed up a mysql restore from large dump file

I have a 350MB msyql dump file that takes over 3 minutes to load. I'd like to speed it up. I've tried using --opt with mysqldump (shaved off 30 seconds). The best I can achieve is 42 seconds faster. ...
1
vote
1answer
109 views

mysql: how to copy database and required dependencies

I need to set up an automated copy of a single mysql database (not the whole DBMS). If I use mysqldump to dump and recreate a DB, the copy may be unusable because the user accounts need to also be ...
1
vote
1answer
656 views

mysqldump: replace drop table in output with delete?

I am using mysqldump to dump some records in a table: mysqldump mydatabase mytable --where="field=value" this emits script that includes drop table mytable statement. Since I use the --where ...
1
vote
3answers
151 views

Moving large databases

I have a centos server and /var/lib/mysql/ is 125GB (disk has 1GB free space). Ordinarily I would use mysqldump to backup the databases, but I don't normally work with such large databases, so I need ...
0
votes
1answer
239 views

Export just rows modified in last month (date defined by user)

I'm asking if it's possible in MySQL to export just rows modified in a period of time for example in the past month, if it is possible, how?
0
votes
2answers
258 views

How can we check for data integrity when we upgrade from MySQL 4.1 to MySQL 5.5?

By data integrity, I mean: Schema integrity Data (record level) integrity Checksum was an option, but since the storage format for some data types in MySQL 5.5 has been changed, it won't be ...
1
vote
0answers
283 views

How do I safely import MySQL data in a directory to a running MariaDB server?

We're integrating another office into ours. That includes some of their data. I have a new installed MariaDB 5.5 server. The data dir = /home/data/MariaDB. I've done a new/fresh install into that ...
2
votes
1answer
981 views

mysql works, mysqldump doesn't

I have mysql 5.5 on my ubuntu 12.04 server. This command: mysql -u root -p works perfectly, but this gives me error: mysqldump -u root -p mydb_name > a.sql mysqldump: Got error: 2002: Can't ...
1
vote
1answer
1k views

Does mysqldump -all-databases include all objects

Does mysqldump -all-databases include all objects ? I have to migrate all databases to new server.
0
votes
0answers
288 views

Trouble converting MySql Database to SQL Server

I have an mysql database that contains 38 tables. I used "SQL Server Migration Assistant for Mysql" tool to convert this database to SQL server Database. I successfully converted 37 tables. Only one ...
-1
votes
1answer
120 views

MySQL Migration from Slave to Master

I recently had a problem with our server. It required us to install a new hard drive, cpanel, and setup the old hard drive as a slave. How can I migrate the mysql database from the slave drive to the ...
1
vote
2answers
3k views

MySQL replication: 'Duplicated entry for PRIMARY key'

Could you please help me to understand why I'm receiving 'Duplicated entry for PRIMARY key' on a slave server after a full re-sync. Basically 'mysqldump' was running almost whole night and then the ...
1
vote
2answers
2k views

What is the best way to recover from a mysql replication fail?

Today, the replication between our master mysql db server and the two replication servers dropped. I have a procedure here which was written a long time ago and i'm not sure it's the fastest method to ...
0
votes
1answer
86 views

How we take dump with batch of records option?

we have 30 GB database.we want to take backup of this database. here the question is we want to take the backup batch of every 10k records. How we can take batch of records backup using mysqldump
3
votes
2answers
3k views

Error while restoring a Database from an SQL dump

I am extremely new to MySQL and am running it on Windows. I am trying to restore a Database from a dumpfile in MySQL, but I get the following error: $ >mysql -u root -p -h localhost -D database ...
0
votes
1answer
368 views

Is there a system wide way to change MariaDB to create tables using ROW_FORMAT = DYNAMIC

I've got a 700MB dump file from a mysql database that I was trying to undump into a new install of MariaDB and I got this error ERROR 1118 (42000) at line 7481: Row size too large (> 8126). ...
1
vote
1answer
212 views

Using a mysqldump export to create data with a different database name

I am using the following to import database using a mysqldump export: mysql -u root -p example_db < path/to/export.sql I would like to import the database to a database with a different name to ...
1
vote
1answer
177 views

MySQL import LOCK doesn't prevent PRIMARY key issues

I am using Django and only want to backup mysql data (not it's structure; Django will do that, and it will otherwise mess up Django-South's migration checks). Some info; my tables are almost all ...
3
votes
1answer
281 views

how to verify mysql backup file

Is There any tool to verify the backup taken using mysqldump without manual restoration ? I have to take full backup daily so it is difficult for me to verify the backups daily by restoring them. As ...