Help with restoring from backup
-
- New Forum User
- Posts: 2
- Joined: Mon Dec 28, 2015 10:48 pm
- Location: Florida
Help with restoring from backup
I recently had an unexpected server failure (motherboard). While I waited for the new server to arrive, I temporarily used a Windows desktop as a server. I installed the latest version of MariaDB on it (10.1). The new server has now arrived so I am trying restore the latest data on it. It is running MariaDB version 5.5.44. I cannot upgrade it to 10.1. I ran mysqldump --all-databases on the temporary server. When I attempt to run the dumped sql, I am getting the error message "unknown option 'STATS_PERSISTENT'. Can someone tell me how to get around this error?
Re: Help with restoring from backup
Hello,
on the dumped .sql file search for each create table statement
at the end of each statement there should be STATS_PERSISTENT=0;
Since it may not be recognized by the new DB you safely remove it and then start restoration and see how it is proceeding
after that update this post to see if it was working for you
on the dumped .sql file search for each create table statement
at the end of each statement there should be STATS_PERSISTENT=0;
Since it may not be recognized by the new DB you safely remove it and then start restoration and see how it is proceeding
after that update this post to see if it was working for you
TreyThrasher wrote:I recently had an unexpected server failure (motherboard). While I waited for the new server to arrive, I temporarily used a Windows desktop as a server. I installed the latest version of MariaDB on it (10.1). The new server has now arrived so I am trying restore the latest data on it. It is running MariaDB version 5.5.44. I cannot upgrade it to 10.1. I ran mysqldump --all-databases on the temporary server. When I attempt to run the dumped sql, I am getting the error message "unknown option 'STATS_PERSISTENT'. Can someone tell me how to get around this error?
-
- New Forum User
- Posts: 2
- Joined: Mon Dec 28, 2015 10:48 pm
- Location: Florida
Re: Help with restoring from backup
Thank you for your help. It worked.