Mysqldump certain tables Post: 302742667

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Mysqldump certain tables Post 302742667 by timgolding on Tuesday 11th of December 2012 12:17:53 PM

12-11-2012

Registered User

Mysqldump certain tables

Hi,

I have to upload part of my database periodically when i make changes to product data etc. However I only want to upload certain tables. We suffer from bandwidth chock here, so i want to write a couple of separate scripts that upload parts of the database that changed. The database is large and it is split into to sections Feed driven data, which is 27MB and Manual driven data which is 8MB. To reduce the upload time i decided to write a script that uploads the feed stuff (to be run once a month) and another script to upload the manual stuff (could be run daily) to reduce the upload time. I therefore decided i would have a script to copy the sections of the database in to a smaller database on the development server. Then a script on the live server to download the smaller database from the development server. I am however having troubles creating the first script.

Here is what i have.

Code:

mysqladmin -u root --password='mypassword' --socket=/tmp/mysql.sock drop DATABASE_TEMP
mysqladmin -u root --password='mypassword' --socket=/tmp/mysql.sock create DATABASE_TEMP


for table in TABLE TABLE2 TABLE3 TABLE4 TABLE5
do
echo "copying table"
mysqldump -u root --password='mypassword' DATABASE $table | mysql --socket=/tmp/mysql.sock -u root --password='mypassword' DATABASE_TEMP
done

Am i on the right track? Should i be doing this with a single command somehow? Will this work? I am reluctant to test it without some advice because i don't want to much anything up.

timgolding

View Public Profile for timgolding

Find all posts by 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:...

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 OPENSOLARIS

mysqld_multi

mysqld_multi(1) 						  MySQL database						   mysqld_multi(1)

NAME

       mysqld_multi  - is meant for managing several mysqld processes running in different UNIX sockets and TCP/IP ports.

USAGE

       mysqld_multi [OPTIONS] {start|stop|report} [GNR,GNR,GNR...]

SYNOPSIS

       mysqld_multi  [--config-file=...]   [--example]	[--help]  [--log=...]	[--mysqladmin=...]   [--mysqld=...]   [--no-log]  [--password=...]
       [--tcp-ip] [--user=...]	[--version]

DESCRIPTION

       mysqld_multi

       --config-file=...
	      Alternative config file. NOTE: This will not affect this program's own options (group [mysqld_multi]), but  only	groups	[mysqld#].
	      Without this option everything will be searched from the ordinary my.cnf file.

       --example
	      Give an example of a config file.

       --help Print this help and exit.

       --log=...
	      Log file. Full path to and the name for the log file. NOTE: If the file exists, everything will be appended.

       --mysqladmin=...
	      mysqladmin binary to be used for a server shutdown.

       --mysqld=...
	      mysqld  binary  to be used. Note that you can give mysqld_safe to this option also. The options are passed to mysqld. Just make sure
	      you have mysqld in your environment variable PATH or fix mysqld_safe.

       --no-log
	      Print to stdout instead of the log file. By default the log file is turned on.

       --password=...
	      Password for user for mysqladmin.

       --tcp-ip
	      Connect to the MySQL server(s) via the TCP/IP port instead of the UNIX socket. This affects stopping and reporting. If a socket file
	      is  missing,  the  server  may still be running, but can be accessed only via the TCP/IP port. By default connecting is done via the
	      UNIX socket.

       --user=...
	      MySQL user for mysqladmin.

       --version
	      Print the version number and exit.

NOTE

       Please see the mysql manual for more detailed information on this.

SEE ALSO

       isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1),  mysqld_safe(1),  mysqldump(1),  mysql_fix_privilege_tables(1),
       mysqlshow(1), mysql_zap(1), perror(1), replace(1)

       For  more information please refer to the MySQL reference manual, which may already be installed locally and which is also available online
       at http://www.mysql.com/doc/en/

BUGS

       Please refer to http://bugs.mysql.com/ to report bugs.

AUTHOR

       Ver 1.0, distribution 4.0.24 Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/).  This  software  comes  with	no
       warranty.   Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercur-
       media.com)

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +--------------------+------------------------------------+
       |  ATTRIBUTE TYPE    |	       ATTRIBUTE VALUE		 |
       +--------------------+------------------------------------+
       |Availability	    | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt |
       +--------------------+------------------------------------+
       |Interface Stability | External				 |
       +--------------------+------------------------------------+
NOTES

       Source for mysql is available on http://opensolaris.org.

MySQL 4.0							 19 December 2000						   mysqld_multi(1)