mysqldump : MySQL's Client Backup Utility

learn more… | top users | synonyms

0
votes
0answers
10 views

Use mysqdump to backup table with a new table name [migrated]

Is there a way to back up a table using mysqldump so the table that is being backed up can have a new name in the sql script created by mysqldump. So that If I back up the table 'test_table' like so. ...
0
votes
1answer
70 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
21 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
373 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
0answers
12 views

List and backup of database on MySQL by last modified

It may be simple question, but your answer may be useful for me, We've development server on Ubuntu 10.24 with MySQL Database, It contains more than 1500 Database. I would like to take backup and ...
0
votes
0answers
52 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
297 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
43 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
225 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
48 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
67 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
146 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
757 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
358 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
2k 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
153 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
1answer
594 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
6k 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
515 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
4k 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
2k 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
4k 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
185 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
735 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. ...
1
vote
3answers
13k 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 ...
0
votes
2answers
3k 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
259 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
786 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 ...
20
votes
4answers
11k 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
234 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: ...