Newest KB Articles in Databases & SQL

How to Backup your MySQL Database Using phpMyAdmin

Fri, 04 Mar 2016 15:43:53 GMT

Here are our instructions for backing up your MySQL database using phpMyAdmin.

1) Login to phpMyAdmin. Make sure to select the correct MySQL server (see image below).

2) Click on the database you would like to backup from the left sidebar. In the following example we plan on backing up the database named "mysql". Here you should select your specific database name and not "mysql".

3) Click on the Export tab.

4) Choose the Quick Export Method, leave the Format as SQL and then click on the Go button.

5) The export file of your database will be downloaded to your local computer and will be saved in your browser's default downloads folder.

Microsoft SQL 2000 Server

Sun, 26 Apr 2015 03:11:13 GMT

All SQL administration is performed via Microsoft's isqlw utility (SQL Server Query Analyzer). You must connect to our SQL Server via a TCP/IP sockets connection using TCP port 1433.

To configure your machine for TCP/IP sockets, visit: http://support.microsoft.com/support/sql/content/connect/ClientIP.asp

Once connected using isqlw, you may setup and administer your database.

We will also be happy to restore an existing SQL Server backup database to our server for you at no charge.

ADD NEW SERVER ALIAS VIA NETWORK LIBRARY CONFIGURATION:

Click on Start, Programs, Microsoft SQL Server, Client Network Utility.
Add a server alias as follows: On the Alias tab, click on the Add button. In the Server alias field, enter something like "AtlantisSQL2000". Select "TCP/IP" as the Network library for this connection. Enter "sql2000.atlantisnet.com" as the Computer name. Check the "Dynamically determine port" check box. Click on "OK".
Close the SQL Server Client Network Utility by clicking on the "OK" button.
Click on Start, Programs, Microsoft SQL Server, Query Analyzer.
On the Connect to SQL Server window, click on the button that has the 3 small dots "..." in it which is directly to the right of SQL Server drop down box.
Select the alias you created in step #2 above (AtlantisSQL2000). Click on "OK".
Under Connect using, select "SQL Server authentication". Enter your Login Name and Password.
Click on "OK".
You should now connect to the server and the DB drop down box should contain your database name

CONNECT VIA ENTERPRISE MANAGER:
(Although we do not support it, some customers have been able to connect to our SQL Server using Microsoft's Enterprise Manager.)

Click on Start, Programs, Microsoft SQL Server, Enterprise Manager.
Select a SQL Server Group.
On the drop down menu, click on "Action".
Select "New SQL Server Registration...". The "Register SQL Server Wizard" should appear.
Click on "Next >".
Under Available servers, you should see the server alias you created using the "SQL Server Client Network Utility" from above (AtlantisSQL2000).
Click on the server in #6 above, and then press the "Add >" button.
Click on "Next >".
Select "The SQL Server login information that was assigned to me by the system administrator. (SQL Server authentication).
Click on "Next >".
Select "Login automatically using my SQL Server account information.".
Enter your Login Name.
Enter your Password.
Click on "Next >".
Select the SQL Server Group.
Click on "Next >".
Click on "Finish".
See if you get a status of "- Registered successfully".
Click on "Close".
Try to connect using this new connection.

DSN-Less Database Connection Examples

Fri, 29 Apr 2011 06:32:14 GMT

The follwoing are DSN-Less connections you may use to access a database without using an ODBC connection. Parameters in bold should be replaced with your information.

ColdFusion 5.0 & MySQL:

<cfquery name="MyQueryName" dbtype="dynamic" connectstring= "Driver={MySQL ODBC 3.51 Driver}; SERVER=mysql.atlantisnet.com; UID=MySqlUser; PWD=MySqlPassword; DATABASE=MySqlDatabase; network=dbmssocn">

ColdFusion 5.0 & Microsoft SQL Server 2000:

<cfquery name="MyQueryName" dbtype="dynamic" connectstring= "Driver={SQL Server}; Server=sql2000.atlantisnet.com; Database=MsSqlDatabase; Uid=MsSqlUser; Pwd=MsSqlPassword;">