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.
I have been using AYK for about 2 years now and they are always on top of any issues I have. They have gone over and beyond helping me with any problems that come up with the server and they have never said "no" to any of my requests. I would definitely recommend them to anyone looking for a reliable server company.
I have a two small shared hosting packages and the price I pay I don't expect to receive very good support. I accept with any shared hosting uptime cannot be guaranteed neither can it be 100% and anyone who suggests otherwise is living a dream. However on the occasions I have opened a ticket they have been answered and investigated promptly. I have been with ayksolutions.com since Jun/18/2008 oh wow where has the time gone!
AYK provide a very good value product, and always in a professional manner. I have used several hosting companies over the past 17 years. During that time I occasionally needed help with a variety of minor setup issues. Only AYK gave quick and helpful answers. I highly recommend them.