1-888-524-7148

Menu

Giganetwebhosting.com Blog

Blog about Web Hosting, Domain Names, Web Sites, Internet presence.

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that has been used in the blog.

How to move your MySQL database from any other web hosting provider to your new site with us.

Posted by on in Web Hosting
  • Font size: Larger Smaller
  • Hits: 2605
  • Print

 

 

b2ap3_thumbnail_mysql.jpg1. Solution using PHPMyAdmin

 

The following are the steps to Export and then Import a MySQL database using phpMyAdmin

 Export from phpMyAdmin

  1. Open your phpMyAdmin at the previous host
  2. On the welcome screen you will see an Export option click on this link
  3. This will bring up the view dump (schema) of databases screen
  4. Select the tables you wish to be exported from the list
  5. Ensure you choose SQL as the option (this will allow you to just paste the SQL for your next host)
  6. It will create text file on the screen, highlight the information and paste it into a text document.
    Save this for when you get your web hosting account with giganetwebhosting.com.

 

 Import into phpMyAdmin

 

  1. Open cPanel at giganetwebhosting.com server with your usr and password and open your phpMyAdmin
  2. On the welcome screen you will see an Query window option (lower left corner) click on this link
  3. Paste the contents of the text file that you exported and done. Your database and it's contents are moved

Notes

 It is good to save the the data to a file, and then to transfer the file directly by using the file input form just below the query form.
Keep hold of the file so that you have a backup to refer to should something go wrong with the import.

 

2. Solution using mysqldump and shell access (Telnet, SSH)

 

It may be possible for you to move your database to Giganetwebhosting with one command passed through shell. This solution requires Shell (Telnet or SSH) access to one of the hosts, AND remote access to the "other" database. The command looks like this:

 mysqldump -h oldhost -u oldusername -poldpassword olddbname | mysql -h newhost -u newusername -pnewpassword newdbname

 Note: there is no space between "-p" and the password.

 

 Explanation

 

 The "mysqldump" command writes a copy of a database to a single file; this is known as "dumping." With these parameters, the database is written straight to your new server's database. The -h flag specifies the hostname, -u the username associated with the SQL database (NOT your domain management username for your host), -p is the SQL user's password, and finally there's the database name. Once the file is transferred, MySQL will populate the destination database with the data from the dumped file. Note that the destination database must already exist -- if it does not, this command will fail.

If you are running this command from shell on your old host, you must grant remote access to your Giganetwebhosting database from your Cpanel --> Databases --> Remote Mysql.  Add the IP address of your old server to Access Hosts.

 

Of course if you have problems migrating your database yourself you could ALWAYS ask our support dpt. to do the migration for you.

*Anytime money back.

anytime money back guarantee on all hosting plans. Nothing to worry about.We are in Web Hosting business since 1997 and we know your needs, we do our best for customer satisfaction. Giganetwebhosting.com offers a 'No Questions Asked' Anytime money back guarantee with all unlimited web hosting plans. If you decide to cancel your account at anytime Giganet web hosting will refund you for the remainder of your term, excluding domain registration fees, for which we incur a cost. It's like a warranty that never expires! Your satisfaction is our top priority, and we're confident that you'll be pleased with our services. Best web hosting risk free !

Server Security

Best server maintenance and security.Our servers have special security applications that ensure a secure and reliable hosting environment. Our 24/7 network monitoring ensures that, if an issue does arise, we address it immediately. We provide many additional services and modifications to the default Operating System and control panel installation which greatly enhances the security, reliability, and compatibility of our servers and softwareand offer best web hosting solutions available to our clients. Secure and safe unlimited web hosting, Vps hosting and dedicated servers hosting.

Low Price Lifetime Guarantee

Price guarantee for account life

We offer you a price guarantee for any future account renewals. We guarantee that your renewal price will be the same or less for all unlimited web hosting plans. Don't fall for the high discount bargains which are offered by most hosting providers. Read the fine print and note that the initial discounted price is usually 50-90% lower than the standard price at which you will be FORCED to renew! Cheap web hosting and best web hosting combined !
 The only place for affordable hosting with top hosting services.