14 Mar 10 How do I restore a MySQL database?
Restoring your Database via phpMyAdmin
Restoring your database is as easy as backing it up. If you would like to rewrite the backup over an existing database, follow the process listed below:
1. Connect to your database using phpMyAdmin. Click here to read how >>
2. Click on the database name in the database list on the left, click all the check boxes next to the table names and select Drop in the With selected: drop down box.
This will drop all existing tables in the database. Then head over to the top menu bar and click on SQL. This will bring up a window where you can either type in SQL commands, or upload your SQL file.
Restoring your MySQL Database from within the Control Panel
You can restore a MYSQL database from within the Gossimer Hosting Control Panel. Please follow the steps explained below:
1. Login to your Control Panel and search for the domain name for which you have purchased this hosting package. Click here to know how >>
2. In the search results view, click on the domain name. This will take you to the order details view.
3. Click on Manage Web Hosting Service in the lower toolbar.
4. In the Website Management interface pop-up that follows, go to Manage Website -> Database Manager -> Backup/Restore Database.
5. Select the radio button Restore Database.
6. Select the database from the dropdown menu next to Select Database.
7. Specify the exact location and filename of the backup file in the File to Restore field. You can select the backup which was saved on the server in a specified directory or you can upload a .sql backup file onto a directory within your website and select it from the list.
8. Click on Submit to restore the database.
Tags: Backup File, Check Boxes, Database Manager, Database Name, Details View, Dropdown Menu, Exact Location, Gossimer, Gt 2, Manage Web Hosting Service, Management Interface, Manager Gt, Mysql Database, Phpmyadmin, Radio Button, Sql Commands, Table Names, Top Menu Bar, View 3, Web Hosting Service, Website Management
22 Feb 10 How do I make a backup copy of a MySQL database?
Taking a Backup of your MySQL Database via phpMyAdmin
You can backup your database using phpMyAdmin in just a few mouse clicks. The process for the same is outlined below:
1. Connect to your database using phpMyAdmin. Click here to read how >>
2. Click the database name in the list on the left of the screen. Once you get to your database details, you should get a menu header for your database which looks like so:
3. Click on Export. This will get you to a screen with the following options:
4. From here it’s just a matter of clicking the right options and the Go button to get your database dump. To save the backup file on your computer, click on Save as file option and the corresponding compression option to get the backup to download to your system.
Taking a Backup of your MySQL Database from within the Control Panel
Gossimer Hosting Control Panel provides an easy method to create a backup copy of your MySQL database. Process mentioned below explains how to create a backup copy:
1. Login to your Control Panel and search for the domain name for which you have purchased this hosting package. Click here to know how >>
2. In the search results view, click on the domain name. This will take you to the order details view.
3. Click on Manage Web Hosting Service in the lower toolbar.
4. In the Website Management interface pop-up that follows, go to Manage Website -> Database Manager -> Backup/Restore Database.
5. Select the radio button Backup Database.
6. You can take a backup of only the database schema, database schema and tables or a back up of selected tables only.
- Select a Database from the drop-down menu next to Select Database. Select the check box Dump Schema only (No Data) if you wish to take a back up of just a database’s schema. Leave the checkbox unchecked if you need a backup of the entire database. You may a take a back of the all the tables or only selected tables. Select the radio button Backup Selected Tables and select the desired tables from the list or select the radio button Backup All Tables.
- Click on Browse next to Backup Directory field, select the desired directory where you want to save the backup and click Submit to save the backup.
In case you are taking a backup of only database scheme or database scheme and all tables, the backup will be stored as database_name.sql, while in case of backup of only selected tables, the backup will be stored as database_name.table_name.sql.
Tags: Backup Copy, Backup Database, Backup File, Compression Option, Database Details, Database Manager, Database Name, Database Schema, Details View, Drop Down Menu, Gt 2, Manage Web Hosting Service, Management Interface, Manager Gt, Menu Header, Mysql Database, Phpmyadmin, Radio Button, View 3, Web Hosting Service, Website Management
20 Feb 10 How do I restore a MS SQL database?
Gossimer Windows Hosting Control Panel allows you to restore an existing database from a backup copy as explained below:
1. Login to your Control Panel, search for the domain name for which you have purchased the Web Hosting package and go to the Order Details view. Click here to know how >>
2. Click Manage Web Hosting Service in the lower toolbar.
3. In the Website Management interface pop-up that follows, go to Manage Website -> Database Manager -> List Databases.
4. Click the database you wish to manage.
5. Click Restore Database. Select the Database Username from the drop-down menu next to Database Username. This user will own all tables, views and stored procedures in the restored database, if the current owner of the backup file does not exist on Gossimer SQL server.
Select the backup file from the drop-down menu next to File to be Restored. You can select the backup which was saved on the server in the sqlDatabaseBackup directory or you can upload a .bak backup file onto the sqlDatabaseBackup directory and select it from the list.
6. Click Submit to restore the database.
Reference: Uploading content to your Website using FTP >>
Effective from 15 November 2007, all databases (MS SQL) purchased on Gossimer Windows Hosting Servers will be created on MS SQL 2005 Servers. There exists a backward compatibility issue with SQL 2005 in restoring a database to SQL 2000 (or an earlier version of MS SQL). This is on account of Microsoft not providing backward compatibility with earlier versions of MS SQL due to different internal file structures.
An alternate method would be usage of MS SQL Server Database Publishing Wizard. MS SQL Server Database Publishing Wizard enables the deployment of SQL Server databases either into 2000 or 2005 hosting environment. It generates a single SQL script file which can be used to recreate a database (both schema and data) for SQL 2000 and SQL 2005 versions. Click here to download this tool >>
There is no issue restoring SQL 2000 (or any earlier version) database to SQL 2005 version.
Tags: Alternate Method, Backup File, Backward Compatibility, Compatibility Issue, current owner, Database Manager, Database Publishing, Database Reference, Details View, File Structures, Gt 2, Hosting Servers, Manage Web Hosting Service, Management Interface, Microsoft, Microsoft Windows, Ms Sql Database, Ms Sql Server, SQL, Sql 2000, Sql Databases, Sql Script, Sql Server Database, Sql Server Databases, Web Hosting, Web Hosting Service, Website Management
Gossimer in the News
- Gossimer Puts Indian Domain Extensions Up for Sale February 21, 2010Gossimer, the fastest growing domain name registration and web hosting company has announced a sale on Indian domain extensions. During the promotion period, domains ending with .in will be offered at discounted price. [PR.com] […]
- Gossimer Unveils a New & Improved Payment System February 14, 2010The Melbourne-based (Florida) web hosting and domain name registration company Gossimer has announced the inclusion of three more payment options in its system. From today the customers and the web hosting resellers can use AlertPay, WebMoney, and Liberty Reserve to pay for the domain registration as well as web hosting services. Gossimer already offered Pay […]
- Gossimer Has Opened Its Treasure Chest for Webhost Resellers January 16, 2010Gossimer, the fast growing domain name registration and web hosting company has yet again opened its door of their reseller program. This program offers a comprehensive web hosting product portfolio for resellers and resellers of Gossimer’s resellers. [PR.com] […]
- Gossimer Invites Customers to Try Digital Certificates for Free January 2, 2010Gossimer, the fastest growing domain name registration and web hosting company is offering 21 days free trial on digital certificates. This trail will allow webmasters to understand the role Https plays in building visitors’ confidence in their website. [PR.com] […]
- Gossimer Announces Special Domain Name Registration Deals December 25, 2009Gossimer, the fastest growing domain name registration and web hosting company has announced a special deal on 12 top domain extensions and that includes some CTLDs as well. This promotion is available on the registration of new domain names, and you can register as many domains as you want. [PR.com] […]
- Gossimer Announced a Transfer-in Domain Promotion to Allow Customers to Consolidate Their Domains Into One Account November 7, 2009Save money on domain name transfer to Gossimer. Gossimer is currently running an attractive promotion on domain transfer-in that will save a lot of money for the domain portfolio builder. You can transfer as many domains as you wish under this promotion. [PR.com] […]
- Gossimer Became Reseller of the Month for October October 17, 2009October brings another piece of good news for Gossimer. The fastest growing web hosting and domain name registration company has been chosen as the Reseller of the month for October by ResellerClub. [PR.com] […]
- Gossimer Offers One Year Free Extension on Domain Transfer October 3, 2009Gossimer, the fastest growing domain name registration company, is offering one year free extension with every domain name transferred to its system. This service when coupled with other services puts Gossimer in the position of price leadership. The company offers the most economic rate for domain name registration and webhosting services. [PR.com] […]
- New Deals Make Gossimer Bigger, Better and Smarter October 2, 2009October is going to be hot with offers, extended support, and enhanced serviceability, as Gossimer has acquired HiTek Networks, and launched new and improved Support desk. The web hosting world is abuzz by the two important developments in Gossimer. [PR.com] […]
- Gossimer Offers Unlimited E-mails for $1 September 28, 2009Gossimer, the fastest growing domain name and webhosting company, has announced a no-upgrade “The Ultimate Email Plan” that will give the buyer an access to unlimited email accounts for just $1/month. [PR.com] […]
Gossimer Promotions and Announcements
- TechSupport Notifications February 28, 2010Technical support information and notifications […]
- PHP4 Discontinuation - 18th September September 7, 2009As announced earlier, PHP4 will not be supported on our Linux Hosting Servers from the 18th of September, 2009. Please pass on this information to your Customers and Resellers to ensure that they can update their websites to work with PHP5. […]
- .CN Launch - Coming Soon August 16, 2009We are glad to announce the launch of .CN - the most popular and fastest growing ccTLD worldwide. The .CN domain extension has seen an exemplary growth since its launch throughout the world. Earlier this year, .CN crossed over 13 million registrations to become the second most registered domain extension after .COM. Moreover, with China now representing the […]
- Live Chat Product Discontinuation - Moved to 18th August August 16, 2009Based on feedback that we received from several Resellers, we have decided to postpone the Live Chat discontinuation to the August of 18th, 2009 at 12:30 UTC. From the 18th of August, it will not be possible to purchase new Live Chat packages but exisiting packages will continue to function normally. […]