Problems activating your account? Send notification email to: admin@post4vps.com
Host4Fun Budget VPS Hosting

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
apt-get update and apt-get upgrade problem
#21
(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.

[Image: JPlgmNw.png]
Kind regards
Hidden Refuge
#22
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'@'localhost' (using password: NO) when trying to connect

Please answer
Gimme +rep Heart
[Image: img.php?userid=496]
Thanks For Post4VPS and Bladenode for the amazing VPS 6
#23
There's an elephant in the room:
Quote:1045: Access denied for user 'root'@'localhost' (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:
mysqldump -u dbuser -p'dbpasswordwrong' testdb >testdb.sql

Result:
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.
Kind regards
Hidden Refuge
#24
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#
Gimme +rep Heart
[Image: img.php?userid=496]
Thanks For Post4VPS and Bladenode for the amazing VPS 6
#25
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.
Kind regards
Hidden Refuge
#26
(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 Heart its fixed Smile
i love u :d
I just got 1 problem while downloading the testdb.sql but i downloaded it and resetted the vps
Gimme +rep Heart
[Image: img.php?userid=496]
Thanks For Post4VPS and Bladenode for the amazing VPS 6
#27
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.
Kind regards
Hidden Refuge
#28
@Hidden Refuge Thanks for help and of course thanks for report staff about thread.

/Thread has been closed & moved.
Best Regards
Support Team of Post4VPS.

Terminal
Thanks to VirMach for Sponsorship and Thanks Post4VPS for providing me a great VPS: 9
#29
Hmm @arsalahmed786 you can close the topic now
@Hidden Refuge helped me alot Smile
Thanks all
Gimme +rep Heart
[Image: img.php?userid=496]
Thanks For Post4VPS and Bladenode for the amazing VPS 6
 


Possibly Related Threads...
Thread Author Replies Views Last Post
  Problem installing some packages hamed 6 85 10-14-2019, 01:31 PM
Last Post: hamed
  Port Forwarding Problem - Public port to Private Port chanalku91 10 193 09-17-2019, 04:56 PM
Last Post: Hidden Refuge
  iptables problem solving chanalku91 8 263 07-28-2019, 03:51 AM
Last Post: deanhills
  direct admin login problem hamed 6 206 07-21-2019, 10:21 AM
Last Post: hamed
  Some packages problem Debian Rehan 11 384 07-06-2019, 08:32 AM
Last Post: arsalahmed786

Forum Jump:


Users browsing this thread: 1 Guest(s)

Sponsors: VirMach - Host4Fun - CubeData - Evolution-Host - HostDare - SSDBlaze - VPSlices - Abc-Hosters - Hyper Expert - Shadow Hosting - Bladenode - HostDoc - Hostlease


About Post4VPS

Post4VPS is a forum/destiny where you can Delploy Your Free VPSs just by the Power of Posts.

We Provide VPSs of many locations like Germany,US,Canada,France,London,etc.

We also Provide VPSs of Both Linux and Windows OS.