store | blogs | forums | twitter | facebook | wiki | downloads | support portal
Atomic Secure Linux
It is currently Tue Aug 20, 2019 12:36 pm

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Help with restoring from backup
Unread postPosted: Mon Dec 28, 2015 11:05 pm 
Offline
New Forum User
New Forum User

Joined: Mon Dec 28, 2015 10:48 pm
Posts: 2
Location: Florida
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?


Top
 Profile  
Reply with quote  
 Post subject: Re: Help with restoring from backup
Unread postPosted: Fri Jan 01, 2016 1:01 pm 
Offline
Forum User
Forum User

Joined: Thu Dec 31, 2015 9:41 pm
Posts: 7
Location: CA
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

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?


Top
 Profile  
Reply with quote  
 Post subject: Re: Help with restoring from backup
Unread postPosted: Mon Jan 11, 2016 7:46 pm 
Offline
New Forum User
New Forum User

Joined: Mon Dec 28, 2015 10:48 pm
Posts: 2
Location: Florida
Thank you for your help. It worked.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group