Back up a database: MySQL Command Line Client

Procedure

1. Obtain the database information.
   1. Log on to the Web Hosting management console.
   2. Find your Web Hosting instance and click Manage in the Actions column.
   3. In the left-side navigation pane, click Database Information.
   4. On the Database Information page, view your database information.
      Note If you forget the database password, you can reset it. For more information, see Reset the database password of a Web Hosting instance.

      

2. On your local host, open a command-line window.

   1. On the desktop of your local host, press the Win and R keys at the same time.

   2. In the Run dialog box, enter cmd in the Open (O) text box.

3. Run the following command to back up the database of your Web Hosting instance.

   mysqldump -h <database_address> -u <database_username> -p --default-character-set=utf8 <database_name> > <path_to_backup_file>

   1. Replace the placeholders with their corresponding values. For example, replace <database_address> with your database address and <path_to_backup_file> with the desired local path for the backup file.

   2. Enter the database password when prompted to complete the backup.

   Important

   If you are using MySQL version 8 on your local host, you must also add the --column-statistics=0 parameter to the command.