Allows you to search a variety of questions and answers
The following way is only good for users with phpMyAdmin installed on their servers!
1. Login to your old control panel and go to PHPmyAdmin (if you are running Cpanel, it will be under MySQL, at the bottom).
2. Choose the database you want to move from the drop down list on the left.
3. After the page loads, click on the 'Export' tag at the top of the right page. Then 'Select All'. This will select all the tables in the database.
4. Finally, check the SQL extension type (should be default), check the Save To File box and put in the name you want this file to have.
5. Hit 'Go'. This will save the .sql file to your machine at home/office.
6. Upload the .sql file to that account on your new server.
7. Login to shell and put in:
'mysql -u dbname_user -p dbname_dbname < dbfile.sql
8. Hit enter and for the password put in the password of that database.
If you do not have shell access, you can use phpmyadmin to do the same, almost.
After downloading the file, login to your phpmyadmin panel on your new server, choose the database you want to populate (must have the same name as the one on your old server), click on the SQL tab and copy/paste the whole database into the text field. Then just hit 'Go'. If the database is large, it may take a while, so give it some time.
AYK Solutions has provided me with a very cost effective hosting service with great uptime and lots of features. I would not hesitate to recommend them!
Great service with affordable price, also helpful and kindness staff.
Dedicated Semi-Managed Server Review I've been using AYKSolutions for about 2 years now and their support and servers have been great. They assisted me with the transition of all my websites and databases from my old server onto their system with no problem. If I ever need them for support or a change they respond fast and always keep me up to date with the status of my support ticket. I highly recommend using this company especially if you're looking for someone to assist with server management. Best of all their cost is great!