🌍
English
Announcement
- [2024-04-17] Piwigo 14.4.0
- [2024-04-01] Piwigo in Hobbit runes
- [2024-03-01] Piwigo 14.3.0
- [2024-01-30] Piwigo 14.2.0
- [2023-12-29] Piwigo 14.1.0
#1 2019-01-16 13:16:25
- kdmiller45
- Member
- Phoenix
- 2018-07-16
- 67
Moving Piwigo server
Hello All,
I removed all pluggins from the old site, then copied the complete photo site to the new server, then exported the database with phpmyadmin from old site and uploaded to new site, I get the following error
Warning: mysqli::__construct(): (HY000/1698): Access denied for user 'root'@'localhost' in /var/www/ourlifeinpixs/include/dblayer/functions_mysqli.inc.php on line 67
Warning: my_error(): Couldn't fetch mysqli in /var/www/ourlifeinpixs/include/dblayer/functions_mysqli.inc.php on line 837
Warning: my_error(): Couldn't fetch mysqli in /var/www/ourlifeinpixs/include/dblayer/functions_mysqli.inc.php on line 837
Piwigo encountered a non recoverable error
[mysql error ]
Can't connect to server
#1 my_error /var/www/ourlifeinpixs/include/common.inc.php(128)
#2 include_once /var/www/ourlifeinpixs/index.php(26)
Server: Localhost via UNIX socket
Server type: MySQL
Server version: 5.7.24-0ubuntu0.18.04.1 - (Ubuntu)
Protocol version: 10
User: phpmyadmin@localhost
Server charset: UTF-8 Unicode (utf8)
Apache/2.4.29 (Ubuntu)
Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $
PHP extension: mysqliDocumentation curlDocumentation mbstringDocumentation
PHP version: 7.2.10-0ubuntu0.18.04.1
Piwigo v 2.9.4
can you assist
Keith
Last edited by kdmiller45 (2019-01-16 13:19:43)
Offline
#2 2019-01-16 14:53:15
- erAck
- Only trying to help
- 2015-09-06
- 2026
Re: Moving Piwigo server
Change in /var/www/ourlifeinpixs/local/config/database.inc.php the $conf['db_...'] variables to the correct new settings.
Running Piwigo at https://erack.net/gallery/
Offline
#3 2019-01-16 15:39:26
- kdmiller45
- Member
- Phoenix
- 2018-07-16
- 67
Re: Moving Piwigo server
are you able to see or imagine what Variables I need to change from what you see here, I'm not a DB person
Last edited by kdmiller45 (2019-01-16 15:40:02)
Offline
#4 2019-01-17 01:55:33
- kdmiller45
- Member
- Phoenix
- 2018-07-16
- 67
Re: Moving Piwigo server
Ok for the simpletons like me here is what I did to move my Piwigo site from one server to another
1. created new site on the new server in the /var/www/sitename and performed a sudo chmod 777
sitename
2. using phpmyadmin I exported old website sql database to local workstation
3. using phpmyadmin I created a new DB on the new location
4. copied the complete website from old location to the new (not sure if the whole site needed to be
moved, but I did.)
5. then import the old database into the new location
6. I did have to modify the database.inc.php located here /var/www/sitename/local/config/
and change this information
<?php
$conf['dblayer'] = 'mysqli';
$conf['db_base'] = 'yoursitename';
$conf['db_user'] = 'username for mysql';
$conf['db_password'] = 'Pswd that goes with username';
$conf['db_host'] = 'localhost';
6. I restarted the server and Bingo I was up and going
thanks for the help here
Keith
Last edited by kdmiller45 (2019-01-17 01:56:53)
Offline