(06-23-2018, 09:54 AM)youssefbasha Wrote: [ -> ]I want to backup mybb forum db but i forgot the password, can anyone help me? Thanks
Open the config.php file in the inc folder of your MyBB installation: <MyBB root>/inc/config.php
It contains the database server, database name, database username and its password.
root@vps4:/var/www/vhosts/firex-host.com/httpdocs/inc# mysqldump –u frx_1 ******* frx_1 > backup.sql
mysqldump: Got error: 1045: Access denied for user 'root' (using password: NO) when trying to connect
Please answer
There's an elephant in the room:
Quote:1045: Access denied for user 'root' (using password: NO) when trying to connect
Your mysqldump application still tries to login as MySQL root instead of the user you specified. So there must be something wrong with the command. If e.g. the password is wrong the error should look like the one below.
Command:
Code:
mysqldump -u dbuser -p'dbpasswordwrong' testdb >testdb.sql
Result:
Code:
mysqldump: Got error: 1045: Access denied for user 'dbuser'@'localhost' (using password: YES) when trying to connect
A correct password will simply create the database .sql dump without any error messages or similar.
Compare your command with mine and you will see major differences.
root@vps4:/var/www/vhosts/firex-host.com/httpdocs/inc# mysqldump -u frx_1 -p'***' frx_1 >testdb.sql
mysqldump: [Warning] Using a password on the command line interface can be insecure.
root@vps4:/var/www/vhosts/firex-host.com/httpdocs/inc#
And this is supposed to tell us what? Did it work or not? Is there a testdb.sql file in /var/www/vhosts/firex-host.com/httpdocs/inc?
The warning is just a warning and not more. Not an error. So posting this output without any comment.... You try really hard to discourage people from helping you. I see.
(06-25-2018, 08:20 PM)Hidden Refuge Wrote: [ -> ]And this is supposed to tell us what? Did it work or not? Is there a testdb.sql file in /var/www/vhosts/firex-host.com/httpdocs/inc?
The warning is just a warning and not more. Not an error. So posting this output without any comment.... You try really hard to discourage people from helping you. I see.
Ok ty
its fixed
i love u :d
I just got 1 problem while downloading the testdb.sql but i downloaded it and resetted the vps
Great to hear that it finally worked out for you.
Restoring the database can be also done easily via mysql. Just check the "Restoring your MySQL Database" section of
http://webcheatsheet.com/sql/mysql_backup_restore.php
Alternatively if you have a webserver on the VPS with PHP you can simply use phpMyAdmin to create, manage, backup and restore databases.
Thanks for help and of course thanks for report staff about thread.
/Thread has been closed & moved.
Hmm
you can close the topic now
Refuge helped me alot
Thanks all