lost conection to my database
Posted by: egoph (---.bredband.comhem.se)
Date: October 17, 2017 11:55PM

I made a misstake and deleted a wampfile(?) which i thought was some kind of virus. Probably It was for the connection to Dbase and Now I cant reach my dbase. Tried both by the virtual way and via phpmyadmin
Can i update Wamp without loosing the daatabase? or what to do?
here is the errorfile
:
[17-Oct-2017 21:40:23 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): Impossible to make a connection.

in D:\wamp\www\phunderscored\wp-includes\wp-db.php on line 1548

[17-Oct-2017 21:40:23 UTC] PHP Stack trace:

[17-Oct-2017 21:40:23 UTC] PHP 1. {main}() D:\wamp\www\phunderscored\index.php:0

[17-Oct-2017 21:40:23 UTC] PHP 2. require() D:\wamp\www\phunderscored\index.php:17

[17-Oct-2017 21:40:23 UTC] PHP 3. require_once() D:\wamp\www\phunderscored\wp-blog-header.php:13

[17-Oct-2017 21:40:23 UTC] PHP 4. require_once() D:\wamp\www\phunderscored\wp-load.php:37

[17-Oct-2017 21:40:23 UTC] PHP 5. require_once() D:\wamp\www\phunderscored\wp-config.php:89

[17-Oct-2017 21:40:23 UTC] PHP 6. require_wp_db() D:\wamp\www\phunderscored\wp-settings.php:106

[17-Oct-2017 21:40:23 UTC] PHP 7. wpdb->__construct() D:\wamp\www\phunderscored\wp-includes\load.php:404

[17-Oct-2017 21:40:23 UTC] PHP 8. wpdb->db_connect() D:\wamp\www\phunderscored\wp-includes\wp-db.php:658

[17-Oct-2017 21:40:23 UTC] PHP 9. mysqli_real_connect() D:\wamp\www\phunderscored\wp-includes\wp-db.php:1548

[17-Oct-2017 21:40:23 UTC] PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in D:\wamp\www\phunderscored\wp-includes\wp-db.php on line 1578

[17-Oct-2017 21:40:23 UTC] PHP Stack trace:

[17-Oct-2017 21:40:23 UTC] PHP 1. {main}() D:\wamp\www\phunderscored\index.php:0

[17-Oct-2017 21:40:23 UTC] PHP 2. require() D:\wamp\www\phunderscored\index.php:17

[17-Oct-2017 21:40:23 UTC] PHP 3. require_once() D:\wamp\www\phunderscored\wp-blog-header.php:13

[17-Oct-2017 21:40:23 UTC] PHP 4. require_once() D:\wamp\www\phunderscored\wp-load.php:37

[17-Oct-2017 21:40:23 UTC] PHP 5. require_once() D:\wamp\www\phunderscored\wp-config.php:89

[17-Oct-2017 21:40:23 UTC] PHP 6. require_wp_db() D:\wamp\www\phunderscored\wp-settings.php:106

[17-Oct-2017 21:40:23 UTC] PHP 7. wpdb->__construct() D:\wamp\www\phunderscored\wp-includes\load.php:404

[17-Oct-2017 21:40:23 UTC] PHP 8. wpdb->db_connect() D:\wamp\www\phunderscored\wp-includes\wp-db.php:658

[17-Oct-2017 21:40:23 UTC] PHP 9. wpdb->db_connect() D:\wamp\www\phunderscored\wp-includes\wp-db.php:1573

[17-Oct-2017 21:40:23 UTC] PHP 10. mysql_connect() D:\wamp\www\phunderscored\wp-includes\wp-db.php:1578

[17-Oct-2017 21:40:25 UTC] PHP Warning: mysql_connect(): Det gick inte att g�ra en anslutning eftersom m�ldatorn aktivt nekade det.

in D:\wamp\www\phunderscored\wp-includes\wp-db.php on line 1578

[17-Oct-2017 21:40:25 UTC] PHP Stack trace:

[17-Oct-2017 21:40:25 UTC] PHP 1. {main}() D:\wamp\www\phunderscored\index.php:0

[17-Oct-2017 21:40:25 UTC] PHP 2. require() D:\wamp\www\phunderscored\index.php:17

[17-Oct-2017 21:40:25 UTC] PHP 3. require_once() D:\wamp\www\phunderscored\wp-blog-header.php:13

[17-Oct-2017 21:40:25 UTC] PHP 4. require_once() D:\wamp\www\phunderscored\wp-load.php:37

[17-Oct-2017 21:40:25 UTC] PHP 5. require_once() D:\wamp\www\phunderscored\wp-config.php:89

[17-Oct-2017 21:40:25 UTC] PHP 6. require_wp_db() D:\wamp\www\phunderscored\wp-settings.php:106

[17-Oct-2017 21:40:25 UTC] PHP 7. wpdb->__construct() D:\wamp\www\phunderscored\wp-includes\load.php:404

[17-Oct-2017 21:40:25 UTC] PHP 8. wpdb->db_connect() D:\wamp\www\phunderscored\wp-includes\wp-db.php:658

[17-Oct-2017 21:40:25 UTC] PHP 9. wpdb->db_connect() D:\wamp\www\phunderscored\wp-includes\wp-db.php:1573

