30 Jul 10 How do I import data into a MySQL database?

You can use phpMyAdmin to import any data in your MySQL databases. phpMyAdmin provides an easy manner for you to add further content to your databases. Follow the process outlined below to import data via phpMyAdmin:

1. Connect to your database using phpMyAdmin. Click here to read how >>

2. Select the database in the left frame.

3. Click the SQL tab at the top of the page.

4. In the Or use a text file section, click Browse and select your .sql file.

5. Once the SQL file is selected, click Go.

If the above doesn’t work for phpMyAdmin, try opening the file in a text editor and pasting the contents in to the SQL form.

Tags: Left Frame, Mysql Database, Mysql Databases, Phpmyadmin, text editor

Filed in Databases with 0 Comments

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

Filed in Databases with 0 Comments

27 Jul 10 How do I export a table from a MySQL database to a tab delimited file for use in Microsoft Excel?

The Database Manager allows you to export a database (or selected tables) to a file. Some file formats allow you to view the records in another application, such as Microsoft Excel.

CSV for MS Excel A CSV file optimized for use in Microsoft Excel.

To export a CSV file:

1. Connect to your database. You can do this remotely, or using phpMyAdmin.

2. Select the desired tables.

3. Select CSV from the Export box.

4. Now, set the desired CSV Options.

5. Check the Save as file check-box.

6. Click on Go.

There are only three CSV for Microsoft Excel export options: replacement string for NULL values, put field names at first row, and specify Excel platform (Windows or Macintosh).

To export a CSV for Microsoft Excel file:

1. Connect to your database. You can do this remotely, or using phpMyAdmin.

2. Select the desired tables.

3. Select CSV for MS Excel from the Export box.

4. Set the desired export options.

5. Check the Save as file check box.

6. Click Go.

Tags: Csv File, Database Manager, Excel Csv, Excel Database, Export Box, Export Options, Field Names, Macintosh, Microsoft, Microsoft Database, Microsoft Excel, Microsoft Windows, Ms Excel, Mysql Database, Null Values, Phpmyadmin, Platform Windows, Replacement String, Some File Formats

Filed in Databases with 0 Comments

16 Jul 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

Filed in Databases with 0 Comments

01 Jul 10 Connecting to and Managing your database using PHPMyAdmin

PhPMyAdmin is a tool that helps you construct and manage your databases efficiently. Using PhPMyAdmin is very simple, just follow the process outlined below to connect to your database using PhPMyAdmin.

1. Login to your Control Panel and search for the domain name for which you have purchased this hosting package.

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 -> List Databases.

5. Click on the database to which you wish to connect.

6. A new popup window will open asking for username and password. Enter your database username and password in order to login.

You will then be logged in to the PhPMyAdmin interface where you can manage your database.

Tags: 3 Web, Control Panel, Database Manager, Databases, Details View, Domain Name, Manage Web Hosting Service, Management Interface, Password Database, Phpmyadmin, Popup Window, View 3, Web Hosting Service, Web Service, Website Management

Filed in Databases with 0 Comments

30 Jul 10 How do I import data into a MySQL database?

27 Jul 10 How do I make a backup copy of a MySQL database?

27 Jul 10 How do I export a table from a MySQL database to a tab delimited file for use in Microsoft Excel?

Recent Posts

Some good Links

Favorite Gossimer Links

Categories

Tags

Gossimer in the News

Gossimer Promotions and Announcements