Posted on May 20, 2017 at 6:50 pm
You can restore a previously copied\moved MySQL datadir on a new server:
1) Stop the MySQL service
service mysql stop |
2) Rename the actual MySQL datadir to something different:
mv /var/lib/mysql /var/lib/mysql_original |
3) Copy the MySQL datadir to restore in the MySQL datadir path:
cp -R /backups/mysql /var/lib |
4) Set mysql:mysql permissions to the new /var/lib/mysql directory:
chown -R mysql:mysql /var/lib/mysql |
5) Start the MySQL service
service mysql start |
6) If all went well, remove /var/lib/mysql_original:
rm -rf /var/lib/mysql_original |
Other Posts
- Detect VMWare Virtual Machine
- Detect Microsoft Virtual PC Virtual Machine
- Fix MariaDB 10.5 "Can't create test file" errors
- Use MariaDB and MySQL without Password (MySQL Backup)
- Check if a Trademark is already registered
- Make name server address permanent in /etc/resolv.conf
- InnoSetup error the servicemanager is not available
- InnoSetup disable DesktopIcon via command-line
Updated Posts
- Delphi 10 Berlin System.Hash MD5 SHA1 SHA2 Hash
- Use cURL to check for SSL certificate issues:
- How to test Socks5 proxy with cURL
- How to use variables in a sed command
- Best Socks5 Servers for Linux Debian
- Error NO_PUBKEY in Google Cloud Debian Packages Update
- How to Run a Command with Time Limit in Bash Linux
- MySQL InnoDB log sequence number is in the future