mysqldump : MySQL's Client Backup Utility

learn more… | top users | synonyms

0
votes
2answers
16 views

How do I find out how long a command has been running for using time command?

I have a long mysqldump thats been running for over 2 days now (many 100s of GBs of data being archived). I started the command with time so that I could see how long it took when it finished. Is ...
0
votes
0answers
53 views

Exporting / Importing MySQL from/to different character sets

It's fairly straightforward. I have a db running tables with DEFAULT CHARSET=utf8; The collation is set to utf8_general_ci. Everything is working fine. The application that uses this database saves ...
0
votes
0answers
14 views

MySQL database dumps on Windows 7 when one doesn't know the username, password, database name and host name

I've read this http://blog.winhost.com/using-mysqldump-to-backup-and-restore-your-mysql-databasetables/ but the problem is I don't know the username, password, database name or local host name as I ...
0
votes
1answer
165 views

command executed in nohup is killed as soon as the putty terminal is closed

I have an Amazon ubuntu ec2 instance I'm using PuTTY to access the same. Here, I have a large database in mysql. I'm executing the following command to take the backup of my database. nohup ...
0
votes
1answer
85 views

MySQL dump permission error

It seems strange but when doing mysqldump -h host -u backup -p database | gzip > /tmp/test.gz I get Access denied for user 'backup'@'%' (using password: YES) when using LOCK TABLES When ...
0
votes
1answer
141 views

Possible to export/import remote DB to WAMP server?

If I needed to gzip a remote database and import it into my WAMP MySQL database I believe the command I should use is - ssh user@server "mysqldump ericdev | gzip" | gunzip | mysql ericcart But how ...
3
votes
1answer
621 views

How to dump and compress MySQL database in Windows only using command line

Is it possible to backup and compress just like in Linux: mysqldump --all-databases | lzma > all.sql.gz I only have smb:// and cmd.exe access via winexe, so no GUI (remote desktop is not enabled, ...
0
votes
1answer
964 views

How do I create & restore a mysql database dump with Chef?

Environment Ubuntu 12.04 Precise64 Enterprise Chef opscode-cookbooks/mysql opscode-cookbooks/database Wordpress 3.9 Objective I am trying to replicate/clone my production Wordpress server. I'd ...
0
votes
0answers
27 views

Wy is mysqldump producing structure only

OS Version: Ubuntu 12.04.4 LTS MySQL server version: Server version: 5.5.35-0ubuntu0.12.04.2 (Ubuntu) I have been using the following command to produce a data dump: mysqldump -u someuser ...
1
vote
1answer
755 views

mysqldump not on wamp server

I am trying to use mysqldump on my wamp server mysql console however, it doesn't seem to have mysqldump included. I found the mysqldump.exe file in this location: ...
0
votes
1answer
120 views

Trying to migrate a mysql server to AWS

Please advise on how to migrate my local mysql server to the cloud. Currently I have a Fedora linux box and a NAS attached to it via ethernet. I believe the best way to go about it is : Take a ...
0
votes
0answers
449 views

mysqldump to local mysql database through ssh

This command: ssh bruchowski@www.example.com 'mysqldump -u bruchowski -p dbname' > mysql -u root dbname Produces this error: mysqldump: Got error: 1045: Access denied for user ...
1
vote
0answers
53 views

How to dump all MySQL databases for one specific user?

I need to export a particular user's databases so that they can take them to a different server. I have 30 or so users and many dozens of databases. This particular user alone has about 20 or so. ...
1
vote
3answers
456 views

Crontab job doesn't create db backups with `mysqldump` command

When I type in my VPS: $ mysqldump --opt --user=root --password=myPass dbName>/home/myuser/dbName.sql it works and makes a backup of my dbName, but if I do it from a crontab job, it creates an ...
0
votes
1answer
119 views

sending the date in the subject in crontab

In crontab I have the following cronjob working. 0 0 * * * mysqldump -e --user=root --password=MYPASSWORD MYDB | gzip | uuencode db_date +"\%Y-\%m-\%d".gz | mail -s 'date +"\%Y-\%m-\%d"_dump' ...
1
vote
0answers
81 views

MySql dump restore from Run Dialog (not the cmd prompt)

I need to restore a mysqldump on a windows machine, which i perfectly know how. But I need to do it via the Run Dialog in one GO. So we open the Run Dialog and type : "[PathToMysql]\mysql.exe" -u ...
1
vote
0answers
246 views

mysqldump alternatives --hex-blob doesn't convert geometry binary columns to hex

I'm trying to create a mysqldump in utf8 encoding. The table I'm trying to dump contains geometry columns. Now, when I use the --hex-blob option, the geometry columns don't get converted to hex. Are ...
1
vote
0answers
924 views

Ubuntu 10.04: mysqldump: command not found and wouldn't install mysql-client

Some packages have gone missing from my Ubuntu server and few things are not working because of that. When I try to install mysql-client I get this error: # sudo apt-get install mysql-client-5.1 ...
2
votes
1answer
531 views