[17-Oct-2017 21:40:25 UTC] PHP 10. mysql_connect() D:\wamp\www\phunderscored\wp-includes\wp-db.php:1578



Edited 1 time(s). Last edit at 10/18/2017 12:03AM by egoph.

Options: ReplyQuote
Re: lost conection to my database
Posted by: RiggsFolly (Moderator)
Date: October 18, 2017 10:19AM

Hi

Which file did you delete?

---------------------------------------------------------------------------------------------
(Windows 7 Pro 32bit) (Wampserver 3.0.6 32bit)
<Apache 2.4.23/2.2.31> <PHP 7.1.2/7.0.16/5.6.28/5.5.38/5.4.45/5.3.29> <MySQL 5.7.10/5.6.17/5.5.28>
<MariaDB 10.1.21> <phpMyAdmin4.7.5> <MySQL Workbench 6.3.6.511>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin -- WAMPServer alternate Repo
-?-?-?- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -?-?-?-

Options: ReplyQuote
Re: lost conection to my database
Posted by: egoph (---.bredband.comhem.se)
Date: October 18, 2017 10:44AM

I think there should be tree catalouges under www: wamplanguas and wamptheme and the one I have lost.
I cant find the name anywhere

Options: ReplyQuote
Re: lost conection to my database
Posted by: Otomatic (Moderator)
Date: October 18, 2017 02:44PM

Hi,

Apply Wampserver 3.1.0 update.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.1 32 bit - Apache 2.4.29 - PHP 7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
Wampserver 3.1.1 64 bit - Apache 2.4.29 - PHP 7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
PhPMyAdmin 4.7.5 - 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: lost conection to my database
Posted by: egoph (---.bredband.comhem.se)
Date: October 19, 2017 11:09AM

Didn't help! I also cant run my phpmyadmin no conection: As it is a local installation is it possible to save my databases?



Edited 1 time(s). Last edit at 10/19/2017 11:13AM by egoph.

Options: ReplyQuote
Re: lost conection to my database
Posted by: Otomatic (Moderator)
Date: October 19, 2017 11:19AM

Hi,

> As it is a local installation is it possible to save my databases?

Is the wampmysqld service started?

Do you have access to the MySQL console?
Left-Click wampmanager tray icon -> MySQL -> MySQL console
When prompted for a password, type the password if you put one to root, or just press the Enter key.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.1 32 bit - Apache 2.4.29 - PHP 7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
Wampserver 3.1.1 64 bit - Apache 2.4.29 - PHP 7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
PhPMyAdmin 4.7.5 - 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: lost conection to my database
Posted by: egoph (---.bredband.comhem.se)
Date: October 19, 2017 12:18PM

wampmysqld: ready for connections.
Version: '5.7.14' socket: '' port: 3308 MySQL Community Server (GPL)

ok I am in the msql monitor... what to do? tested mysql> \r
Connection id: 2
Current database: *** NONE ***



Edited 3 time(s). Last edit at 10/19/2017 01:12PM by egoph.

Options: ReplyQuote
Re: lost conection to my database
Posted by: Otomatic (Moderator)
Date: October 19, 2017 01:36PM

Bonjour,

> Version: '5.7.14' socket: '' port: 3308 MySQL Community Server (GPL)
Mysql is not the default database manager since port 3308 is used.

The default handler (port 3306) is MariaDB.

Launch PhpMyAamin and choose MariaDB server.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.1 32 bit - Apache 2.4.29 - PHP 7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
Wampserver 3.1.1 64 bit - Apache 2.4.29 - PHP 7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
PhPMyAdmin 4.7.5 - 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: lost conection to my database
Posted by: egoph (---.bredband.comhem.se)
Date: October 19, 2017 01:54PM

Bonjour,
I changes the port from 3306 to 3308 according to Skype.
When I try to get back to 3306 it says canceled switch file mariadb is missing or the directory.

Is it possible to only get that back? Or what to do?



Edited 1 time(s). Last edit at 10/19/2017 02:47PM by egoph.

Options: ReplyQuote
Re: lost conection to my database
Posted by: Otomatic (Moderator)
Date: October 19, 2017 02:58PM

Hi,

> I changes the port from 3306 to 3308 according to Skype.
The ports assigned to the database managers (3306 to 3308) have STRICTLY nothing to do with Skype.
See point number 03 of TROUBLESHOOTING TIPS

You have deleted files and you do not know which ones.
We do not even know what version of Wampserver you have installed.
You changed a port reserved for MySQL when it was not necessary.
In short, you have "tweaked" in the wrong direction and would like you to be given everything in good condition; do not you think that you exaggerate a little bit!

Right-Click Wampmanager tray icon -> Tools -> Use a port other than 3308
then choose 3306

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.1 32 bit - Apache 2.4.29 - PHP 7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
Wampserver 3.1.1 64 bit - Apache 2.4.29 - PHP 7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
PhPMyAdmin 4.7.5 - 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 »



Edited 1 time(s). Last edit at 10/19/2017 03:11PM by Otomatic.

Options: ReplyQuote
Re: lost conection to my database
Posted by: egoph (---.bredband.comhem.se)
Date: October 19, 2017 03:23PM

Resolved!
Love You! Merci beaucup....cant spell it Thanks...a lot

Options: ReplyQuote


Sorry, only registered users may post in this forum.