July 24, 2008 02:58pm pdt

1. angelIII 510,330
2. hielo 293,110
3. ee_rlee 212,994
4. routinet 169,425
5. hernst42 140,488
6. cedlinx 105,840
7. yodercm 87,099
8. adrpo 80,750
9. Ray_Pas... 78,839
10. mankowitz 75,407
11. fibo 72,896
12. nplib 62,300
13. logudotcom 61,352
14. virmaior 60,339
15. paulop1... 59,650

1. angelIII 1,866,169
2. todd_far... 1,720,337
3. snoyes_jw 765,508
4. Raynard7 699,112
5. Squeebee 555,077
6. hernst42 499,188
7. leannonn 437,836
8. NovaDeni... 354,834
9. akshah123 324,132
10. AdrianSRU 301,402
11. hielo 297,710
12. psadac 268,491
13. routinet 267,630
14. virmaior 252,605
15. yodercm 244,968

02.24.2008 at 07:56AM PST, ID: 23188469

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.4

WAMP Apache Server: How to Import mySQL Database to Local Machine using phpMyAdmin from Cpanel Backup - mydb.sql.gz File

Zones: MySQL, Miscellaneous Web Development, Apache Web Server

Tags: WAMP Server 2.0, Windows XP, MYSQL Database, Cpanel Backup, phpMyAdmin, Apache

I've installed WAMP Server 2.0 onto my Windows XP SP2 system and I'm trying to import a mySQL database that was downloaded from the online server using Cpanel's database backup utility. The file is saved as: mydb.sql.gz

On the local machine this requires that I use the phpMyAdmin tool in WAMP since there is no Cpanel available.

According to the instructions, it seems that you simply enter the filename to be imported and click the 'Go' button in phpMyAdmin. I receive the error shown (in the attached image files.)

         
             Error
 
SQL query:
 
--
-- Table structure for table `wp_categories`
--
DROP TABLE IF EXISTS `wp_categories` ;
 
MySQL said: Documentation
#1046 - No database selected

Attachments:

PhpMyAdmin1.jpg (130 KB) (File Type Details)

Import Database from PhpMyAdmin