WampServer

Hi,.

I have zip the wamp folder from my previous laptop so that i can restore it into my new one,.
my previous wamp are installed in windows 7 os 32bit and the new one are windows 7 os 64bit
i already instaled new wamp 2.5 64bit in my new laptop,.
what should be the configuration so that the www folder and mysql will connect to have a running normal localhost just like the previous one?

Regards

Joseph

Hi,

> have a running normal localhost just like the previous one?

Inspire you from Install a new release of Wampserver

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

is copy pasting the my sql folder and www will work ?

is there a tutorial on how to complete migrate wamp to another unit ?

i get this error

Error displaying the error page: Application Instantiation Error: Table 'j3ptd1.cg4lw_session' doesn't exist SQL=DELETE FROM `cg4lw_session` WHERE `time` < '1448442561'

Hi,

> is copy pasting the my sql folder and www will work ?
NO !
The one and only way to transfer a database is the export / import in one (or more) SQL files.

> is there a tutorial on how to complete migrate wamp to another unit ?
It is (almost) the same as the link I gave you.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

i zip the wamp folder without doing sql backup
i just paste the folder of the db in the bin/data and views it in the phpmyadmin,
the db is visible from there but how to adjust the configuration
so it connect the www (localhost) folder

Hi,

> i already instaled new wamp 2.5 64bit in my new laptop,.
First error. It is not the same as the previous
You had a MySQL version 32 bit and now you have one 64-bit and you want everything to work just by copying the data file? do not dream !

> i zip the wamp folder without doing sql backup
Second BIG ERROR.

It could - perhaps - work provided you have EXACTLY the same MySQL versions and not by copying the data folder.

With exactly the same version of MySQL, you unzip the old data folder and all its contents to a temporary folder, so that in this temporary data directory, you should have:
c:\tempbase\my-database\
c:\tempbase\mysql\
c:\tempbase\performance_schema\
c:\tempbase\sys\
c:\tempbase\auto.cnf
c:\tempbase\ib_buffer_pool
c:\tempbase\ib_logfile0
c:\tempbase\ib_logfile1
c:\tempbase\ibdata1

Then, in my.ini file, you replace :

datadir="c:/wamp/bin/mysql/mysql5.6.12/data"

by

#datadir="c:/wamp/bin/mysql/mysql5.6.12/data"
datadir="c/tempbase"

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

" do not dream ! "
ow i wish this is Christmas

"Second BIG ERROR"
i know, thats why im asking and posting to this forum for miracle from the sky

"It could - perhaps"
ok,ill try this one first,. rokenrol !

"Question: how much is 9 plus 12?"
to be honest i type 33..

lucky me,.
folder shows "wamp\bin\mysql\mysql5.6.17"
the version is the same with 64bit active in my new unit

"unzip the old data folder and all its contents to a temporary folder"
ok i did that already because its inside the wamp.zip
so just locate my database inside the zip (bin/mysql/mysql5.6.17/data)
and copy paste to new location (c:/wamp/bin/mysql/mysql5.6.17/data)

"c:\tempbase\my-database\"
where to find the location of tempabase ?
should put it exactly inside the C:\wamp\bin\mysql\mysql5.6.17\data ?

just to make sure,.
you're typing "datadir="c:/wamp/bin/mysql/mysql5.6.12/data"
i suppose for me its 5.6.17 right ?
cmiiw



Edited 2 time(s). Last edit at 11/25/2015 06:43PM by jspdjanggo.

Hi,

> where to find the location of tempabase ?
It is a temporay folder you create.

> should put it exactly inside the C:\wamp\bin\mysql\mysql5.6.17\data ?
No.
You don't modify existing working installation of mysql.

You put the old content of mysql/data into the temporary folder.

> the version is the same with 64bit active in my new unit
The MySQL versions are not the same 32 bit in the old and 64 bit with the new.

If you can recover your databases, you need the version of MySQL is not only the same number, but also the same type of compilation, that is to say 32 bit in both cases. In fact, originally, the necessary databases to MySQL (mysql, performance_schema, sys) were generated with the 32 bit version of MySQL. And, these databases are part of the data folder.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

ok,.
so a view thing to reconsider about your solving information which i missed,.

first is you said same version but different type of compilation will not work,.
seems i have to uninstall my 64bit and replace with 32bit to have the same specifications
ok,.that can be done,.

