Mysqldump certain tables Post: 302743889

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Mysqldump certain tables Post 302743889 by Corona688 on Thursday 13th of December 2012 02:10:58 PM

12-13-2012

Registered User

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:

Corona688

View Public Profile for Corona688

Visit Corona688's homepage!

Find all posts by Corona688

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:...

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 ...

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

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...

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...

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...

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...

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...

LEARN ABOUT DEBIAN

freebsd-yyfix

YYFIX(1)						    BSD General Commands Manual 						  YYFIX(1)

NAME

     yyfix -- extract tables from y.tab.c

SYNOPSIS

     yyfix file [tables]

DESCRIPTION

     Programs have historically used a script (often named ``:yyfix'') to extract tables from the yacc(1) generated file y.tab.c.  As the names of
     the tables generated by the current version of yacc(1) are different from those of historical versions of yacc(1), the shell script yyfix is
     provided to simplify the transition.

     The first (and required) argument to yyfix is the name of the file where the extracted tables should be stored.

     If further command line arguments are specified, they are taken as the list of tables to be extracted.  Otherwise, yyfix attempts to deter-
     mine if the y.tab.c file is from an old or new yacc(1), and extracts the appropriate tables.

     The tables ``yyexca'', ``yyact'', ``yypact'', ``yypgo'', ``yyr1'', ``yyr2'', ``yychk'', and ``yydef'' are extracted from historical versions
     of yacc(1).

     The tables ``yylhs'', ``yylen'', ``yydefred'', ``yydgoto'', ``yysindex'', ``yyrindex'', ``yygindex'', ``yytable'', ``yyname'', ``yyrule'',
     and ``yycheck'', are extracted from the current version of yacc(1).

FILES

     y.tab.c  File from which tables are extracted.

SEE ALSO

     yacc(1)

HISTORY

     The yyfix command first appeared in 4.4BSD.

BSD
								  March 23, 1993							       BSD