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.
mysqldump -u [username] -p [database_name] > [dumpfilename.sql]
tar zcf [dumpfilename].tar.gz [dumpfilename].sql
tar zxf [dumpfilename].tar.gz
mysql -u [username] -p [database_name] < [dumpfilename.sql]
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.
Our award-winning customer care team is here for you.
Contact Support