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 REDHAT

mysqlaccess

MYSQLACCESS(1)						      General Commands Manual						    MYSQLACCESS(1)

NAME

       mysqlaccess
	- Create new users to mysql.

USAGE

       mysqlaccess [host [user [db]]] OPTIONS

SYNOPSIS

       mysqlaccess  [-?|--help]  [-v|--version]  [-p|--password=#]  [-h|--host=#] [-d|--db=#] [-U|--superuser=#] [-P|--spassword=#] [-H|--rhost=#]
       [--old_server] [-b|--brief] [-t|--table] [--relnotes] [--plan] [--howto] [--debug=N] [--copy] [--preview] [--commit] [--rollback]

DESCRIPTION

       -?|--help
	      display this helpscreen and exit

       -v|--version
	      print information on the program `mysqlaccess'

       -u|--user=#
	      username for logging in to the db

       -p|--password=#
	      validate password for user

       -h|--host=#
	      name or IP-number of the host

       -d|--db=#
	      name of the database

       -U|--superuser=#
	      connect as superuser

       -P|--spassword=#
	      password for superuser

       -H|--rhost=#
	      remote MySQL-server to connect to

       --old_server
	      connect to old MySQL-server (before v3.21) which does not yet know how to handle full where clauses.

       -b|--brief
	      single-line tabular report

       -t|--table
	      report in table-format

       --relnotes
	      print release-notes

       --plan print suggestions/ideas for future releases

       --howto
	      some examples of how to run `mysqlaccess'

       --debug=N
	      enter debuglevel N (0..3)

       --copy reload temporary grant-tables from original ones

       --preview
	      show differences in privileges after making changes in (temporary) grant-tables

       --commit
	      copy grant-rules from temporary tables to grant-tables (!don't forget to do an mysqladmin reload)

       --rollback
	      undo the last changes to the grant-tables.

NOTE

	   + At least the user and the db must be given (even with wildcards)
	   + If no host is given, `localhost' is assumed
	   + Wilcards (*,?,%,_) are allowed for host, user and db, but be sure
	     to escape them from your shell!! (ie type * or '*')

SEE ALSO

       isamchk (1), isamlog (1), mysqlaccess (1), mysqladmin (1), mysqlbug (1), mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql  (1),  perror
       (1), replace (1), safe_mysqld (1), which1 (1), zap (1),

AUTHOR

       Ver  1.0,  distribution 3.23.29a Michael (Monty) Widenius (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se).  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.mer-
       curmedia.com)

								 19 December 2000						    MYSQLACCESS(1)