Questions tagged [mysqldump]
MySQL's Standard Dump/Backup Utility
1
vote
1answer
16 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
20 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
0answers
9 views
mysqldump from MySQL5.1 to MariaDB 5.5 breaks Wordpress site
We have an unstable Windows installation of Wordpress that uses MySQL 5.1.73. I am trying to migrate/upgrade this to MariaDB 5.5.62. I am creating a mysqldump of the Wordpress DB, uninstalling MySQL 5....
0
votes
1answer
9 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
34 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 ...
0
votes
0answers
17 views
Unable to import Parsed MySQL Binlog into the database
Here is my parsed binlog. It having the my insert script preceding with "###". When I try to import the script but these insert statements not got executed. Is anything I have to change ?
sudo ...
1
vote
2answers
33 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
34 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
13 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
21 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 ...
0
votes
0answers
19 views
MySQL CLI doesn't quit when done running mysqldump output file
I'm trying to run a database sync between 2 databases on the same host.
This is the export:
mysqldump --skip-opt -t --replace --single-transaction -q -h <host> -P 8192 -u <user> -p<...
1
vote
1answer
45 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
40 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
48 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
41 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
29 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
89 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
306 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
47 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
130 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
39 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
464 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 ...
0
votes
0answers
119 views
MySQLDump with Pipe Command in Windows
Is there a way to use the pipe command with MySQLDump on Windows. The problem I have is that I need to dump a slave database onto a new server. The Database to be dumped is apx 300GB. If I write it to ...
1
vote
1answer
27 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
111 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
51 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
231 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
288 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
30 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
41 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
344 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
66 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
188 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
109 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
101 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
65 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
102 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
97 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
16 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
274 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
43 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
94 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
770 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
335 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 ...
3
votes
1answer
1k 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
194 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 ...
0
votes
0answers
366 views
mysql dump is giving error while doing table alteration
I have to take consistent online mysqldump for re-syncing the slave in master-master replication without locking the tables. Insert-updates are working fine while taking dump in master(data consistent)...
0
votes
1answer
202 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
598 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 ...
