Questions[mysqldump](server)

I'm facing an issue when dumping a mysql database to the network drive. The thing is I'm getting really slow speeds (around 3-7mb/s).

Dumping locally, the speed is fine. I've coded my own program that performs automatic backups 4 times per day and dumps from main server (windows vps) to a Linux vps’s samba server. Both of the servers have 1gb/s port speed. The thing is, for example when I manually upload a random file to the Linux machine's samba server, I get speeds up to 100mb/s. The database is around 45GB large. Also, before I was performing backups on a windows machine, had the program running there and it dumped the databases over network, speeds were also up to 100mb/s then. What could be the issue that i'm getting so slow speeds when dumping directly to the network drive?

The command I use:

mysqldump -u root -ppassword --single-transaction --hex-blob database worlds > "\\mysambaserver\Storage\folder\worlds.sql"

Hello I have a linux bastion host in AWS that I am able to SSH into. In the Bastion I am able to run a mysqldump command which makes a copy of an RDS instance. What I want to accomplish is being able to make a copy of a specific RDS snapshot. When I run the mysqldump command the copy is properly made but it returns the latest RDS data.

The original command I ran (which works) is something like:

mysqldump -u johnDoe -p -h my-rds-endpoint.rds.amazonaws.com --single-transaction <my-db-name> > /tmp/testData.sql

Is there a way to use this same command to return specific snapshot data. Sort of like:

mysqldump -u johnDoe -p -h <rds-snap-shot-arn-here> --single-transaction <my-db-name> > /tmp/testData.sql

Is this possibly using either the arn or the DB snapshot name?

Thank you.

I wanted to backup my MySQL database and I accidentally used mysql command instead of mysqldump. So I executed:

/usr/local/mysql5/bin/mysql -u db_username -p db_name > db_backup.sql

Instead of:

/usr/local/mysql5/bin/mysqldump -u db_username -p db_name > db_backup.sql

I was ask for the db password and nothing happened after. The process just didn't react and I had to kill it. Could this have damaged my database?

I am trying to install mysqldump on a Azure hosted Ubuntu VM.

During the build process I attempt the following command:

sudo apt-get update
sudo apt-get install -y --no-install-recommends mysql-client-8.0

This results in the following error:

Unable to locate package mysql-client-8.0

When I look at the package on packages.ubuntu.com, it is listed under Ubuntu Focal 20.04LTS (https://packages.ubuntu.com/focal/mysql-client-8.0)

If I change the installation command to:

sudo apt-get update
sudo apt-get install -y --no-install-recommends mysql-client

It installed mysql-client-5.7 which isn't running properly. Is the mysql-client version for the appropriate database tied to the Ubuntu server? Should the 5.7 client work correctly with MySQL 8.0?

How to log the error and warning while restoring the SQL dump on MySQL ?

Following are the steps we were doing.

mysql> CREATE DATABASE dbname;

mysql> USE dbname;

mysql> SOURCE dbdumpname.sql