Issue with restoring backup

edited December 4 in General Discussion
Hello there,

firstly i am grateful for Cyberpanel, it is very light and speedy, and UI is much more modern than many paid and free control panels.

have been trying for about a month now but to no avail, hence would like to seek some help here :)

Provider: Hetzner, Cloudcone etc.

System: Centos 7.5 (.1804)

Installation version: Free (non enterprise)

Installing from official server or mirror server?
Mostly official, have tried mirror as well


Replace JS/CSS files to JS Delivr?
No, have tried JS Delivr as well

Install Memcached extension for PHP?
yes

Install LiteSpeed Memcached?
yes

Install Memcached?
yes

Install Redis extension for PHP?
yes

Install Redis?
yes


MYSQL password unchanged from fresh installation


Situation:
- Exported website from another server manual by packing files and exporting database.
- Set up new website on Cyberpanel, set up (empty) database with my own password (different from password given by installer).
- copied and extracted public_html files with no problem
- imported database dump with no problem
- website running perfectly fun
- able to create backup with no problem
- shifted backup to /home/backup
- deleted website to prepare for restoration

Problem:
- Upon restoring, it says "Status: OK to Run", and while "Restoring database", it ends with [5009] error.
- Cyberpanel log file says "Could not change password for MYSQL user: *****! [restoreDatabaseBackup]"


would like to receive some guidance here.

Thanks!

Comments

  • edited December 4
    Sorry for your trouble. There is MySQL password in /etc/cyberpanel/mysqlPassword

    Can you use that and login to MySQL successfully? mysql -u root -p
  • edited December 5

    Sorry for your trouble. There is MySQL password in /etc/cyberpanel/mysqlPassword



    Can you use that and login to MySQL successfully? mysql -u root -p


    No worries, really just happy to be able to move away from (sometimes annoying) plesk and potentially work with such a lightweight and simplified control panel. In fact planning a triple redundancy remote backups with these; it would be fun to see it work :p

    Do bear with me if i may not understand everything as it took quite alot of trial and error to get here :smile:

    Yes, looks like it works:
    [[email protected] backup]# mysql -u root -p                                                                                  
    Enter password:
    Welcome to the MariaDB monitor. Commands end with ; or \g.
    Your MariaDB connection id is 363
    Server version: 10.0.37-MariaDB-wsrep MariaDB Server, wsrep_25.24.rc3fc46e

    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

    MariaDB [(none)]> exit
    Bye

    tried a few fresh installations starting from the most recently above.

    Environment 1 (which is what we are discussing now ):
    PHPmyadmin password unchanged ([email protected])
    /etc/cyberpanel/mysqlPassword unchanged
    website database password same as /etc/cyberpanel/mysqlPassword

    Observation: Backup OK, restore error [5009]
    Main Log File: Could not change password for MYSQL user: website_db! [restoreDatabaseBackup]

    Environment 2:
    PHPmyadmin password unchanged ([email protected])
    /etc/cyberpanel/mysqlPassword unchanged
    website database password different from /etc/cyberpanel/mysqlPassword

    Observation: Backup OK, restore error [5009]
    Main Log File: Could not change password for MYSQL user: website_db! [restoreDatabaseBackup]


    Environment 3:
    PHPmyadmin password changed ([email protected])
    /etc/cyberpanel/mysqlPassword changed
    website database password different from /etc/cyberpanel/mysqlPassword

    Observation: Backup error [5009] , forgot to copy log. Will try in future.
  • edited December 5
    Can you submit a ticket with login details of any such environment? Would be better if it is fresh install with steps to reproduce the problem.
  • > @CyberPanel said:
    > Can you submit a ticket with login details of any such environment? Would be better if it is fresh install with steps to reproduce the problem.

    Sure, since my current problem is on a fresh installation. Where do I submit a ticket?
  • Happy to report that issue with backup has been fully resolved few days back. Even new script installations on new VPS after are good.
Sign In or Register to comment.
Support CyberPanel CyberPanel Discord

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!