Tag Info

New answers tagged

0

Found it, using this flag: --skip-lock-tables -f The schema still can't be exported correctly, except by using phpmyadmin


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.



Top 50 recent answers are included