Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [mysqldump]

mysqldump : MySQL's Client Backup Utility

1
vote
1answer
23 views

Restore SQL Database from full system backup

long story short I am restoring a failed server. I have a backup of most of the file system. I need to restore the SQL databases but I don't have a copy of the mysqldump. so I've restored the files to ...
0
votes
0answers
47 views

Rsync on Windows issue

I want to get SQL database file from a remote machine using rsync. I've already installed DeltaCopy on my Win7 PC, but all I have is the one URL: rsync://export@10.123.101.225/folder/dmp_db.sql.gz ...
0
votes
1answer
60 views

Best method to transfer/clone large MySQL databases to another server

I am running a web application within a shared hosting environment which uses a MYSQL database which is about 3GB large. For testing purposes I have setup a XAMPP environment on my local macOS ...
2
votes
1answer
130 views

mysqldump from a local machine, no ssh access to remote

I can ssh to a a server (on a private network, via VPN connection), that has Apache installed on. Internal ip for this server is 192.168.10.98. Web framework on this server can connect to MySQL server ...
1
vote
2answers
355 views

Extract portion of text file from first occurrence of one string to first occurrence of another

How can I extract a portion of a large text file, starting at the first occurrence of FOO and ending at the first occurrence of BAR? In my case, I'm trying to extract a portion of a sql file created ...
1
vote
1answer
142 views

How to disable mysqldump command

I want to disable mysqldump command for all user's including root. As I am taking DB snapshot. After removing mysqldump binary file from /usr/bin/ location. But is it safe to do so?
1
vote
1answer
280 views

mysqldump: specify per-user db name in ~/.my.cnf

I'm running a shared server with multiple users. Each user has their own database in MySQL and associated credentials. I've created a template systemd timer & service (ie. sitetasks@.timer & ...
0
votes
2answers
61 views

MySQL backup using cmd

When I try to backup my DB using command prompt command mysqldump -u root -p db_name > path to store It prompts Enter password: And within seconds before I enter my password, it redirects back ...
-1
votes
1answer
149 views

Ubuntu 14.04 unable to install/find mysqldump

I have a VPS with a working CMS (Ubuntu 14.04 LAMP). CMS is perfectly working, but I'm not able to automate back-up (rsnapshot witch scripts calling mysqldump) cause I can't find mysqldump in the ...
0
votes
0answers
96 views

Attempt to import dump-file into remote MySql server generates error -“1449”

Attempt to import .sql file generated by mysqldump.exe into another MySQL Server generates Error - "1449: The user specified as a definer(jboss@localhost) does not exist". So far I have attempted to -...
0
votes
2answers
32 views

MySQL & Terminal: Permissions Issue

I cannot seem to push information up into my database via Terminal. MySQL logic is proper, and it acts like the dump was successful. However, the data never gets pushed up into the DB. I'm even logged ...
0
votes
1answer
1k views

Windows Server 2012: how to automate the dump and zip of a MySQL database

I am using a Windows Server 2012. I need to perform a dump of my database every two hours and zip the SQL generated file. The zip file must have this syntax: nameOfFile_date_hour.zip. I don't need ...
0
votes
1answer
2k views

Include current timestamp in filename?

I have to create a lot of DB backups manually using mysqldump, for example like this: mysqldump -uroot -proot my-db > my-db.sql I'm wondering if there's an easy way to include the current date or ...
2
votes
1answer
396 views

Crontab command not executed

I have a command in my crontab that doesn't execute correctly, this should backup the database everyday at the specified time. I tried running the command in my terminal and is working properly. To ...
0
votes
2answers
274 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 ...
1
vote
1answer
1k 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
907 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
492 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 ...
4
votes
1answer
8k 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
2k 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 to ...
0
votes
0answers
35 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
2k 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: /cygdrive/c/wamp/bin/mysql/mysql5.6....
0
votes
1answer
214 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
817 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 'root'@'192.168....
1
vote
0answers
131 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
907 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
499 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' john@...
1
vote
0answers
100 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 [...
4
votes
0answers
690 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
1k 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
1k 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?
2
votes
1answer
9k 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
191 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 on ...
4
votes
2answers
2k 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
3k 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
88 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
11k 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
587 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?
4
votes
3answers
7k 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
4k 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
7k 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
359 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
2k 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. ...
11
votes
4answers
47k 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 ...
5
votes
2answers
20k 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
313 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
2k 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 ...
48
votes
4answers
41k 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
267 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: ...