mysqldump : MySQL's Standard Dump/Backup Utility

learn more… | top users | synonyms

2
votes
1answer
578 views

Why would the size of MySQL MyISAM table indexes (aka MYI file) not match after mysqldump import?

I've been archiving some MySQL (version 5.0.96) MyISAM tables locally and deleting from my server after checking the data. Every time the process has been pretty similar and comes off mostly without a ...
1
vote
1answer
12 views

I really can't get rid of these conditional statements in mysqldump?

My mysqldump DDL file is filled with tons of this: /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `my_trigger`... I've searched to no avail for an option to silence this. ...
1
vote
1answer
2k 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 ...
0
votes
1answer
19 views

Are certain environment variables required for mysql login-path?

I created a bash script that backs up my database, db_backup.sh It basically just runs these commands: DB=/home/linuxuser/backups/backupfilename.sql.gz mysqldump --login-path=local db_name | gzip ...
0
votes
1answer
8 views

mysqldump is not dumping data by default

mysqldump is dumping only the table structures, without data, by default. mysqldump -u user -d database -p Which is the option to dump is with data? How can I configure it, to include the data? (I ...
0
votes
1answer
36 views

mysqldump Error 2013

I have a database installed, that I would like to backup in mysql. The problem is mysqldump fails on exporting the 'maia_mail' table # mysqldump -u root -p maia > maia.sql mysqldump: Error ...
0
votes
1answer
20 views

Setting MySQLDump to keep running in the background after session times out

I'm tryng to set up a new Slave DB by copying another Slave DB. Normally I would simply use MySQLDump to dump the Slave and create a .sql file, then import that into the new database. However, as our ...
0
votes
1answer
21 views

How do you dump specific table(s)?

Hi i have a shell script for doing a selected databases backup. Now my requirement is i wanted to take a particular tables in a database to be backed up. Each database backup need to be created in ...
0
votes
1answer
34 views

Shell script for partial table backup

I have multiple database in my MYSQL server and i want to take some particular tables backup from each database. can anyone help me in writting a shell script for this scenario.
0
votes
1answer
64 views

Dump with special characters in table column name

I'm taking over an old database, and while doing recovery tests from my dump I found out a table is wrongly backed up, the table definition is truncated. Looking at the live db I've found a column ...
0
votes
1answer
46 views

MySQL Workbench can either Dump or Restore - How Do I Configure To Do Both?

I have previously posted this question on Stack Overflow, but have not solved the problem. Hopefully it is not incorrect to post it here in the hope that it will be seen by a some different ...
0
votes
1answer
2k views

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I know this might be a duplicate of some other posts. But those solutions didn't work for me and I've lot of issues within those answers. Neither could I comment nor post in there, I'm posting a ...
1
vote
0answers
67 views

To configure MySQL Enterprise Workbench for Incremental Backup with Online Backup option

Could not acquire management access for administration RuntimeError:Could not initialize WMI interface: Workbench.wmiOpenSession():Could not connect to target machine. When i am trying to configure ...
1
vote
0answers
104 views

Are ZRM (Zmanda Recovery Manager) incremental backups reliable?

I had an issue while restoring incremental backups and I'm wondering if they are reliable. I'm making weekly full backups and daily incremental backups and I needed to restore a single database after ...
1
vote
0answers
95 views

mysqldump with --single-transaction seems to be “fixing” InnoDB tables with page corruption - why?

I'm trying to find out what exactly is happening here. I've been intentionally corrupting index pages in InnoDB tables, changing bytes in user record areas that actually contain information (largest ...
1
vote
0answers
505 views

MySQL dump error (#1005 - Can't create table 'novephp_cz_bv.jos_jquarks_customsets' (errno: 150))

I´m trying dump mysql database from MySQL 5.1. to MySQL 5.5. But I´m getting an error "#1005 - Can't create table 'novephp_cz_bv.jos_jquarks_customsets' (errno: 150)". Problematic part of script is ...
1
vote
0answers
184 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
0answers
80 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 ...
1
vote
0answers
485 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 ...
1
vote
0answers
88 views

MySQL replication backup

How to take MySQL Master-Master and Master-Slave replication backup?. I have setup Master-Master replication with a separate slave for each master on Ubuntu. What happens if, I issue or schedule ...
0
votes
0answers
6 views

Is there an easy way to update a mysqldump file from version 9.11 to 10.11?

We have a client that has had their servers for soo long, they were still running MySQL 4.0.24. Now that they are refreshing their servers, we took a mysqldump of their current database to put into ...
0
votes
0answers
11 views

Import database with views and routines into Amazon RDS

I need to import a collection of MySQL DB's into Amazon RDS without downtime. One can do this by initially setting up the RDS instance as a slave. There is one problem, you're not a super user on RDS ...
0
votes
0answers
23 views

Automysqlbackup fix error “Skipping the data of table mysql.event. Specify the --events option explicitly”

I need to fix the mysqldump warning "-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.". I found that its because of not specifying whether or not to add ...
0
votes
0answers
14 views

Getting warning ignoring option '--databases' due to invalid value 'testdatabase' in mysql while importing data

i am getting warning ignoring option '--databases' due to invalid value 'testdatabase' in mysql while importing sql data into a database.Its working fine when I do it on my local machine but same is ...
0
votes
0answers
65 views

Daily backup with mysqldump

I want a periodic MySQL database backup, but I don't have permission to access ssh. When I try to run mysqldump via command line in Plesk Scheduled Tasks, it only creates a blank file 0 kb sized. I'm ...
0
votes
0answers
26 views

Importing backup(.sql) file into a database. local to remote machine.

I have a database backup(.sql file) in my local machine. It is around 36Gb. And I need to import this backup to a database which is in a remote server, which has a free space of 39Gb. If I try to ...
0
votes
0answers
67 views

Restore MySQL DB from mylvmbackup to .sql dump

Backups of MySQL innodb databases are taken using mylvmbackup and the resulting backup contains the whole mysql folder as per example below: ibdata1 ib_logfile0 ib_logfile1 mysql/ mysql_upgrade_info ...
0
votes
0answers
43 views

How I do a complete backup restore of MySQL Schema with views and functions?

I am trying to backup a single schema on a Windows server and restore it to an Ubuntu 12.04 Linux server running MySQL 5.5.4. The schema includes views and functions. When I used the MySQL Workbench ...
0
votes
0answers
248 views

mysqldump: Got error: 1044: Access denied for user 'username'@'localhost' to database 'databasename' when using LOCK TABLES

mysqldump: Got error: 1044: Access denied for user 'username'@'localhost' to database 'databasename' when using LOCK TABLES I am able to loging properly and able to take full backup from SQLyog Tool ...
0
votes
0answers
143 views

MySQL dump - how to order tables?

It seems that mysqldump dumps tables in sequential order - using the same order tables are shown when running: show tables; I would like to reverse that order - is it possible to do without getting ...
0
votes
0answers
51 views

Best upgrade path for MySql 4.1 to 5.5?

Background Our production environment runs on a system that nobody wanted to update for a long period of time. With a new sherrif in town, we're going to update it. Production is MySql 4.1 with ...
0
votes
0answers
822 views

convert SQL file into CSV directly without server

I have a quite big mysqldump file (36G) I know I can use mysql < big_file.sql SELECT * FROM big_table INTO OUTFILE '/tmp/big_table.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED ...
0
votes
0answers
42 views

mysqldump replace option - ubuntu / mediawiki

I know this is probably a silly question, but I'd like to be sure, rather than make assumptions. There's the option to use 'replace' in a mysqldump, which uses the 'REPLACE' rather than the 'INSERT' ...
0
votes
0answers
89 views

How to change the domain name or IP address in mysql database in every tables

I was using Openfire chat server in Ubuntu, whose IP address was 192.168.1.15. Then, I wanted to move it to other ip (192.168.1.55), so i took a backup of my database. The database I was using is ...
0
votes
0answers
113 views

Granting file privilage for an user on amazon RDS(MySQL)

I am having an Amazon setup for my application and I use RDS server which runs MySQL server(Not done by me.Company got it done from some freelance admin). I have a root user created in there but it ...
0
votes
0answers
237 views

Updating +150,000 rows using .sql file causes ERROR 2013 Lost connection to MySQL server during query

I am using ubuntu 12.04. I have a .sql file that is around 5 megabytes. When I use the command: mysql -u -p -v database query.sql The server prints out the content of the file (because of --verbose) ...
0
votes
0answers
118 views

MySQLDump and Amazon RDS

I need to dump the contents of an RDS database into a SQL file, and restore that file to another RDS or MySQL instance. On the RDS instance there are a number of databases and users, and I would like ...
0
votes
0answers
132 views

Error while running automysqlbackup

I have setup automysqlbackup on Centos for a server with approximately 52 databases. I did try to increase the max_connections to 250 and max_allowed_packet to 100M, however that did not solve the ...
0
votes
0answers
57 views

mysql logs same query multiple times or is it application problem?

I have temporarily switched on logging on the server. The site is used in the US and local time there was 4 in the morning so not many people are using it at that time. What I did was delete any logs ...
0
votes
0answers
113 views

Upgrade from mysql 4.1 to mysql 5.5

I was going through upgrade process of mysql server. It is mentioned that to upgrade from 4.1 to 5.5 we need to upgrade step by step like first to 5.0,5.1 ...5.4 and then 5.5. I have some questions : ...
0
votes
0answers
88 views

MYSQL backup options using mysqldump and mysqlbackup

I'm currently using mysqldump to backup mysql database. I heard that mysqlbackup offers a much much better performance. Unfortunately it requires MySQL enterprise version which is pricy. A few ...
0
votes
0answers
705 views

MySQL - Out of memory: Kill process 3046 (mysqld)

We run a MySQL (v5.6.17) dump backup every 4 hours, and today noticed: Apr 19 20:09:30 mysql1 kernel: Out of memory: Kill process 3046 (mysqld) score 970 or sacrifice child Apr 19 20:09:30 mysql1 ...
0
votes
0answers
51 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
0answers
280 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
1k 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
1k 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
0answers
168 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
683 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. ...
0
votes
0answers
465 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 ...
0
votes
0answers
53 views

Phpmy admin not showing my table but mysqldump

I have a db running and suddenly when I go into my phpmyadmin under the db it shows no tables and when I tried to do dump it shows me some of my tables are crash. What is best survival in this case?