1

How to create a local backup of a remote Amazon RDS MySQL database?

view story
linux-howto

http://serverfault.com – How do I create a local backup of a remote Amazon RDS MySQL database? What I need to know is how to make a complete full local backup of a MySQL database (not a remote Amazon snapshot) that can be used to restore to a new database anywhere, on any MySQL server (same version of course). NOTE: I know how to import data from a flat file via MySQL. Here is how I connect: mysql -h mydb.xxxxx.us-east-1.rds.amazonaws.com -u myuser -P 3306 -p Here is how I load a single database table: mysql> LOAD DATA LOCAL INFILE 'C:/Temp/t1.tab' INTO TABLE t1 LINES TERMINATED BY '\r\n'; (HowTos)

dayu's picture
Submitted by dayu on 08/18/2011

Stories similar to How to create a local backup of a remote Amazon RDS MySQL database?

This MySQL Database Backup 1.2.1 is a free and open source software that will help us to automatically or manually backup the MySQL Database. I often confused on how to backup my existing MySQL database stored in my Windows XP box.

MySQL Workbech Wont Connect 2 years 42 weeks ago

I installed on my local desk workstation the MySQL Workbench application. It installed perfect and when I try to create a new connection to my database, it fails and tells me:

Quote:

Failed to Connect to MySQL at 192.168.0.79:3306 with user cmennens

Normally when we create a backup of our MySQL using Mysqldump it creates a Read Lock on the database, so no changes can be made to the database at that time. It may take from a second to few minutes to take up backup of your database. So, sysadmin either prefer to stop MySQL or issue a READ lock on the MySQL table, so that database remains consistent.

How would I do the following command, with a local file, on a remote database (different machine) ?

$MYSQL_PATH/mysql -u root -h remote.net files -e " LOAD DATA INFILE '$1' INTO TABLE $TABLE_NAME FIELDS TERMINATED BY ',' (size, @d2, @d3, @d4, @d5, path)

The problem seems to be that the INFILE at /tmp/infile.txt is not being recognized remotely.

I am trying to crate a shell script that would:

connect to a remote server that has MYSQL running On success run "CREATE DATABASE foo;"

So far I tried:

#!/bin/bash mysql -h 111.11.11.11 -u root -p'XXXXXXX' mysql> CREATE DATABASE foo;

or

echo "CREATE DATABASE foo;";

But no success.

I am using the command line to run the shell script.

# sh create_mysql_database.sh

but all it does is

How to create tables in MySQL 2 years 24 weeks ago

Our Tuesday MySQL tip, how to create Tables in a MySQL Database. Tables are somehow like spreadsheets, and one database may have lots of tables into it. So, once you have created your Database you may create the tables inside the Database. We’ll do it, working on the command line: First connect to the MySQL mysql -u [user] -p

This will ask the password for the user [user], it should be the

I've changed data directory in /etc/my.cnf.

Oracle is the most powerful database software available for many platforms including Linux, Windows and other system. The latest version of Oracle is version 11g Release 2. You can download this new version from the link provided on the bottom of this post.

I have a database in which there is one table where one column has invalid data.

I also have a backup of said database of a few days before. In that backup, that column still has the valid data. But other tables in that database are already incredibly outdated.

So, a full rollback to that backup is not an option.