Tag Info

New answers tagged

0

There's a response for this here: MySQL - mysqldump. preserve update_time and modify_time As @RolandoMySQLDBA said: There is no way to reload the INFORMATION_SCHEMA manually. All the tables are dynamic entities.


0

Based on the error message given, there is a troublemaking table that has a trigger. You may have to perform some creative dumps Dump Triggers, Stored Procedures, Table Structures and Data into Separate Files DUMPDB=mydb MYSQL_USER=root MYSQL_PASS=rootpassword MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}" mysqldump -${MYSQL_CONN} -d -t --skip-routines ...


0

It will be stored in the path or folder from where you run the mysql command suppose you run the command from root then it will be stored in the root directory you can see my backup file skillmappingcleardata.sql in the root directory because I run the mysql command from there


1

To speed up load time of InnoDB you can tune some variables. innodb_buffer_pool_size. Kind of the most important one. Allocate as much as your system allows, but make sure MySQL doesn't use swap. 4GB RAM is desperately little, try buffer pool around 2G. If you can install more memory that will be more helpful than anything below. innodb_log_file_size. The ...


0

The folder /var/tmp/mysql.k6NKGk/ may have been removed by systemd-tmpfiles (or tmpwatch) if there were no activity since a while. A service restart is a way to work-around the issue. Please refer to http://stackoverflow.com/questions/11997012/mysql-cant-create-write-to-file-tmp-sql-3c6-0-myi-errcode-2-what-does for details or other possible sources like ...


0

If you are ready to first create a temporary database from the old dump you could use a different tool, which can create dumps that are nice to compare: It is called pydumpy https://code.google.com/p/pydumpy/ written by https://github.com/z1lv1n4s (github mirror: https://github.com/miebach/pydumpy)


0

this way is faster because Server does not need to perform fsync() multiple times during data import. fsync is the operation of submitting data into disk Extended insert enables sequential write to disk which means disk does not need to seek for a locations for every row. If the table has Auto_Increment values, Server can spare adequate values for the ...



Top 50 recent answers are included