Newest KB Articles in MySQL

How to Order and Create a MySQL Database

Sun, 01 May 2022 04:21:57 GMT

Ordering Your MySQL Database Addon Service

Log into the DiscountASP.NET Control Panel
On the menu to your left under Account Management, click on the Order Addons link.
On your right, a list of addon features will appear. Scroll down to where it says MySQL Database and click on the Order MySQL: Click Here link.
The price is based on the amount of database disk space you want. Select the amount of disk space you want in the dropdown menu and then click the Add to my Account button.

Creating the Database

In most cases, your database service should be provisioned immediately. If it’s not provisioned after 24 hours, please open a support ticket to have us investigate the issue. After it has been provisioned, click on the MySQL Manager link under Database Management to create your database. It’s on the menu to your left in the Control Panel if you scroll down a bit.
On your right, give your database a name, create a username, set the disk space quota, and then click on the Create button.
Your newly created database will appear above the creation section as shown below.
Click on the Manage link to get your connection information. You’ll need this information when you go to install an application from our Web App Gallery or for use in your own applications. A sample connection string is also provided to you for your convenience.

Our Website Cloud Backup service can automate your database backups. You have full control over backup retention and schedule. DiscountASP.NET Website Cloud Backup - Everleap Website Cloud Backup

How to Restore a MySQL Database

Wed, 03 Apr 2019 20:32:39 GMT

You can restore a MySQL database using either MySQL Workbench or phpMyAdmin

MySQL Workbench

Before connecting MySQL Workbench to your database, you will need to download it.
https://dev.mysql.com/downloads/workbench/
https://support.discountasp.net/kb/a880/how-to-connect-to-mysql-using-mysql-workbench.aspx

Open Workbench, click Server --> Data Import:

Click "Import from Self-Contained File", find the location of the file on your local machine by clicking on the three dots. Next you will need to choose the target schema, click the dropdown menu and select the one matching the backup file name. Finally click "Start Import".

The Import will run and your database will have been restored.

phpMyAdmin

You can install phpMyAdmin through the Web App Gallery in the control panel.
https://support.discountasp.net/kb/a1630/installing-phpmyadmin.aspx

Click on the database on the left hand side, then click Import.

Click on "Choose File", locate the backup file usually a .sql file.
Click "Go" .

You should be met with an import successful screen and a restored database.

Please open a support ticket for help if you have any problems or errors.

How to Connect to MySQL using MySQL Workbench

Mon, 22 Nov 2010 23:01:34 GMT

Download MySQL Workbench and install it on your computer.

Open MySQL Workbench and click on the "+" sign next to MySQL Connections.

This will open the Setup New Connection window.
Enter your own Connection Name.
Enter the MySQL server name in the Hostname field.
Enter the MySQL db login in the Username field.

When the connection is made a window will open and you will enter the password for your database.

Our Website Cloud Backup service can automate your database backups. You have full control over backup retention and schedule. DiscountASP.NET Website Cloud Backup - Everleap Website Cloud Backup

Maximum number of database connections for MySQL users

Sat, 15 Nov 2008 01:06:19 GMT

In order to prevent excessive use by one site negatively impacting the performance of our MySQL servers, we limit the number of connections to the servers. The maximum connection limit is set to 25 connections per user. This limit is in place to maintain stability, it is not a guaranteed level of service.

If your application requires more connections, we recommend that you change your application to use persistent database connections or pooled database connections.

Our Website Cloud Backup service can automate your database backups. You have full control over backup retention and schedule. DiscountASP.NET Website Cloud Backup - Everleap Website Cloud Backup

InnoDB Table Support on MySQL Servers

Sat, 15 Nov 2008 01:05:19 GMT

MySQL databases created prior to November, 2010 (MySQL 4.1.18-std) are on our legacy MySQL servers which do not support the use of InnoDB tables. If you require the use of transact SQL, you should use our MS SQL database services.

Databases created after November, 2010 (MySQL 5.x) do support InnoDB tables.

Our Website Cloud Backup service can automate your database backups. You have full control over backup retention and schedule. DiscountASP.NET Website Cloud Backup - Everleap Website Cloud Backup

DiscountASP.NET General MySQL Backup Strategy

Sat, 15 Nov 2008 01:04:09 GMT

All MySQL Server databases are backed up on a nightly basis. We retain a rotating three day backup.

We recommend that you back up your MySQL database and keep a local copy whenever changes are made. In an emergency situation where you do not have a local backup, we can restore a specific MySQL database file for a $80 restoration fee.

