Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Mysqldump certain tables
Top Forums UNIX for Dummies Questions & Answers Mysqldump certain tables Post 302743889 by Corona688 on Thursday 13th of December 2012 02:10:58 PM
Old 12-13-2012
I was confused a moment until I saw how you were connecting to the remote server, yes, --compress should help.

You're running mysql 4 times when you only needed to run it once. Using -D makes it simpler too, less lines that need to be fed into it.

Code:
printf "DROP TABLE %s\n" $tbl_names |
        mysql --socket=/tmp/mysql.sock -u LOCAL_DROP -D DATABASE_TEMP --password='mypassword'

mysqldump -u MOVE1 --password='mypassword' -h '107.701.107.701' --opt --compress DATABASE $tbl_names |
        mysql --socket=/tmp/mysql.sock -u root --password='mypassword' DATABASE_TEMP

for table in TABLE1 TABLE2 TABLE3
do
        echo "TRUNCATE TABLE $table;"
        echo "INSERT INTO DATABASE.$table SELECT * FROM DATABASE_TEMP.$table;"
done | mysql --socket=/tmp/mysql.sock -u root --password='mypassword' -D DATABASE

This User Gave Thanks to Corona688 For This Post:
timgolding
 

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Converting tables of row data into columns of tables

I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated. Input: test_data_1 1 2 90% 4 3 91% 5 4 90% 6 5 90% 9 6 90% test_data_2 3 5 92% 5 4 92% 7 3 93% 9 2 92% 1 1 92% ... Output:... (7 Replies)
Discussion started by: justthisguy
7 Replies

2. Shell Programming and Scripting

mysqldump script without hardcode password

OS: Linux ambglx02 2.6.16.60-0.21-default #1 Tue May 6 12:41:02 UTC 2008 i686 i686 i386 GNU/Linux Shell: bash Currently I have a mysqldump script to backup my mysql database, the command is as below: /opt/novell/mysql/bin/mysqldump --add-drop-table -u root -p -h mydb > /home/john/mydb.sql ... (5 Replies)
Discussion started by: bulkbiz
5 Replies

3. UNIX for Dummies Questions & Answers

mysqldump bus error - cored dumped

hi, I need to backup a database but I'm getting the error "bus error - core dumped" just after I run mysqldump command. The server has installed solaris 9. Any help would be appreciated (3 Replies)
Discussion started by: dahr
3 Replies

4. UNIX for Advanced & Expert Users

mysqldump slowing down the process?

Hi All, I have a data calculation process-a perl script running each and every hour which will do some calculations on the data stored in a mysql server. Normally it tooks around 2minutes (max) to complete. But in case if i did any actions on the linux box where the database is... (7 Replies)
Discussion started by: DILEEP410
7 Replies

5. Shell Programming and Scripting

Help needed for mysqldump command

I want to take a backup of a database and redirect the output of the whole process to a log file. I am using the below command: mysqldump -A --add-drop-table > mysql-daily-backup.sql &> /tmp/backup_log/mysql.log Is there anything wrong with the syntax? ---------- Post updated at 08:32 PM... (0 Replies)
Discussion started by: proactiveaditya
0 Replies

6. UNIX for Dummies Questions & Answers

Problem with my crontab file, using mysqldump

My crontab file tells cron to run a certain shell script at 10:30 AM every day. The shell script backs up my database with mysqldump and then runs a sed script that does some editing of the backup file. I have programmed the shell script to write an error message to a file I have in my home... (1 Reply)
Discussion started by: Ultrix
1 Replies

7. Shell Programming and Scripting

Mysqldump rotate backup

I have a very simple script that uses a cron job to take a daily backup of our orders database. echo "Dumping ORDERS database"; mysqldump -u root --password='mypassword' -h '1.1.1.1' --opt --compress ORDERS $tbl_names > /Volumes/Files_Backup_1/db_backups/orders.sql echo "Copied database to... (2 Replies)
Discussion started by: timgolding
2 Replies

8. Shell Programming and Scripting

Need Help with automatically Import from special mysqldump

Hi @ all I need a little bit help with a tricky problem ... Here´s the situation: We´ve 2 MySQL-Servers, one is productive, the other is Backup. At the productive Server there runs every 2 hours a cron Job which does a Dump from MySQL-DB with script 'automysqlbackup.sh' and copy it then... (7 Replies)
Discussion started by: jackcracker
7 Replies

LEARN ABOUT DEBIAN

sqlobject-admin

SQLOBJECT-ADMIN(1)					      General Commands Manual						SQLOBJECT-ADMIN(1)

NAME

       sqlobject-admin - manage your database as defined with SQLObject classes

SYNOPSIS

       sqlobject-admin [options] command

DESCRIPTION

       The sqlobject-admin tool included with SQLObject allows you to manage your database as defined with SQLObject classes.

       Some of the features include creating tables, checking the status of the database, recording a version of a schema, and updating the
       database to match the version of the schema in your code.

COMMANDS

       The following commands are recognized:

       help
	   Show the help text.

       create
	   Find the tables and create them. Existing tables are simply skipped.

       sql
	   Show the SQL to create all the tables.

       drop
	   Drop tables. Missing tables are skipped.

       execute
	   Execute an arbitrary SQL expression.

       list
	   List out all the found classes.

       status
	   Show if tables are present in the database.

       record
	   Record historical information about the database status

       upgrade
	   Update the database to a new version (as created by record)

OPTIONS

       -c CONNECTION, --connection=CONNECTION
	   Connection string for the database .

       -f FILENAME, --config-file=FILENAME
	   Configuration file from which to get the connection to the database.

       -m MODULE, --module=MODULE
	   A module to look in for classes.

       -p PACKAGE, --package=PACKAGE
	   A package to look in.

       --class=CLASSMATCH
	   Restricting the found classes to the matching classes.

       --egg=EGG_SPEC
	   Egg description that should be loaded.

AUTHORS

	   This manual page was written by Carl Chenet <chaica@ohmytux.com>.

LICENSE

	   This package is licensed under the GNU Lesser General Public License. You can
	   find the full text of the LGPL in /usr/share/common-licenses/LGPL in your
	   Debian system.

								    06/03/2010							SQLOBJECT-ADMIN(1)
All times are GMT -4. The time now is 04:36 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy