MySQL's Standard Dump/Backup Utility

learn more… | top users | synonyms

1
vote
2answers
57 views

What are the minimum persmission required to restore mysql dump

I'm trying to create a cronjob which will be populating the data on the server from a local machine. What are the best permission which are required to restore mysql Dump I want to restore the dump ...
6
votes
2answers
2k views

Error on import of mysqldump file - Illegal double value found during parsing

I am currently getting the following error while trying to import / restore a mysqldump file: ERROR 1367 (22007) at line 445: Illegal double '1.79769313486232e+308' value found during parsing I ...
1
vote
1answer
60 views

Export and Import large database from one rds of amazon to newly created amazon rds

We are facing some issue. We would like to export and import mysql database "xyz" from old rds say xyz-rds to newly created rds say abc-rds (mysql). We are approaching common method taking full ...
2
votes
0answers
345 views

mysqldump vs mysqlpump

I just heard about mysqlpump - it looks like it was released with MySQL 5.7, however MySQL 5.7 still includes mysqldump. They're both backup programs, but could anyone summarize the main differences? ...
0
votes
1answer
44 views

Will a mysqldump ever break my database?

I tried to backup my database with mysqldump. I've done this on a live website also. Is there any chance that this command could ever break a website/database?
3
votes
3answers
7k views

What is the best way to recover from a mysql replication fail?

Today, the replication between our master mysql db server and the two replication servers dropped. I have a procedure here which was written a long time ago and i'm not sure it's the fastest method to ...
2
votes
1answer
84 views

How to make sure that mysqldump command is working in command prompt

I'm getting this error: C:\Users\IT-Admin>mysqldump 'mysqldump' is not recognized as an internal or external command, operable program or batch file.
0
votes
1answer
67 views

Number of rows in SQL dump [closed]

Is there any way to check how many rows are in an SQL dump file? I have a large 32GB dump, and wanted to check how many rows are in the file. I am using a windows machine with a MySQL server, ...
0
votes
1answer
30 views

Why is mysqldump not saving newly added databases?

I am using the following command to backup all mysql databases in script that is run as cronjob. mysqldump -u root -p'***' --all-databases > backupdb.sql I have added new databases recently and ...
1
vote
1answer
130 views

How to dump whole database from remote server on sequel pro

I have a database connection to a remote host on SequelPro Mac OSX. How can i dump whole database. I need a dump like what mysqldump command does: $ mysqldump --opt -u [uname] -p[pass] [dbname] > ...
1
vote
0answers
53 views

Mariadb improve performance while import dumpfile

I have a dumpfile with millions data inside. I want to decrease time because I waited too long. I imported 10 million data (3 GB) and I waited 1:30 hours. I will import nearly 100 million data (30 GB) ...
0
votes
0answers
25 views

MySQL import a sql file but login for which is different than localhost db

I have a SQL file which I want to import into MySQL using the command line but get an error saying that the username does not have access to it. The file is too big, like 35GB, so I can't open it and ...
0
votes
1answer
40 views

Use --databases on mysqldump or not?

I have seen this two ways: mysqldump -u username -ppassword --databases mydb >with.sql mysqldump -u username -ppassword mydb >without.sql I did a linux 'diff' on the two and the with.sql file ...
3
votes
1answer
55 views

mysqldump: How to include index type?

When I dump the schema of my database mysqldump --no-data my_db > schema.sql I get lines like this KEY `index_tbl_on_col` (`col`) but I want lines like this KEY `index_tbl_on_col` (`col`) ...
1
vote
2answers
4k views

mysql duplicate entry error 1062 when restoring backup

Sorry, I seen similar threads but I still couldn't find it addressing my issue plus, I needed some more info on this. Requirement: To create an exact replica 'db4' of an existing DB 'db3'. Procedure ...
1
vote
1answer
354 views

Myloader command: Table doesn't exist

