topic Lock and move specefic database in Integration and Testing https://community.developer.cybersource.com/t5/Integration-and-Testing/Lock-and-move-specefic-database/m-p/70314#M43160 <P class="_1qeIAgB0cPwnLhDF9XSiJM">Hi</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">I have a MySQL server on CentOS running multiple databases. The mysql data directory is the default directory of /var/lib/mysql in that directory the databases are symlinked to other locations (I have a LVM for each db, mounted on specefic folders).</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">I need to move some (not all) of the databases to another location, for archive pupose, running on cheaper storage. I therefore would like to flush and lock SPECIFIC databases, in order to be able to copy/move the database files to a new location, and change the symlink.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">I don't want to lock all databases as I'm running production on the MySQL server, and obviously I don't wan't to stop the mysql service either. Is it possible to 'lock' / Stop specefic databases? Please advise.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">/Steffen</P> Thu, 09 Jan 2020 17:51:11 GMT RowanGale 2020-01-09T17:51:11Z Lock and move specefic database https://community.developer.cybersource.com/t5/Integration-and-Testing/Lock-and-move-specefic-database/m-p/70314#M43160 <P class="_1qeIAgB0cPwnLhDF9XSiJM">Hi</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">I have a MySQL server on CentOS running multiple databases. The mysql data directory is the default directory of /var/lib/mysql in that directory the databases are symlinked to other locations (I have a LVM for each db, mounted on specefic folders).</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">I need to move some (not all) of the databases to another location, for archive pupose, running on cheaper storage. I therefore would like to flush and lock SPECIFIC databases, in order to be able to copy/move the database files to a new location, and change the symlink.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">I don't want to lock all databases as I'm running production on the MySQL server, and obviously I don't wan't to stop the mysql service either. Is it possible to 'lock' / Stop specefic databases? Please advise.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">/Steffen</P> Thu, 09 Jan 2020 17:51:11 GMT https://community.developer.cybersource.com/t5/Integration-and-Testing/Lock-and-move-specefic-database/m-p/70314#M43160 RowanGale 2020-01-09T17:51:11Z