Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [mysqldump]

MySQL's Standard Dump/Backup Utility

-1
votes
0answers
18 views

Inconsistent MySQL backup duration

Im having a problem with my database. The issue is my backup time using mysqldump is inconsistent. On average, the duration is only for 1hour 30minutes but sometimes it goes to 4, 6, and even 10 Hours ...
0
votes
2answers
28 views

(Partially) clone a huge DB for DEV purposes

I want to setup a dev and test environment for website that has a huge MySQL database. Since this DB is so big, it is quite inconvenient to clone it 1-on-1, because it simply takes too long and uses ...
0
votes
1answer
24 views

Unable to export 8.0.1 MySQL database using MySQL Workbench 8.0

I'm unable to export my 8.0.1 MySQL database using MySQL Workbench 8.0. When I go to perform the export via the "Administration" table, with all the default settings (I didn't change anything ...
0
votes
0answers
17 views

How to effectively, and efficiently and the simplest way to partition and move data from one db to another?

We have a large database with client data, with many entities, but we dont allow connections to the production db (mysql) due to security. Only option remaining is to move some data to development db (...
0
votes
1answer
23 views

How to restore dump from MariaDB 10.1 to MySQL 5.5

I generate backups of my databases by using mysqldump.exe -u root --all-databases > mariaDbBackup.sql. When I try to restore my dump by doing mysql -u root -p < mariaDbBackup.sql, I get an ...
0
votes
0answers
9 views

MyISAM Mysqldump failing with a 1.5GB database on a VPS

It's basically because of a memory issue. I just downgraded to 2GB ram on this openvz vps. And the swap can't be changed from 512mb. Another database at 350MB has no issue finishing. But the 1.5GB db ...
0
votes
0answers
8 views

How to know if a sql dump has been already imported?

I am writting a Dockerfile where the entrypoint script checks if any *.sql file present inside initdb.d dir then it import that *.sql file. However as this import mechanism is a part of entrypoint ...
0
votes
0answers
23 views

How to ignore errors in mysqldbcopy

Is there an option to ignore errors and continue copy in mysqldbcopy
1
vote
1answer
76 views

Slow mysqldump on big table

I am running MySql 5.6 on Google cloud as VM instance, one of the tables contains 1500,000K rows with 676G .ibd file. using mysqldump --opt --add-drop-table --quick DATABASE BIG-TABLE >DATABASE....
1
vote
1answer
22 views

Error while restoring the table dump

ERROR 1067 (42000) at line 25: Invalid default value for 'created_on' I'm getting this error while restoring a table after taking the dump(remotely). I have used mysqldump -h (hostname) -u -p (...
1
vote
1answer
36 views

Import Windows MySQL dump on a Debian Linux server

I created a test database on a Windows computer with MySQL 5.7 and filled it with many data records. Now I created a database dump with mysqldump and wanted to import it on my server (Debian Jessie, ...
0
votes
1answer
28 views

How to specify “partition (partx)” in “mysqldump” command?

I have to export some data from a table which is partitioned, and with some extra condition So I use mysqldump command,and use --where"xxxxxx" options as below mysqldump -hxxx -Pxxx -uxxx xxx rtm --...
1
vote
2answers
64 views

mysql innodb dump restore slows down after upgrade mysql 5.7 to 8.0

I'm struggeling the last two days with the following issue: Restoring a ~1GB database dump with only innodb tables on a mysql 5.7 server takes about 5 minutes. After upgrading the same server to ...
1
vote
2answers
80 views

Mysql: set variable in mysqldump

I recently added a global variable in mmy.cnf max_statement_time=120 ; to stop long running queries and to throw an exception. Its working fine. Then I am unable to run mysqldump for backing up all my ...
0
votes
1answer
88 views

mysqldump from AWS RDS slowing down

Im taking a db backup from AWS RDS (MySQL) slave from an EC2 (m5.large - 2c/8GB) in same AZ using - mysqldump -hxx -u xx -p --extended-insert --single-transaction --max_allowed_packet=1G db > ...
1
vote
0answers
17 views

How to fully dump mySQL database via workbench?

I am exporting database in SQL file using workbench. Export is done successfully, but when I import data and compare record counts with older database, some of the records are missing. Not all records ...
0
votes
1answer
31 views

mysqldump insert data to exists table

hellow Dumped x.sql file from db and then trying to find way to insert data from x.sql file to existent tbl in another server. But mysql execute all the concept of the x.sql ( that include "drop ...
1
vote
1answer
92 views

Backup via mysqldump. Is this safe to do on production or will it crash the server?

I want to run this command during the time in which the production server is running the application: mysqldump -u sbp -p databasename_production > databasename_development_copy.sql Is this safe ...
1
vote
1answer
79 views

MySQL Enterprise Backup download site

I was given a sever to use for tests that has MySQL commercial version installed. I would like to test backups using MySQL MEB, but cannot find the download site. I have seen many blogs mentioning ...
2
votes
1answer
57 views

mysql dump best practices for development

I have an application that has a large database that includes, among many other tables, a table called content and a table called users. I would like to set up a development environment for this ...
1
vote
1answer
51 views

Importing a mysqldump from MySQL 5.0.95 to MariaDB 10.0.36: Some tables incomplete

I have an ancient MySQL setup (5.0.95) that I'm trying to shut down. We've mysqldumped the databases we need, and we're trying to import them into MariaDB (10.0.36). We're running into some odd quirks,...
1
vote
2answers
31 views

Importing huge dumps into a mysql server 5.5

I want to import a couple of huge .sql dumps (~600G each) into a mysql server 5.5 running on an Ubuntu 14.04. The machine has about 8G of RAM allocated to it; The previous machine had 128G; Storage ...
1
vote
1answer
136 views

Getting Master Current Binlog and Binlog Position in Replication Backup

I want to take the current binlog file and binlog position of the master server in a mysqldump on the slave server. I cannot use master-data=2 on slave - how can I do this nevertheless?
0
votes
1answer
443 views

Mysql Restore - ERROR 1227 (42000) at line 30908: Access denied DEFINER issue

Im trying to restore the database dump which has the DEFINER=test@%. Backup file is 50GB. OS - CentOS 7.5 While restoring this, I got the below error. ERROR 1227 (42000) at line 30908: ...
-1
votes
1answer
48 views

Web interface or tool for developers to run select query with out access database directly [closed]

I want a tool or web interface that can allow inside users (developers,..) to run select query with out access the database directly. I don't want to give sql user to all the developers for the ...
0
votes
1answer
187 views

0kb backup using mysqldump

Same question has been asked here but its not helping me out. In my python utility, I'm trying to take MySQL database backup using mysqldump. It runs successfully but I'm getting 0kb file in my ...
-1
votes
2answers
77 views

check syntax errors on mysql dump file

I have an issue to check syntax error on MySQL dump file. Please inform me a tool or command to check syntax on MySQL dump file. Thank You.
0
votes
0answers
4k views

mysqldump Unknown table 'COLUMN_STATISTICS' in information_schema (1109)

I am having some difficulty with my MySQL database. It appears the server suffered from a power outage during the night. As a result, MySQL wouldn't start when it reboots. I viewed the error log ...
1
vote
1answer
833 views

Mysqldump with ansible for database backup

I am trying to backup remote database using ansible and mysqldump. I have installed ansible in my local server.Generated the ssh keys. I also sent the public key to the remote server. Everything is ...
1
vote
1answer
28 views

Restore MySQL tables with data folder only?

I have many MySQL databases with many tables and I’m trying to figure out if I can restore all of it only using the content of my MySQL data folder. Or should I just not bother and use the following ...
1
vote
1answer
155 views

mysqldump generates incorrect create view queries

I use mysqlpump to backup database: mysqlpump --single-transaction --add-drop-database --skip-definer \ --databases mydatabase --result-file /opt/myservice/backup/export.sql My DB contains several ...
1
vote
0answers
54 views

Mysql dump is not full

I have installed fresh ubuntu 16.04 with apache2.4 and php7.0 on it and then installed mariadb. Here is version: mysql Ver 15.1 Distrib 10.0.35-MariaDB, for debian-linux-gnu (x86_64) using readline 5....
1
vote
2answers
268 views

Significantly Slower DB Dumps on AWS RDS After Turning on Encryption?

Turning on encryption on an AWS RDS MySQL instance results in significantly slower database dumps (using mysqldump). mysqldump -u test -p -h xxx.aws.com > dump.sql Is there a reason for ...
0
votes
1answer
370 views

MySQL Workbench is adding --enable-cleartext-plugin option on mysqldump command

For some reason my copy of MySQL Workbench on one of my servers has started adding this --enable-cleartext-plugin option on every mysqldump command, which results in this error every time. 20:13:02 ...
0
votes
0answers
31 views

Import MySQL Dump into Database Table with Another Table Name [duplicate]

I have exported the selected records from a table using mysqldump using --no-create-info and --where options. But the dump contains a statement like INSERT INTO `table_name` VALUES I cannot ...
0
votes
0answers
43 views

How to take mysql backup more than 300 GB?

For Syncing mysql replication we need to take backup of master data more than 300 GB.Which is the best method for backup in this scenario ?
0
votes
1answer
480 views

MariaDB: point in time backup recovery with binary log using position

Following the below sequence of commands i expected the recovery of backup and subsequent point in time recovery using binary log. However, the database was restored to backup only: 1) CREATE TABLE ...
0
votes
1answer
75 views

Mysql Dump Taking longer time

Mysql Dump Taking longer time I have 188 databases, which I am individually dumping in a loop using a shell script as below echo "$(date +%b-%d-%y) Dumping Started at $(date +%r)" | tee -a $DEST/...
0
votes
1answer
284 views

delete tables on import of dump created by mysqldump

There are 2 copies of the same database on 2 different storages which need to be in sync. For example, database named test_db contains tables T1,T2,T3 tables. T2,T3 are deleted. Dump of the 1st copy ...
-1
votes
2answers
119 views

Which way should be selected when move from mysql to mariadb? [closed]

Now, the mysql version is 5.1.I plan to move to mariadb 10.2.Use mysqldump and source to update databases. Based on MySQL Upgrade Strategies, Upgrading to the latest release is recommended before ...
1
vote
0answers
126 views

My node js server stops listening on mysql db

I implemented a listener on a table in a MySQL database with a MySQL event that is based on listening on binlog. However, the problem is that after a while my node.js server stops listening on the ...
2
votes
1answer
68 views

Proper Way to Remove Mysql Tables

I was going to ask why mysqldump was trying to write dropped tables but I found that answer from this question, How do you remove reported non existing tables from mysql?. Removing the .frm files ...
0
votes
0answers
126 views

Migrating on-prem MySQL 5.5 databases to AWS RDS MySQL 5.5

Migrating on-prem MySQL 5.5 databases to AWS RDS MySQL 5.5 Background Information: I have a MySQL 5.5 dump. I have migrated the same dump to an EC2 instance and it worked. I did restore to EC2 ...
1
vote
1answer
117 views

mysql backup validation

Need help regarding backup validations for MySQL, what is the best way / easiest way to validate Mysql backups. we are using mysqldump backup for taking backup's and tar the backup file at the end, ...
0
votes
0answers
17 views

How can I dump a set of tables with including where data time clause?

I want to dump a set of tables from a database that begin with "jugada_%" , I also want data from "now date". Can you give an exmaple how can i do this?
1
vote
3answers
345 views

Mariadb processes stuck after aborted dump restore. What to do?

I tried to restore a database dump on my local server. I have created the database locally myself. The dump creates the tables and insert all the data. I used 'source "C:\my_dump_file.sql"' to start ...
0
votes
2answers
46 views

Move data from MySQL 5.0 to other server with MySQL 5.7

We are switching servers from a Windows Server 2003 (32-bit) with a MySQL 5.0.51b to a Windows Server 2016 (64-bit) on which I will install the latest MySQL version (5.7). The database contains just ...
1
vote
2answers
106 views

How can I take backup MySQL database from one cloud server to another?

How can I take backup (by mysqldump) MySQL database from one cloud server to another? I have a MySQL server that uses innodb and is about 150GB size. I want to take backup of database to other ...
0
votes
1answer
963 views

Mysqldump error : Couldn't execute 'show table status

I have a database that I want to export. It has about 6 GB. PhpMyAdmin could not handle it, so after reading a little bit about it I am trying to do it from the console, unsuccessfully. When I run : ....
1
vote
0answers
404 views

mysqldump incremental backup — slight confusion

I am Avinash, I have a slight confusion about incremental backups. I am going through the MySQL 5.7 Docs to study the backup process using mysqldump. I am not using any master-slave configuration. I ...