I took the backup of mysql database using mydumper command: mydumper -B mydb -o /backup/oct3 -s 500000 -c -m -S /tmp/mysql.sock -u root -p password@123 -v 3 Now, I am restoring mysql database ...
0
votes
0answers
170 views

Restore .dmp file into csv

We have asked our clients for certain data in a csv file format and we just got a .dmp file. I have been trying to open it using MySQL as if it were .dump but it doesn't work. I have seen other ...
2
votes
3answers
326 views

Mysqldump treats some table as View

When doing a mysqldump, some tables are being skipped because mysqldump treats them as View rather than Table although they're 100% tables. So for some tables it looks like -- Retrieving table ...
0
votes
3answers
564 views

Is any tool for taking MySQL Dump Automatically with a particular time? [closed]

I am using VS2010 and MySQL for my project. My client wantw to take mysqldump every day like a daily backup. I want to give my client a tool for taking mysqldumps on a particular time schedule. Do ...
1
vote
2answers
2k 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
1answer
55 views

Importing MySQL tables from other database in live site with mysqldump can cause trouble?

Scenario: I want to replicate MySQL tables from one database to other database. Possible best solution: May be to use MySQL Replication feature. Current solution on what I'm working as workaround ...
0
votes
1answer
76 views

MySQL backup practices

I have a MySQL master-master replication with second master in read-only mode. My questions reg backup are: I have 10 databases so should I take daily backup as one dump containing all the ...
2
votes
3answers
2k 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 ...
9
votes
4answers
18k views

Any option for mysqldump to ignore databases for backup?

We have 40 databases in our server. We want to take 36 databases backup using mysqldump. How can i ignore remaining 4 databases in mysqldump command? Is there any option for mysqldump to ignore ...
4
votes
1answer
10k views

How can I mysqldump all databases except the mysql schema? [duplicate]

I want to backup all 200+ databases on MySQL server to all-dbs.sql. I want to exclude the mysql schema. How can I do that ?
0
votes
0answers
50 views

How to view the data from a .mysql file?

I have a .mysql database file. I need to open it and view the data. I've MySQL Server & MySQL Workbench installed into my Ubuntu 14.04. Now how do I open the .mysql file and view the data inside ...
0
votes
0answers
181 views

Using mysqldump and command line client

Very new to db admin. I am using Windows Server 2012 R2 in a testing environment, trying to teach myself basically. Looking into db replication. I have a very simple and newbie question. I am ...
17
votes
2answers
22k views

What is the recommended way to backup a MySQL/Amazon RDS database to S3?

I have two purposes for this: To have an offsite backup in case of a region wide problem with Amazon Web Services. To copy production data from a production billing account to a beta billing ...
0
votes
0answers
418 views

Cannot locally import UTF-8 encoded SQL database on Mac

I was importing a confirmed UTF-8 encoded SQL database into Sequel Pro on Mac and got thrown this error halfway through: An error occurred when reading the file, as it could not be read in the ...
3
votes
1answer
112 views

Which databases are backed up by “mysqldump --all-databases”?

Which databases are included in the dump generated by mysqldump --all-databases? By my experience, that should be all the user-created databases, plus the mysql database. The database ...
1
vote
1answer
90 views

Unable to load mysql dump file

I recently had to deal with migrating some servers over (rather was forced to by the hosting company) and we took too long to migrate our data so they did it for us. Unfortunately they just copied ...
0
votes
2answers
192 views

Consistent mysqldump of mixed InnoDB and MyISAM tables from RDS instance

