MYSQL HELP
Posted by: eloycristian (190.236.197.---)
Date: January 11, 2021 05:01PM

MYSQL HELP
Before installing wamp server I used a database in Mysql.
Connection Method: Standard (TCP / IP)
Hostname: 127.0.0.1
Port: 3306
Username: root
Default schema: sige
After installing wamp server I can no longer see the database.
Does anyone know the reason? Thanks friends

Options: ReplyQuote
Re: MYSQL HELP
Posted by: RiggsFolly (Moderator)
Date: January 11, 2021 05:26PM

Yes, you have 2 instances of MySQL installed now

unless you deleted/uninstalled something it should still be there.

Lets see if we can find it

1. Exit WAMPServer
2. Start MySQL like you used to before installing WAMPServer.

If you now can see your old database, EXPORT IT (BACKUP) to somehwrere safe/

Stop the MySQL server instance you started.

Start WAMPServer.

Restore the databae from the safe place.


Now once you are sure you have the old database available in wanpserver uninstall the other MySQL instance.

Dont panic, as long as you keep that backup you can always get it back even if we have to install WAMPServer, but that shoudl not be necessary

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.2.5 32bit & 64bit)
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: MYSQL HELP
Posted by: Otomatic (Moderator)
Date: January 11, 2021 05:30PM

Hi,

Your database is an integral part of the MySQL version used.

If you change MySQL version - which you do with Wampserver - you cannot see your old database.

You need to run your previous version of MySQL - without running Wampserver - then export your database to a SQL file and quit your previous version of MySQL.

You will be able to launch Wampserver and then import your SQL file.

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.7 32 bit - Apache 2.4.51 - PHP 8.1.0…5.6.40 - MySQL 5.7.36 - MariaDB 10.5.13/10.6.5
Wampserver 3.2.7 64 bit - Apache 2.4.51 - PHP 8.1.0…5.6.40 - MySQL 5.7.36/8.0.27 - MariaDB 10.5.13/10.6.5
PhPMyadmin 5.1.1 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: MYSQL HELP
Posted by: eloycristian (190.236.197.---)
Date: January 11, 2021 05:54PM

Dear thanks for the help !!!
1) RiggsFolly: After installing WAMP the old connection was deleted. I see that WAMP uses as server: MySQL: 3308
2) As you indicate, I have exited Wamp Server and I have entered Workbench. I have re-created a connection with the old data. Upon entering it reports: "Server status: Stopped" and the database is not seen.
I think Otomatic is right. Will there now be two MySQL folders? I will look for the previous one, although the Workbench is the same as before.

Options: ReplyQuote
Re: MYSQL HELP
Posted by: eloycristian (190.236.197.---)
Date: January 11, 2021 06:03PM

Go to C: \ Program Files (x86) \ MySQL \ MySQL Installer for Windows
I ran MySQLInstaller
In the Product listing it said “MySQL Server” Quick Action Reconfigure.
I followed the steps
Now I see the tables that I had in my database !!!

Options: ReplyQuote
Re: MYSQL HELP
Posted by: Otomatic (Moderator)
Date: January 11, 2021 06:09PM

Hi,

>I see that WAMP uses as server: MySQL: 3308
You have not installed the latest version of Wampserver: 3.2.3
See : Right-Click -> Help -> MariaDB-MySQL

> After installing WAMP the old connection was deleted.
The connection to the previous version is no longer valid, it has not been removed by the installation of Wampserver.
Just quit Wampserver and you will be able to reconnect to your old version since the MySQL service will be stopped, so port 3306 will be free.
Your database is still there, in the data folder of your MySQL version.

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.7 32 bit - Apache 2.4.51 - PHP 8.1.0…5.6.40 - MySQL 5.7.36 - MariaDB 10.5.13/10.6.5
Wampserver 3.2.7 64 bit - Apache 2.4.51 - PHP 8.1.0…5.6.40 - MySQL 5.7.36/8.0.27 - MariaDB 10.5.13/10.6.5
PhPMyadmin 5.1.1 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote


Sorry, only registered users may post in this forum.