웹 및 클래식 호스팅 도움말

Upgrading a MySQL or MSSQL Database

To upgrade your database version, you need to back up the existing database and then restore it to a new database. These steps can all be completed in the Hosting Control Panel.

This process may take a few hours due to the length of time databases take to backup, set up, and restore. Let's get started in your Hosting Control Panel.

1. Backing up a MySQL or MSSQL Database

You can back up MySQL and MSSQL databases from the Database section of the Hosting Control Panel. For more information, see Backing up and Restoring MySQL or MSSQL Databases.

This creates and stores your backups in a folder in your hosting account, _db_backups.

Note: If you encounter an error the first time you attempt to create a backup, you should make sure the directory _db_backups exists. This directory doesn't display in the File Manager — files with an underscore are hidden. However, using an FTP client you can select the option to show hidden files and directories.

When you create a backup file using the Hosting Control Panel, our system names the file using the name of the existing database. While you cannot define a filename during the backup process, you can rename a file once the process is complete.

You can check on the status of your backup from the Manage Database screen.

2. Create a New Database

Create a new database using the upgraded version. For more information, see Create MySQL or MS SQL databases.

It takes up to 1 hour to create a database.

Once the database is created, you can click Actions, and then Details to find more information, such as its host name.

3. Restoring a MySQL or MSSQL Database

You can now restore your old database's backup into your new database. For more information, see Backing up and Restoring MySQL or MSSQL Databases.

Note: If you encounter errors while restoring a MySQL database, verify the Create Database line is removed or commented out from the database dump (backup file). Normally you can find this code about 10 to 15 lines down from the beginning. It can be removed or commented out by using a text editor of your choice (Notepad++ for example).

To begin using the new database, you need to update your website's connection strings, changing your Database Name, Password, and Host Name. You can find both your Database Name and Host Name on the Host Name page. For more information, see Viewing Your Database Details with Shared Hosting Accounts.


이 글이 도움되었나요?
피드백을 보내주셔서 감사합니다. 고객 서비스 담당자에게 문의하시려면 지원 전화 번호 또는 위의 채팅 옵션을 이용하시기 바랍니다.
도와드릴 수 있어 기쁩니다! 더 도와 드릴 것이 있나요?
그것 유감스럽습니다. 혼동이 되었던 사항 또는 솔루션이 고객님의 문제를 해결하지 못했던 원인을 알려주세요.