Tag Info

New answers tagged

0

I think I found the problem. Apparently the nohup command ended at the | symbol, so when the session expired the second part of the command stopped with the session. To get round this I ran: nohup sh -c 'mysqldump -hxxx -P3306 -uxxx -pxxx --dump-slave --databases a b c d --ignore-table=a.xxx -F | mysql -h127.0.0.1 -P3306 -uxxx -pxxx' & I checked it ...


0

Despite the fact that MySQLRockstar's answer is undoubtedly correct I haven't succeed with the sed script. I was my first time doing this, so I needed some more time to experiment and I was in a hurry. I've had some experience with Perl so I succesfully used this approach ...


1

Take the difference between two 'CREATE DATABASE' using sed operation eg sed -n '/^-- Current Database: `dbname`/,/^-- Current Database: `/p' alldatabases.sql > output.sql http://stackoverflow.com/questions/2342356/import-single-database-from-all-databases-dump ...


1

Please look back at my post again. DATABASES_TO_EXCLUDE not supposed to be comma separated supposed to be space separated EXCLUSION_LIST supposed to be a comma-separated list of single-quote enclosed database names this is for the sake of forming the SQL to extract names from information_schema.schemata If you made DATABASES_TO_EXCLUDE="db1,db2,db3", ...


0

Check out mydumper. It's a lot quicker than mysqldump: http://www.percona.com/blog/2014/03/10/new-mydumper-0-6-1-release-offers-several-performance-and-usability-features/ You can download from here: https://launchpad.net/mydumper


1

You have to use the mysql client to reload mysql -u root -p -Ddatabasename < /home/databasename_bkup.sql Another way to reload would be mysql -u root -p -Ddatabasename then from the MySQL prompt, do this mysql> source /home/databasename_bkup.sql If you would like the mysqldump to drop and recreate the database for you, create the dump like ...


0

LE: giving the tips below I may estimate that your dump could take 20 minutes (and longer). But with these tips and high performance CPUs and lot of memory the time may be smaller. You didn't provide enough informations regarding the specific of your data. Are there a single database or multiple? Is all data InnoDB or there are MyISAM tables around? If ...


0

You have to go with Incremental Backup. First you must have take full backup of all the database. Then you can set the incremental backup with regular schedule.


0

I will first answer your question, what you ask, but that is probably not what you want. If you want to dump a single table using mysqldump, you can just put its name after the database name. So, if you execute: mysqldump [connection parameters here] a_database a_table > $DEST/a_table.sql It will backup only the a_table table from the database ...



Top 50 recent answers are included