Mysql – mount and remount a thesql database

mountMySQL

Is there the equivalent of a device unmount / mount for a mysql database?

My server has around 15 databases, of which maybe 10 are rarely used, and only on demand if I have to do some fixes on apps I have been working.

So the idea is to unmount the unused databases until I need them. This should free some resources?

I know I can dump them into a file and reload them, but that has a 'cumbersome' feeling to me and I was wondering if such a mount/unmount exists. thanks

Best Answer

Nope. If they're truly not being used, overhead resource utilization is very minimal, so I wouldn't worry about it if I were you.

Related Solutions

MySQL Configuration – How to Bind MySQL Server to Multiple IP Addresses

No, there isn't (I just checked 1 hour ago). You can comment the bind-address in my.cnf:

Note: « 1 hour ago » is now more than 10 years ago.

#skip-networking
#bind-address                   = 127.0.0.1

If you want only 2 IPs, you will then have to use a firewall.

For MySql version 8.0.13 and above, you can specify a list of comma-separated IP addresses.

bind-address = 10.0.0.1,10.0.1.1,10.0.2.1

Relevant MySql documentation.

Remember to restart your MySQL instance after changing the config file.

Mysql – How to rename a MySQL database

From this blog post by Ilan Hazan:

In MySQL there is no support for database renaming. In order to rename a MySQL database you can do one of the following:

Create new database and rename all tables in the old database to be in the new database:

 CREATE database new_db_name;
 RENAME TABLE db_name.table1 TO new_db_name.table1, db_name.table2 TO new_db_name.table2;
 DROP database db_name;

In Linux shell, use mysqldump to back up the old database, then restore the dumped database under a new name using the MySQL utility. Finally, use the drop database command to drop the old database. This option can perform badly for large database.
```
 mysqldump -uxxxx -pxxxx -h xxxx db_name > db_name_dump.sql
 mysql -uxxxx -pxxxx -h xxxx -e "CREATE DATABASE new_db_name"
 mysql -uxxxx -pxxxx -h xxxx new_db_name < db_name_dump.sql
 mysql -uxxxx -pxxxx -h xxxx -e "DROP DATABASE db_name"
```

Write a simple Linux script (my favorite solution)

 #!/bin/bash

 dbuser=xxxx
 dbpass=xxxx
 olddb=xxxx
 newdb=xxxx

 mysqlconn="mysql -u $dbuser -p$dbpass -h localhost"

 $mysqlconn -e "CREATE DATABASE $newdb"
 params=$($mysqlconn -N -e "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE table_schema='$olddb'")

 for name in $params; do
       $mysqlconn -e "RENAME TABLE $olddb.$name to $newdb.$name";
       echo "Renamed $olddb.$name to $newdb.$name";
 done;

 #$mysqlconn -e "DROP DATABASE $olddb"

If all your tables are MyISAM, you can rename the old database folder name:
1. Shut down the MySQL server,
2. Rename the database folder name to the new name,
3. Start the MySQL server.

Best Answer

Related Solutions

MySQL Configuration – How to Bind MySQL Server to Multiple IP Addresses

Mysql – How to rename a MySQL database

Related Topic