I cant made database restore

When I make database restore every time is problem

How are you restoring? The method that has always worked for me is: create a dump, create ab empty db and use source sqlfile.sql. Please explore this

It may help to say what version ERPNext, how it was installed and why the command is being issued as the root user.

~$ sudo /etc/init.d/mysql stop
~$ sudo mysqld_safe --skip-grant-tables &
~$ mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 1 to server version: 4.1.15-Debian_1-log

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.


mysql> use mysql;

mysql> update user set password=PASSWORD(“root”) where User=‘root’;

mysql> flush privileges;

Hi all