Import / Export MySQL Database

How to import or export MySQL database with command line. This is also useful when working with big databases. Export database info file mysqldump DATABASE-NAME > FILE-NAME.sql Export database into compressed file to save space mysqldump DATABASE-NAME | gzip FILE-NAME.sql.gz Export database into compressed file with date name to save space mysqldump DATABASE-NAME | gzip […]

Read More

Remote MySQL with SOCAT socket

How to make a remote MySQL server with socket by using SOCAT. Remote MySQL advantages – move MySQL CPU usage from local CWP web server – move MySQL disk IO operations from disk – move MySQL disk space usage to other server – improve performances by moving MySQL to SSD multi-core powered server … on […]

Read More

How to reset MySQL root password

Instructions for reseting MySQL root password. MySQL root password on the CWP servers can be reset by using cwp scripts, usage: sh /scripts/mysql_pwd_reset or /scripts/mysql_pwd_reset This script will stop MySQL run it in a safe mode, set RANDOM password and then restart the MySQL in normal mode with a new password.

Read More

How to change MySQL Location

How to Safely Change Location of the MySQL Data Directory (partition/disk) Most Used Cases are: – Useful for migration of the MySQL to SSD Disk and to get the best performances. – Useful if you are out of the disk space on your partition or a disk. In this tutorial we will move MySQL to […]

Read More

How to upgrade MySQL Server

How Can I upgrade MySQL server? You can upgrade the MySQL server by using any official tutorial on the internet, its suggested to make a backup of all databases before doing an upgrade. Our Managed support will also include MySQL upgrade so if you need assistance you can grab it. MySQL Upgrade Instructions (You can […]

Read More