How can we help you?

Support Home File Management Databases How to export tables and import MySQL tables via CLI/SSH

How to export tables and import MySQL tables via CLI/SSH

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]

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