Tag Info

New answers tagged

0

The easiest way would be to change the global setting for long_query_time to a ridiculously high number, run the mysqldump, and change long_query_time back to its original value. Perhaps something like this MYSQL_USER=backupuser MYSQL_PASS=backupuserpassword MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}" # # Record the long_query_time value # SQL="SELECT ...


0

Sounds like a bug from a year ago (mysqldump creates useless metadata locks) This bug was fixed for MySQL 5.5 and I see you are using MySQL 5.6.21 SUGGESTIONS Don't use --lock-tables=false with --single-transaction because MySQL Documentation says "The --single-transaction option and the --lock-tables option are mutually exclusive because LOCK TABLES ...


0

You can also use Phpmyadmin to do this. Create a query to select the fields you want, then choose the "export" function at the bottom of the page (this exports your query results, not the whole table), and choose the "Custom" option. You can then choose SQL as your format - if you want you can then create a series of UPDATE queries rather than INSERTS. Can ...


1

Your issue may involve the configuration settings for either OS or MySQL HISTORICAL EXAMPLES Years ago when I worked at a website firm, I used --skip-extended-insert to load a DB Server that had 2GB RAM. That made a whole world of sense to me because the server I dumped it from had 64GB RAM and the client wanted the data on a smaller machine. At my ...


0

Mock tables were how mysqldump were loaded in older versions of MySQL a long time ago Issue like this existed load of mysqldump script may fail with error 1215 if dest already has tables Foreign keys: mysqldump should respect foreign keys See that last line 2014-11-03 18:01:29 22485 [Note] NDB FK: Created mock table 'NDB$FKM_20_0_aclRole' referenced ...


0

There could be following two ways of doing the same. First is you take unloads from source using following command select * from table_name into outfile 'file_path' FIELDS TERMINATED BY ',' enclosed by '"' ; Then on target you can do following load data local infile 'file_path' into table table_name(Column_list_comma_seprated) FIELDS ...


2

You might try mydumper which is multi-threaded whereas mysqldump is single-threaded. Percona have also improved the less locking feature in the most recent version. The excellent Mysql Performance Blog has this useful article.


0

problem is you backed up your databases using mydumper with -m or --no-schemas option, so the database create commands were not backed up. So on restore you are not able to re-create the database tables prior to myloader reimporting data.


1

There are several methods you can use such as mysqldump folder copy enterprise backup for mysqldump use following command: mysqldump -uuser -ppassword --database your_db_name --routines --triggers --events --lock-all-tables >outputfile.sql and use following command at destination: mysql -uroot -ppassword<outputfile.sql. You can also use ...


0

Use grep to exclude databases you don't want: candidates=$(echo "show databases" | mysql | grep -Ev "^(Database|mysql|performance_schema|information_schema)$") mysqldump --databases $candidates From looking at http://stackoverflow.com/questions/19354870/bash-command-line-and-input-limit it seems like you'll be able to handle long lines. Otherwise you can ...



Top 50 recent answers are included