Hi There
I have a few databases on my OMV using mysql. I was trying to make a backup using mysqldump but i can´t.
So, the simple command is this one
mysqldump wordpress > /tmp/wordpress.sql
But when i do that it put me on a Arrow sign like this one
->
And i cant do anything else. I check the command and in everywhere it shows like this one.
Can anyone help me, what i´m doing wrong?
Best Regards to everyone.
Try mysqldump -u root -p wordpress > wordpress.sql
Not working neither
Arrow again ->
Can anyone try it please?
What is the output of: mysql -u root -p
The output is:
Asks for password and enter in mysql
Well, that is right. What is the output of the following:
ls -al /usr/bin/mysqldump
mysqldump
the output is:
-rwxr-xr-x 1 root root 3450312 Jan 27 12:12 /usr/bin/mysqldump
What about executing mysqldump without any flags or commands?
Ok
Executing mysqldump without anything is gives me the arrow sign straight away
->
There is something corrupt with that binary then. What kind of media is OMV installed on?
SSD drive. Mor a usb drive
If the flashmemory isn't installed, I'm guessing it is failing. It might be failing even if it is installed and wasn't a new drive. If that is the case, you need a new drive and a fresh install.
So what i did upgrade the OMV to version 2.0 and try again. Same error.
What are your output when running mysqldump?
Can I reinstall the Mysql plugin does it resolve?
I don't think my drive is failing because all other thinks are ok.
Here is the output of mysqldump:
$ mysqldump
Usage: mysqldump [OPTIONS] database [tables]
OR mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
OR mysqldump [OPTIONS] --all-databases [OPTIONS]
For more options, use mysqldump --helpI think you missed something from my previous comment. I seriously think your usb device is failing. There is nothing you can do to fix it. You need a new one and reinstall OMV and plugins. They fail slowly and can affect one thing at a time but what do I know...
Sorry but I think I explained my self wrong, this is not an Ian device this is a SSD hard drive connected to a sata port, it's an internal hard drive
Thanks everyone that reply to my thread. Especially to ryecoaaron that helped me a lot.
I´ve resolved the problem, removing MySQL plugin and reinstall it.
Now I´ve mysqldump fully operational.
Best regards and thank you
You can try reinstalling mysql but I still think something is wrong with the media even if it is an ssd.
apt-get install --reinstall mysql-server
Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!