Questions tagged [mysqldump]

MySQL's Standard Dump/Backup Utility

Filter by
Sorted by
Tagged with
0
votes
1answer
369 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
11 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
70 views

How to ignore errors in mysqldbcopy

Is there an option to ignore errors and continue copy in mysqldbcopy
2
votes
1answer
208 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
80 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
116 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
341 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
97 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
570 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
417 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
29 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
211 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
383 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
438 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 ...
1
vote
2answers
88 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
111 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
76 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
527 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
1k 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
57 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
2answers
423 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
315 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
6k 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
3k 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
49 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 ...
2
votes
1answer
547 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
64 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
3answers
457 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 ...
1
vote
1answer
995 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
1answer
1k 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
124 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
911 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 ...
0
votes
2answers
179 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
212 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
122 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
224 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
304 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, ...
1
vote
3answers
686 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
71 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
181 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
2k 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
554 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 ...
5
votes
1answer
3k views

mysqldump on slave (without stopping replication)

Is it okay to run mysqldump --single-transaction on Slave DB without stopping replication (stop slave;)? This is for regular daily backup so we can restore Master DB in case of a storage disaster. ...
3
votes
1answer
336 views

mysqldump slow on Windows unless piped to file

Running mysqldump without piping to file such as: mysqldump -u root -pPASS db is really slow on windows. If I do mysqldump -u root -pPASS db > db.sql it runs fast. This might not seem like a ...
2
votes
1answer
656 views

mysqldump stuck at “Connecting to”

I'm having a weird problem with mysqldump. I have a docker instance of mysql (5.7) to which I can connect just fine (to any database). I can also use mysqldump to dump the databases except one - after ...
0
votes
2answers
878 views

MySQL dump tables from remote server

I'm trying to dump all tables of a specific MySQL database into each file(s) per table from a remote server. I tried to use mysqldump with option --tab=dir_name as the output directory, but it seems ...
0
votes
1answer
45 views

Databases for training (MariaDB) [closed]

I'm practicing for enrich my knowledge, and i would like to have more databases than actually i have (2). Where i can found free databases for practice? If it's possible, big databases. I'm traing ...
6
votes
1answer
9k views

MySQL - MySQLDump problems with large table

I have a MySQL database that is 10.6GB - that has both MyISAM & InnoDB tables. One particular table (called 'responses') is 8Gb - this table is InnoDB. The live database is replicated to a ...
0
votes
2answers
827 views

Dump single rows (with blobs) to single files

I am creating MySQLDumps for the sake of versioning of a database. The problem currently is a table with blobs. My first approach would be to dump single tables to single files. But next, I want on ...