This method requires SSH access. Nexcess clients on physical (non-cloud) servers must first enable SSH access and adjust their firewall settings in SiteWorx; Cloud accounts have SSH enabled by default.
- SSH into the server and enter the following command, but remove the brackets and replace the placeholder text within those brackets:
mysqldump -u [username] -p [database_name] > [dumpfilename.sql]
- Enter your password when prompted.
- To accelerate the upcoming transfer to the new server, execute the following command, but remove the brackets and replace the placeholder text within those brackets:
tar zcf [dumpfilename].tar.gz [dumpfilename].sql
- Transfer the compressed file to the new server using FTP.
- On the new server, decompress the file:
tar zxf [dumpfilename].tar.gz
- Launch the import process:
mysql -u [username] -p [database_name] < [dumpfilename.sql]
- Enter your password when prompted to begin the import.
- When you see the ready cursor, the import has finished.
Other resources
For the complete MySQL documentation, refer to the MySQL development website.
For 24-hour assistance any day of the year, contact our support team by email or through your Client Portal.