error

[kos]

Hi ,

In SSH "Access denied user 'root'@'localhost'(userpassword:yes) " error while restore of database .

pls help

 

[DOPE]

Have you tried to use phpMyAdmin?

 

[DLow]

Which command line were you using ? did u make to to use -p for the password ?

 

[kos]

PHPMyadmin restore limit is 200mb Max ,
My database size me 2.5GB.

To restore I used this command in SSH:
mysql -u megawrzc_forum -p XXXXXXXXXX < XXXXXXXXXX.sql
And i entered my Pass

Then i got this error
ERROR 1045 (28000): Access denied for user 'xxxxxxx'@'localhost' (using password: YES)

Help me guys , thank you

 

[p2p4ever]

why not restore FROM the backup if you have one and then restore the db?

also try to find the reason out from your provider

 

[GoPantheoN]

First create a new database and give privileges to a user for the database.

Then enter this in the ssh logged in as root.

mysql -u dbusername -p databasename < backupname.sql

[B]dbusername[/B]= the user name of the new database where the sql dump is to be restored
[B]databasename [/B]= the name of the new database where the sql dump is to be restored

then enter the password of the new database where the sql dump is to be restored.

 

[c0rrupt]

Ive used this command multiple times with large databases.

mysql [I]databasename[/I] [B]-u[/B][I]dbusername[/I] [B]-p[/B][I]dbpassword[/I] < [I]pathtoyourdatabase[/I]

 

[bxflow]

PHPMyadmin restore limit is 200mb Max ,
My database size me 2.5GB.

To restore I used this command in SSH:
mysql -u megawrzc_forum -p XXXXXXXXXX < XXXXXXXXXX.sql
And i entered my Pass

Then i got this error
ERROR 1045 (28000): Access denied for user 'xxxxxxx'@'localhost' (using password: YES)

Help me guys , thank you

Note:
If your database backup resides on your home computer, you will first have to upload it via FTP to your website

Open your SSH/Telnet client and log into your website. The command line prompt you will see will vary by OS. For most hosting companies, this will bring you into the FTP root folder.

You can either change directoties to wherever the backup is located and type in the following:

mysql -u dbusername -p databasename < backupname.sql

Or if you do not want to change directories and you know the path to where the backup is located, type in the following:

mysql -u dbusername -p databasename < /path/to/backupname.sql

You will be prompted for the database password. Enter it and the database will backup.

If your hosting company has you on a remote MySQL server, such as mysql.yourhost.com, you will need to add the servername to the command line. The servername will be the same as in your config.php. The command line will be:

mysql -h servername -u dbusername -p databasename < backupname.sql

Or:

mysql -h servername -u dbusername -p databasename < /path/to/backupname.sql




So yea just use this:

mysql -u dbusername -p databasename < /path/to/backupname.sql


Make sure you have created a DB with a user and privileges in phpmyadmin then change the command to fit your db.

EX:

mysql -u yourPHPMYADMINDBusername -p YOUYRPHPMYADMINdatabasename < /path/to/THE_NAME_OF_YOUR_SQL.sql

 

[kos]

Yes i have restored Successfully , But site still not loading ...
No error on display it's simply white clean page

I have updated config.php , restored default .htaccess file
and disable all plugins via config

still site not loading

 

[ServSilla]

Tried accessing the site via Proxy? Try clearing your cache and flushing the DNS.

 

[kos]

Still Same brother ... just white page

 

[kos]

I am getting this error can any one help me

Fatal error: Call to undefined function mysql_connect() in /home/admin/XXXXXXXX/includes/class_core.php on line 314

thank you in advance

 

[NewEraCracker]

no mysql installed? Oh epic fail bro.

Check the requirements using:
https://github.com/NewEraCracker/php_work/blob/master/check_compatibility.php

 

[DOPE]

Have you tried to break it down to 500mb pieces and upload through phpMyAdmin?

 

[kos]

no mysql installed? Oh epic fail bro.

Check the requirements using:
https://github.com/NewEraCracker/php_work/blob/master/check_compatibility.php

what will happen if i execute this file bro ?

were should i place this .php file ?

thank you for help brother

 

[DOPE]

Inorder to check if mysql is already installed or not run this command
which mysql If found it will show some directory name otherwise not foun


In order to remove old mysql
yum remove mysql-server
yum remove mysql


Now to install mysql run this command from the shell or a command line access point
yum install mysql-server
yum install mysql
yum install mysql-devel


Inorder to use with php
yum install php-mysql

Read more: http://getablogger.blogspot.com/2009/05/how-to-install-mysql-in-centos-53-from.html#ixzz1XBiP8sHc
​

 

[NewEraCracker]

what will happen if i execute this file bro ?

That script will show what is missing in your php installation for scripts such as IPB or vB to work properly.

were should i place this .php file ?

You mean where :P And you should place it in the www or public_html and then access it as http://example.com/check_compatibility.php (replacing example.com with your domain)

 

[devilboy23]

Add this line to your config.php:

define('DISABLE_HOOKS', true);

Then try to access your forum.

 

[kos]

The required PHP extension "Document Object Model" could not be found. Please ask your host to install this extension. The required PHP extension "GD Library" could not be found. Please ask your host to install this extension. The required PHP extension "Multibyte String" could not be found. Please ask your host to install this extension. The required PHP extension "MySQL" could not be found. Please ask your host to install this extension. The required PHP extension "MySQLi" could not be found. Please ask your host to install this extension. The required PHP extension "cURL" was found, but function curl_exec is disabled, please ask your host to enable it! The required PHP extension "cURL" was found, but function curl_multi_exec is disabled, please ask your host to enable it! Memory Limit: 128M is required. Please ask your host to increase this setting.

This is my Output bro

 

[kos]

Add this line to your config.php:

define('DISABLE_HOOKS', true);

Then try to access your forum.

yes brother i did that already , but no luck

thanks for replay