Hi,
I recently discovered a much nicer (My)SQLManager than phpMyAdmin, SQLBuddy. I now completely integrated it with my WAMP server. Below you can find all steps required to integrate it at a Windows server:
(I assume that you have installed Wamp to the default destination, C:\wamp\.)
1. Download SQLBuddy at [
www.sqlbuddy.com].
2. Extract the ZIP-file to C:\wamp\apps\.
3. Rename the folder "sqlbuddy" (in the C:\wamp\apps\-folder) to "sqlbuddy1.2.9" (or if there is a newer version, "sqlbuddyVERSION"
.
4. Go back to C:\wamp\ and open the folder "alias" (path: C:\wamp\alias\).
5. Create a file named "sqlbuddy.conf". Open this file put the following in it:
Alias /sqlbuddy/ "c:/wamp/apps/sqlbuddy1.2.9/"
<Directory "c:/wamp/apps/sqlbuddy1.2.9/">
Options Indexes FollowSymLinks MultiViews
AllowOverride all
Order allow,deny
Allow from all
</Directory>
6. Save the file.
7. SQLBuddy will be now shown in the "Your Aliases" on the homepage of the localhost. SQLBuddy is now accessable through [
localhost].
Following steps are needed if you want SQLBuddy to appear in the contextmenu of Wamp (the trayicon).8. Go to the folder C:\wamp\lang\
9. Open the .lang file corresponding to your language (the language you use, for example: english.lang).
10. Add the following line to it (as long as it is bellow the first line it doesn't matter where you put it):
$w_sqlbuddy = 'SQLBuddy';
11. Save the language file. Go back to C:\wamp\.
12. Open the file "wampmanager.tpl" in C:\wamp\ (path to file: C:\wamp\wampmanager.tpl).
13. Go to line 123. Go to the end of this line, press return to start a new line. Put on this line the following:
Type: item; Caption: "${w_sqlbuddy}"; Action: run; FileName: "${c_navigator}"; Parameters: "[localhost];; Glyph: 5
14. Save this file. You need to reboot Wamp in order to have this any affect (actually refreshing is enough). SQLBuddy will be now visible in the context-menu of the Wamp-trayicon right below phpMyAdmin.
Following steps are needed if you want to have SQLBuddy in the "Tools" list at the mainpage of your localhost15. Go to C:\wamp\www\.
16. Open the index.php (path to file: C:\wamp\www\index.php).
17. Go to line 369, go to the end of this line and press return to start a new line. Put the following on this line:
<li><a href="sqlbuddy/">sqlbuddy</a></li>
18. Save this file, and refresh [
localhost]. SQLBuddy will be now shown in the Tools-list.
With kind regards,
SX Dev
Edited 1 time(s). Last edit at 08/21/2008 07:52PM by sxdev.