WampServer

Hello,
Recently I had to change my computer and placed the old hard disk as secondary to the new system. I was running WAMP successfully on the old system and have many sites under development. I installed the latest version of Wamp in the new hard disk. But since the old site uses databases all through, I am not able to work with the previous sites.

Is it possible to get back the data files by copying certain files from PHPmyAdmin folder? (A wild wish??)

The Wamp version details:
Wamp2.0
phpmyadmin2.11.6
apache2.2.8
php5.2.6

The new One:
Wamp2.0
phpmyadmin3.2.0.1
Apache2.2.11
php5.3.0

You have to export your databases and then import them using phpmyadmin.
Note that phpmyadmin is just an UI to use mysql.
Only mysql contains and mange databases...

Florian

WampServer Patch (Screenshots)
Topic EN : www.wampserver.com
Topic FR : www.wampserver.com

Thanks.
The problem is that I am not able to access the old phpmyadmin to export the data.
Jay

can u access the old wamp folder?


open c:/wamp/mysql/mysql.x.x./data


copy the data folder and move it to ur new version.. this may and maynot work depending on the mysql engine u were using

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

That's was a real help.
There is one more issue now. I had the previous phpmysql running with user: root and password: root, now the new installation doesn't have a password set. The the phpmyadmin throw the error "#1045 - Access denied for user 'root'@'localhost' (using password: NO)".

I checked my.ini, but couldn't figure out the setting.

Thanks
Jay

yes its in my.ini but first u need to set it in phpmyadmin... for mysql



if you have hotmail or skype add me and ill guide u thru it

MSN - stevenmartin99@hotmail.com
SKYPE - stevenmartin99

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Thanks for your help Steven.
I am almost thru. Now I am able to get into phpmyadmin and see the tables. However when I access those old tables I get the error : "#1286 - Unknown table engine 'InnoDB' "
Is there a quick fix for this?
I will get onto msn, if the fix is not easy.
Thanks
Jay

open ur my,ini file


left click wamp>mysql>my.ini


find


default-storage-engine = InnoDB


AND Change it to

default-storage-engine = MyISAM

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Unfortunately my.ini doesn't have "default-storage-engine = InnoDB "
On find, the only portion that mentioned InnoDB is as below:
-----------------------------------------------------
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = C:\mysql\data/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = C:\mysql\data/
#innodb_log_arch_dir = C:\mysql\data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50
-------------------------------------------------------

And MyISAM

-------------------------------------------------------
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
-------------------------------------------------------

I have added you to MSN. And my MSN is jayseena@msn.com.
Thanks for all your help
Jay

then just add that line to my.ini file and restart wamp

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Thank you very much. That did the trick

Sorry to come back again. With your help I have learned the WAMP greatly.

However I am stuck again as lately I found that the above tricks didn't help me to achieve what I want.

Since I have all the old files intact in my secondary hard disk (the erstwhile primary) I tried changing all the configuration paths and started WAMP. But no luck. It just shows the red signal.

What I did was a find and replace for all C: and changed them to E:. However the IE path was retained.

As per the XP Event Viewer the error shows as:

1. "The wampapache service failed to start due to the following error: The system cannot find the path specified. "

2. The wampmysqld service failed to start due to the following error: The system cannot find the path specified.

Any idea where these paths are!

Thanks.
Jay

You shouldn't proceed like this. Try to restore all previous path.

You have to uninstall services since path precised in it is wrong now...
So, use uninstall_services.bat.
Then, install each service from wamp menu.

Florian

WampServer Patch (Screenshots)
Topic EN : www.wampserver.com
Topic FR : www.wampserver.com