Did you know that our Website Cloud Backup service can also back up your database? You have full control over backup retention and schedule. Automate your backups now with Website Cloud Backup.

Migrating data from MySQL to a SQL server

Sat, 15 Nov 2008 01:03:09 GMT

Microsoft offers a guide here.

Our Website Cloud Backup service can automate your database backups. You have full control over backup retention and schedule. DiscountASP.NET Website Cloud Backup - Everleap Website Cloud Backup

Migrating Your Current MySQL Database/Tables to a DiscountASP.NET MySQL Server

Sat, 15 Nov 2008 00:56:33 GMT

This article describes the tools and steps necessary to migrate an existing MySQL database or tables to a new MySQL database hosted with DiscountASP.NET.

Requirements

Login and password to access your DiscountASP.NET mysql database.
Login and password to access your current mysql database.
mysqldump.exe and mysql.exe command line utilities.

Obtaining and installing the MySQL utilities:

Download the latest release of mysql for windows from one of the mirrors listed here.
Unzip the install file to C:\ using your preferred unzip utility.
The mysqldump utility will then be stored in C:\mysql-X.X.X\bin\.

Convention for names used below:

Do not include the []’s for values that surround by [ or ]. These are just to illustrate where to plug in your specific information for those values. For easier reading the values that need to be replaced are colored in red.
Towards the end of some of the command line statements there are <’s or >’s by themselves. These are not typos. They tell the command line to redirect STDIN or STDOUT to the command in front of them.
Definitions of the values that need to be replaced with your personal information.
- [hostname]: The hostname or IP address of the MySQL server you want to connect to, e.g. the hostname of your DiscountASP.NET MySQL server will be something like "mysql01.discountasp.net".
- [user name]: The user name you use to access the MySQL server you are connecting to.
- [password]: The password you use to access the MySQL server you are connecting to.
- [database name]: The name of the database that your tables are stored in, e.g. Your DiscountASP.NET database name will be something like "MYSQLDB_1420".
- [table name]: The name of the table you want to dump or import.

Note: The values presented above for your "current" MySQL database will vary depending on where the database is hosted etc. If your current MySQL database is hosted with another company they should have provided you with the above information specific to your account with them.

Use the mysqldump utility to create a backup of your database:

Open up a windows command prompt.
- Click Start -> Run
- Enter "cmd" into the dialog box and click the "OK" button.
Go to the directory that the mysqldump utility is located.
- cd c:\mysql-X.X.X\bin
Create a dump of your current mysql database or table.
- Run the mysqldump.exe program using the following arguments.
- mysqldump.exe -e -n -u[user name] -p[password] -h[hostname] [database name] > c:\temp\[database name]-mysqldump.sql
If you supplied all the argument properly the program will connect to your current mysql server and create a dump of your whole database in the file you specified in your c:\temp directory.

Use the mysqldump utility to create a backup of a table in your database:

Open up a windows command prompt.
- Click Start -> Run
- Enter "cmd" into the dialog box and click the "OK" button.
Go to the directory that the mysqldump utility is located.
- cd c:\mysql-X.X.X\bin
Create a dump of your current mysql database or table.
- Run the mysqldump.exe program using the following arguments.
- mysqldump.exe -e -u[user name] -p[password] -h[hostname] [database name] [table name] > c:\temp\[database name]-mysqldump.sql
If you supplied all the argument properly the program will connect to your current MySQL server and create a dump of the table from your database in the file you specified in your c:\temp directory.

Use the mysql client utility to import your database/table(s) dump to a MySQL database:

Open up a windows command prompt.
- Click Start -> Run
- Enter "cmd" into the dialog box and click the "OK" button.
Go to the directory that the mysql client utility is located.
- cd c:\mysql-X.X.X\bin
Import the dump of your database or table.
- Run the mysql.exe program using the following arguments.
- mysql.exe -u[user name] -p[password] -h[hostname] [database name] < c:\temp\[database/table name] -mysqldump.sql

Did you know that our Website Cloud Backup service can also back up your database? You have full control over backup retention and schedule. Automate your backups now with Website Cloud Backup.

Connecting to MySQL

Sat, 15 Nov 2008 00:41:42 GMT

You can use any MySQL client to connect to our MySQL server to manage your database.

The GUI provided by MySQL is MySQL Workbench.

You may want to check out this popular application as well: phpMyAdmin

Our Website Cloud Backup service can automate your database backups. You have full control over backup retention and schedule. DiscountASP.NET Website Cloud Backup - Everleap Website Cloud Backup