I have MySQL db on dedicated server. I would like it to be an external master for an RDS instance. And I want to make backups of RDS. (Currently we have mix of both InnoDB and MyISAM but we are slowly ...
0
votes
1answer
74 views

Copying MySQL schema, some tables not getting recognized!

From the 'data' folder of my colleague I copied the entire 'MyDatabase' folder and pasted that in my own 'data' folder.Now, some tables are getting recognized while others are not.**All the tables are ...
2
votes
4answers
525 views

Moving large databases

I have a centos server and /var/lib/mysql/ is 125GB (disk has 1GB free space). Ordinarily I would use mysqldump to backup the databases, but I don't normally work with such large databases, so I need ...
1
vote
1answer
65 views

Migrating all MySQL databases from from one server another. Getting error during import

I create a mysqldump on all the databases on the source server with this command: mysqldump -h mysql-01 -u root -p --all-databases > newdump.sql This takes about an hour, but runs fine. Now, ...
1
vote
2answers
1k views

mysqldump error on common_schema

I tried to take the backup of common_schema in Server version: 5.5.44 MySQL Community Server (GPL). mysqldump -u root -p common_schema > common_schema_bkup.sql I got the following error: ...
1
vote
1answer
154 views

Mysql shutting down during a mysqldump of a specific database

I have a server which is running Centos 6.6 with Cpanel. I have been attempting to do mysqldump backups on individual databases. All of the databases are under 5MB except for one. The database that ...
3
votes
1answer
8k views

Problem with View When Restoring a MySQL Backup

I have a database (InnoDB) with some tables, views and routines... Periodically I do a backup using the command line: mysqldump -u user -ppassword --routines db_name > backup.sql But I have a ...
16
votes
6answers
33k views

Restore mysql database with different name

How can we restore mysql database with different name from mysqldump file. I dont't want to open dump file and edit it. Any other better methods?
2
votes
2answers
573 views

MySQL : How to restore mysql dump (.sql) ignoring DROP TABLE statement?

I am trying to restore multiple mysql dump (.sql) files. Data in each dump file are from the same table, but with different ID (primary key) range. For example, > 1.sql (0 < ID && ID ...
1
vote
0answers
200 views

How do I restore a mysql dump that was created in xml format?

I have a rather big XML formatted MySQL dump It was created with the --xml param (-X) param of mysqldump. I need to import it in. This article from 2010 indicates that there was no "built in" way ...
2
votes
0answers
171 views

mysqldump restore error

I am getting the error below, while restoring a dump to RDS MySQL 5.6. Dump is taken from MySQL 5.5 originally. I tried restoring twice but same error. Can anyone help ERROR 1064 (42000) at line ...
1
vote
1answer
99 views

Windows crashes on doing sql dump [closed]

Windows simply crashes and opens the blue screen for dumping physical memory on trying to import sql dump. Blue screen error: IRQL_NOT_LESS_OR_EQUAL So far I have tried 4 methods: Through workbench ...
1
vote
1answer
45 views

Backup a MySQL database -options

I'm relatively new to database driven sites. In order to backup a database I use phpMyAdmin's Export function from the server and download the output to my computer. That works, but it requires me to ...
0
votes
1answer
1k views

Is it safe to use mysqldump to backup and restore a master-master cluster

Not sure if the specifics matter but just to get it out of the way I am talking about a Galera cluster on XtraDB (MariaDB). I have a master-master setup and am interested in backing up and restoring ...
2
votes
1answer
50 views

Database Dump/Backup but only to specific records?

This question is about MySQL Backup (or Dump) whereby i want to backup and store information from only information related to a person; SchoolA from the School Table in this example. So, I should not ...
3
votes
1answer
952 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 ...
2
votes
1answer
753 views

Proper procedure for migrating a MySQL database to another Debian machine?

I have one server running an older Debian version with MySQL 5.x and a newer Debian server, also running MySQL. I've created a backup of all databases on the first server like so: mysqldump -uuser ...
0
votes
1answer
23 views

Preserving create_time when loading a mysqldump file [duplicate]

I want to make a copy of a MySQL database but preserve the information_schema.create_time for each of the tables. I haven't been able to find an option to do that with mysqldump.
7
votes
4answers
13k views

Where does the mysqldump command store the backed up databases?

Am trying to backup my databases through the terminal in Ubuntu using the mysqldump command and it's successful , but where does it place the backed up databases ?