mysqldump command when you don't specify path outputs to terminal?

I'm wondering if I don't specify path to mysqldump command, no file will be saved and output will be just seen on terminal screen? Is this correct?
1
vote
1answer
3k views

MySQL - Avoid table locks during backup

I am running nightly backups on my server using mysqldump. Unfortunately that pretty much kills my site for half an hour or so every night, since the tables are getting locked during the backup. ...
2
votes
0answers
163 views

Creating database from dump, InnoDB tables created, ISAM tables not [closed]

Hey I'm getting a weird issue with mysql dumps on a Linux box Reproducing: Dump from mysql on box 1, the database has a mix of InnoDB and ISAM tables Copy the dump to box 2 Create a new database ...
4
votes
2answers
793 views

Shell script of mysqldump works fine when run manually, but does not run in the cron job?

I have a shell script to get a MySQL database dump. This script works fine when run manually #!/bin/sh fqn=/home/Mysqluser/daily_dumps/bookstore_`date +%Y%m%d_%H%M%S`.sql.gz mysqldump -u root -h ...
0
votes
1answer
2k views

How can I get a mysqldump file encoded in utf-8 for psql?

I am migrating some data from a MySql database (v5.1.44/MyISAM/collation=latin1_swedish_ci) to a PostgreSQL (v9.0.4/the one included in OSX Lion). I'm using $ mysqldump --compatible=postgresql > ...
0
votes
1answer
81 views

How to prevent directory contents from changing while doing a backup?

I have a web-application that stores data into a MySQL database and on the filesystem. Some of the database records reference some of the files on the filesystem. Now I want to create a snapshot of ...
2
votes
4answers
8k views

Can't create a MySQL dump on Windows, fails before password prompt

I'm trying to create a dump of a locally installed MySQL database on my laptop. I am aware of the command: %>mysqldump -u root -p --opt [database name] but I am not able to execute it. I might ...
0
votes
2answers
534 views

How to setup crontab on dedicated server to dump WordPress MySQL database and email it to a Gmail account

I know I can do a mysql dump for my WordPress databases on my dedicated server. But I want to do this automatically, and I want the dump to be emailed to my Gmail account. Is this even possible?
2
votes
2answers
5k views

How to tune MySQL for restoration from MySQL dump?

My little 5GB database which takes 5 minutes to dump via mysqldump, takes 9 hours to restore. Luckily I found this out during a test-run, not an actual emergency situation. What are the best ...
1
vote
4answers
3k views

mysqldump cron not dumping

I am attempting to setup a cron to use mysqldump once a day. There is no output and I cannot see any database usage while watching top. The crontab is: mysqldump [database] -u[user] -p'[password]' ...
1
vote
2answers
5k views

Convert MySQL backup (dump script) to MS SQL?

I have a mysqldump output of a fairly large (by measure of doing things manually) database saved in a text file. Does anybody know of a (free) way to use this to build a database in MS SQL? I'm ...
2
votes
4answers
205 views

MysqlDump Long Load Times

I am using mysqldump database > output.sql to dump all the data in a database. The size of the output file is around 3.3 GB. I am importing it using mysql < output.sql however it has been ...
0
votes
4answers
985 views

Simple question about using mysqldump

I have a LAMP website with mysql backend with InnoDb engine for tables I would like to be able to use mysqldump to take periodic dumps of the database - WITHOUT having to stop the mysql server (i.e. ...
2
votes
3answers
19k views

installation mysqldump

i use linux ubuntu..i try to copy db and type some mysqldump command.. but at terminal show: The program 'mysqldump' can be found in the following packages: * mysql-client-5.0 * mysql-client-5.1 ...
1
vote
2answers
5k views

how to use mysqldump?

I want to copy my database qdbase server. It is located at: qa@qaubuntu:~$ /var/lib/mysql/qdbase On the client PC, I want it located at: qa@qadesktop:~$ /home/qa/html Everyone tells me to use ...
0
votes
1answer
282 views

What is the most efficient way to implement a cron job to back up a MySQL database and e-mail it to myself?

What would be the most efficient way to automatically back up a MySQL Database, gzip it, and e-mail it to a specific account? I am a bit paranoid about losing my forum's database and I'm usually busy ...
3
votes
2answers
919 views

Where Are Databases Located - MySQL File Location

I just installed a CRM application with a MySQL database. I thought I new the name of the database but I can't find it. Now I am trying to perform a mysqldump but I don't know the name of my ...
30
votes
4answers
17k views

Escaping a password using mysqldump console

I am running a mysqldump via a bash script and have encountered a problem with a password that contains special characters. mysqldump -hlocalhost -uUSERNAME -pPA$$W0RD DATABASE | ...
1
vote
1answer
236 views

Having trouble running a cron job in Unix which generates a dynamic filename for an output data dump

I am trying to schedule a MySQL database dump by using cron but I get an error for some code that I know works when I call directly in Shell. Here is the code that works perfectly well in Shell: ...