Please help to restore data base.(solved)

Using my Dolibarr
1

Hello.
I am trying to restore backup file to new machine and entered following command
“c:\dolibarr\bin\mysql\mysql5.0.45/bin/mysql dolibarr -h localhost -P 3306 -u dolibarrmysql -pchangeme < mybackupfile.sql”
but I get a following error. “The system cannot find the file specified.”
I renamed backup file to “mybackupfile.sql” and copied to following folders “dolibarr_documents, bin/mysql, bin/mysql/mysql5.0.45”

Could you give me an advice?
Thank you.

2

Import data base with the http://localhost/phpmyadmin/

3

Mr. ndrosis.

Thank you so much for your help.
Everything is working fine and I am running on new machine.
Thank you again.

4

Hello Dolibarrs,

after a new installation of ubuntu, try to restore my database. But the message I always see is: “bash: $6: ambiguous redirect”

Here comes my command to restore the database. Note: could it be possible, that the “>”-sign inside the password disturbs the execution? But what to do then?

Command: “mysql dolibarrdebian -h localhost -u admin -p 2@cFAv/G}/Pjx>$6 < mysqldump_dolibarrdebian_3.8.0_201510280827.sql”

Thank you in advance for your support.

cheers

Ralph

5

Yes.

Enclose in “tick marks” NOT quotes !!!

Best regards

1 Like
6

Thank you for the hint with the tick marks. It worked :laugh:

Just a other hint for ubuntu/debian users to solve problems with restoring:

It exists a little program called MySQL Workbench. You don’t need to type all the code needed for restoring.

  1. open the program
  2. type your MySQL password (as root)
  3. go to Data Import/Restore
  4. select your Dolibarr databasename
  5. import the database
  6. start Dolibarr