second
this tempbase or temporary folder, should it be in C:\wamp directory or just C:\
the modification for my.ini is made in the new wamp environment right ?
by commenting
#datadir="c:/wamp/bin/mysql/mysql5.6.12/data"

and add new line
datadir="c/tempbase"
a question for the new line is it with " : " or with out ?
datadir="c:/tempbase"



Edited 1 time(s). Last edit at 11/25/2015 06:45PM by jspdjanggo.

Hi,

> this tempbase or temporary folder, should it be in C:\wamp directory or just C:\
Not in c:\wamp.
It can be C:\tempbase or other name you want.

> the modification is made for my.ini is made in the new wamp environment right ?
Yes. But only after you are sure that the new MySQL environnement is working well that is to say correct accès to MySQL console and PhpMyAdmin.

> by commenting
> #datadir="c:/wamp/bin/mysql/mysql5.6.12/data"
> and add new line
> datadir="c/tempbase"
> a question for the new line is it with " : " or with out ?
> datadir="c:/tempbase"
With : ie c:/tempbase (it was a typo)

Often I wish I could explain more clearly, but the language barrier is there and I'm sorry. In the French forum, I give more detailed explanations, but French is my native language.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

ok, i get it,.

ok no problem,
just type clear french and ill paste it to google translate

Uninstall 64bit went successful
Installation 32bit went successful

at this moment Wamp startup logo green status server offline


I did a cross check from the list you mention earlier
==========================
Checklist
==========================
c:\tempbase\my-database\ (check)
c:\tempbase\mysql\ (check)
c:\tempbase\performance_schema\ (check)
c:\tempbase\sys\ (N/A)
c:\tempbase\auto.cnf (check)
c:\tempbase\ib_buffer_pool (N/A)
c:\tempbase\ib_logfile0 (check)
c:\tempbase\ib_logfile1 (check)
c:\tempbase\ibdata1 (check)


As following are the list from the database i have from previous unit
=========================
Previous 32bit
=========================
c:\tempbase\my-database\
c:\tempbase\mysql\
c:\tempbase\performance_schema\
c:\tempbase\test\
c:\tempbase\auto.cnf
c:\tempbase\ib_logfile0
c:\tempbase\ib_logfile1
c:\tempbase\ibdata1
c:\tempbase\Acer-PC.pid


As following are the list from the database active in the new unit
=========================
Active 32bit
=========================
c:\tempbase\mysql\
c:\tempbase\performance_schema\
c:\tempbase\test\
c:\tempbase\auto.cnf
c:\tempbase\ib_logfile0
c:\tempbase\ib_logfile1
c:\tempbase\ibdata1
c:\tempbase\Acer-PC.pid



Edited 1 time(s). Last edit at 11/25/2015 10:09PM by jspdjanggo.

As following are the edit in my.ini located C:\wamp\bin\mysql\mysql5.6.17

================================================

# The MySQL server
[wampmysqld]
port = 3306
socket = /tmp/mysql.sock
key_buffer_size = 16M
max_allowed_packet = 1M
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
basedir=c:/wamp/bin/mysql/mysql5.6.17
log-error=c:/wamp/logs/mysql.log


# commenting the datadir and seperate from above line to connect previous database
# refers to wampserver forum [forum.wampserver.com]
# datadir=c:/wamp/bin/mysql/mysql5.6.17/data
datadir=c:/inibijisaya
=================================================

i did an erase the " " sign because inside the script there is no " " sign
from what you mentioned earlier which are

datadir="c:/tempbase"

i input the line with out " "

datadir=c:/tempbase


and also i have place the web content folder inside the www folder

last thing after all is set i do a restart all service from the wamp startup logo



Edited 3 time(s). Last edit at 11/25/2015 10:55PM by jspdjanggo.

Perfect everything is perfect !

thanks Otomatic !

now i can go to sleep



Edited 2 time(s). Last edit at 11/25/2015 11:31PM by jspdjanggo.

after that i backup the database by export
and then i release the comment and put back the original line

datadir=c:/wamp/bin/mysql/mysql5.6.17/data
#datadir=c:/inibijisaya

i do a restart all service and wait until green
after that i create a new database named exactly as my previous one

i do a dump into the sql tab
first i open the backup file in a notepad and then copy pasting to sql tab

the last thing is i go to structure tab and check all then select repair table

ok so, things are good and solved.

thanks again Otomatic !



Edited 1 time(s). Last edit at 11/25/2015 11:30PM by jspdjanggo.