27 Jul 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
01 Jul 10 Adding a DSN
Follow the process outlined below to add a DSN for your database:
1. In the Website Management interface, go to Manage Website -> DSN Manager -> Add DSN.
2. Here, you need to provide a name for the DSN you are adding, as well as the database your are adding it for.
3. Additionally, you may also specify the DSN type, along with additional database details such as the hostname, and the username/password for accessing the database.
4. On clicking Submit, the DSN will be added for the database specified.
Tags: Database Details, Dsn, DSN Manager, Hostname, Management Interface, 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. […]