WampServer

hi!
I needed Perl and tried to add that to Wampserver, but I failed, something kept corrupting the wampserver.ini file (some comment about oracle kept being inserted and causing errors).

To get over this I installed a new version of Wampserver. But now I need to copy my MySQL data.

I installed the old WAMP on c:/wamp and the new on c:/wamp/wamp/

Starting the old version's mysqld.exe gives the right database but I cannot get into the InnoDB tables.

Says

#1286 - Unknown table engine 'InnoDBte_tmp*¨¡Dle'


Please let me know what to do.

The old MySQL data where on the D drive and are not overwritten.

u cannot move innodb databsases in the way that you did,,, you needed to export them

most likely they are now curropt

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

hi Steven,
I should have, I am very well aware of that now. But thanks for reminding me.

But since I made a copy of the files what can I do with the backup to be able to make a new export?

do you have an exported file of the database?

like i sed- you cant reliablly move any mysql files and then expect them to ever work again... if mysql service was running while you moved them . they are now curropt and pretty much useless

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

No Steven, I said I made a backup copy. I did not say I moved them while MySQL was running.


What I was hoping for is advice on how to work with mysql.ini and the datafiles to get access to the files again.

which files do you have?

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

Hi Steven, thanks for still trying for me

Basically I have two wampservers, one at c:/wamp
with c:/wamp/apps/mysql/mysql5.0.51b/data <-- that one I would like to run for once.
as well as c:/wamp/apps/mysql/mysql5.1.36/data

using d:/mysql/ for data.


The newer is installed at c:/wamp/wamp
with data at what is, I suppose the default location c:/wamp/wamp/apps/mysql/mysql5.1.36/data
There is no vital data overhere.


The my.ini of the one I really would like to see back, mysql 5.10, says, with most comments removed:

# MySQL Server Instance Configuration File
# net start MySQL41
[client]
port=3306
[wampmysqld]
port=3306
basedir=c:/wamp/bin/mysql/mysql5.0.51b

log-error=c:/wamp/logs/mysql.log

#Path to the database root
#datadir=c:/wamp/bin/mysql/mysql5.0.51b/data <-as you see that directory is commented 'off'
datadir=d:/mysql/data


default-character-set=latin1
default-storage-engine=INNODB
max_connections=255
query_cache_size=8M
table_cache=510
tmp_table_size=13M
thread_cache_size=12

#*** MyISAM Specific options
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=8M
key_buffer_size=9M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=203K

#skip-innodb
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=15M
innodb_log_file_size=10M


[mysqld]
port=3306
================================

So basically the elements are all there, for what I am aware of, I just have no idea how to start it in such a way that I can make database dumps! And also no idea wether there are dll's running around.

Chris Export your database into a .SQL File And then Import it back into the second/new Wamp Server Directory

To Export it from the old wamp:
Go to [localhost]
Click The Export Tab from the right side of the page
now that the page loaded Look in the right place and click select all to select all databases
scroll at the bottom of the page and Click "zipped" And then Click Go
Hooorayyy !!! you now have the sql Files

now you need to import them back into your new Wamp Dyrectory....
if your databases are bigger than 2,048 KiB then ir wont import them back with the import function from phpmyadmin...
but you may use big dump to import them back in

i doubt it.. cos ur wamp isnt working right?

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

hi TheKillerR,
that's possible as soon as I've got the old databases back 'up' again. I would love to have them 'up', but I was hoping to get some suggestions.

My next try will be to turn off running mysql service(s), and see if I can convince mysql 5.0 to start manually and point it to the current mysql.ini

Chris

Ok apparently the WAMP setup was not expecting me to do all this. Something either blocked innodb or modified the WAMP setup file.

So I installed the newest MySQL independently, with innodb support, pointed it's mysql.ini to my old data directory and then i could access the databases and rescue them.

Relieved now.