mysqldump : MySQL's Standard Dump/Backup Utility

learn more… | top users | synonyms

0
votes
0answers
8 views

“Display width out of range for column” error when importing mysql 5.1 dump into 5.5

I am migrating to a new server, and trying to move my database from a 5.1 to 5.5 server. I created a dump with mysqldump -u root -p --add-drop-database --triggers dbname > dbname.sql When I ...
0
votes
1answer
65 views

Problem with mysqldump and view

When using mysqldump to backup MySQL, I got following error. mysqldump --all-databases --routines >> all.sql mysqldump: Couldn't execute 'show table status like 'hdkien'': SELECT command denied ...
1
vote
1answer
13 views

mysqldump: dump several tables from db. what will be locked?

I have active database with dozens of tables. Among them several are unused (no queries/insertions are performing over them for a while). I want to dump that inactive tables. I would suggest that it ...
1
vote
1answer
16 views

Make MySQL dump from parts of each table

I need to export some data from different tables. I tried this query select * into outfile 'C:\Users\\User\\Desktop\\ololo.sql' from db.users where id % 2 = 1; After this query, the SQL file was ...
0
votes
0answers
19 views

SQL Error while restoring big database in Mysql

I have successfully created a MYSQL dump on RHEL 6 machine. The dump file is having 40 GB. When I try to restore it in an UBUNTU machine I got this error.
0
votes
2answers
32 views

mysqldump with automatically generated export name

When I do database dumps through MySQL WorkBench it picks a filename for me which is the current date (YYYMMDD). Now, I want to do this in a batch file since I want to make weekly dumps automatically ...
1
vote
1answer
52 views

mysqldump: Does --lock-tables=false work with MyISAM tables?

So, I have to check and come with a backup solution for a very busy mysql server (with tables over 5 GB). Due to resources constraints, they choose to set all tables with the MyISAM engine. Currently, ...
0
votes
3answers
39 views

MySQL backup breakes a table every time

I've a MySQL Server 5.1.58-1ubuntu1 installed on an Ubuntu 12.04 LTS. Every night we do a backup of all the databases with this script: rm -rf /var/backup/mysql/ * for i in $(echo 'SHOW DATABASES;' ...
1
vote
3answers
58 views

Verify mysqldump backup is corruption free

We've got a cron task backing up our Database using mysqldump - my main concern is corruption, short of manually importing and checking the backups each time whats the best way to check / verify a ...
1
vote
1answer
176 views

Extremely slow mySql restores

Please bear with me as I ask this question, which looks similar to questions already on DBA@SE. In the current configuration, we have a server (a Linux quadcore box with 4 GB RAM) - Both the Database ...
1
vote
1answer
31 views

mysqldump confusion

I must be missing something. The line I keep seeing everywhere for a consistent backup is: mysqldump --single-transaction --all-databases > alldbs.sql Yet the MySQL docs indicate --opt is on by ...
0
votes
1answer
47 views

XML dump of MySQL database don't include foreign key constraints. What can be the reason? sqldump(.sql) file list it

I am accessing schema information of databases in XML format. I am taking dump of the database in XML format using the command below. mysqldump --no-data --xml -u root -p bakerydb > bakerydb.xml ...
2
votes
3answers
68 views

Getting 0KB of size file while backup mysql database using mysql dump

I am using below code to backup my database using php script but I am getting 0KB size file. How can I backup my full database with all routines and functions? $dbhost = 'localhost'; $dbuser = ...
0
votes
0answers
38 views

Issues with mysqldump after upgrade 5.5 -> 5.6

A few months ago I updated a MySQL setup from 5.5 to 5.6. Since then I've been having problems with a script that I use to dump the various databases so that I can back them up. The script is a short ...
0
votes
0answers
81 views

How can I backup/dump MYSQL database with foreign key constraints?

I wanted to take the dump of the MySQL database with all the constraints on that database. The dump (.sql file) I am having right now don't show any reference key(foreign key) relationship. I am ...
0
votes
0answers
39 views

restore using mysqlbinlog failing

While doing restore from a MySQL binary log file, it is failing with the following error . mysqlbinlog mysql-bin.000036 | mysql -u root -p asdb ERROR 1032 (HY000) at line 48: Can't find record in ...
1
vote
1answer
79 views

mysqlbinlog failing with “ ERROR 1032 (HY000) at line 48: Can't find record in `` ” Error

I am facing some issue with PITR restore using mysqlbinlog . It is failing with the following error . # mysqlbinlog mysql-bin.000035 | mysql -u root -p db Enter password: ERROR 1032 (HY000) at ...
0
votes
0answers
53 views

mysqldump hung indefinitely - locked tables - replication

I'm new to database programming. I had never written a simple SQL query before but recently I was asked to perform MySql DB replication for our redundant servers. It is a Linux server running as ...
0
votes
1answer
42 views

Backup live MySQL database

I have a single MySQL database Server version: 5.5.35-cll MySQL Community Server (GPL) ENGINE is MyISAM I use 'mysqldump' to backup and restore the database. Size of the dumpfile is 3GB+ Once a ...
0
votes
1answer
52 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
46 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
30 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
248 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
2answers
60 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
62 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
42 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
101 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
122 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
76 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
1answer
103 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
184 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
24 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
100 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
30 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
102 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
45 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
49 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
1k 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 ...
3
votes
2answers
846 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
61 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
35 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. ...
-3
votes
1answer
50 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
28 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
177 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 ...
0
votes
1answer
289 views

multiple line text values in mysqldump text export file

I'm trying to export +100mil record table into txt file. My plan is split up txt file to small pieces by size or line then import. I have one text field has multiple line like blog post text, in txt ...
1
vote
1answer
183 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
58 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
551 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
84 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
68 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 ...