Re: [libreoffice-users] Re: [MariaDB Announce] MariaDB 5.5.30 now available

On 03/13/2013 06:55 PM, Jay Lozier wrote:
> On 03/13/2013 02:47 PM, Girvin R. Herr wrote:
> > Dan,
> > That is another issue.  It is good that you were able to get MySQL 
> > back when you needed it.  I think what I read was that Mariadb 
> > changed the database itself somehow, making it incompatible with 
> > MySQL.  Thus, all the work done on it with Mariadb was lost from the 
> > last MySQL-compatible database backup.  That is scary - lost data.
> >
> > I just went searching again for where I read this caveat and came up 
> > with this posting by "ppr:kut" to LinuxQuestions.org on 1-31-13:
> >
> >    "I'm not sure what problems you imagine, but I'm not aware of any
> >    issues. You wouldn't be able to switch easily from MariaDB back to
> >    MySQL once you start using MariaDB specific features, but that's
> >    clear from the start."
> >
> > You can find this message and others on:
> >
> > http://www.linuxquestions.org/questions/slackware-14/replace-mysql-with-mariadb-in-slackware-4175447832/ 
> >
> >
> > Now that I read it again, it sounds like they might be talking about 
> > Mariadb user features, not database compatibility.  Kind of like 
> > someone who moves from msoffice to LO can't go back because they like 
> > the LO features.  I would like to know if anyone has tried to go back 
> > to MySQL from using Mariadb and how *physically* successful it was.
> > Sorry about the confusion.
> > Girvin
> Girvin, Dan
>
> I once "updated" from MariaDB 5.5.x to MySQL 5.5.y then to MariaDB 
> 5.5.y. I use MariaDB via localhost and found that the permissions are 
> different. MariaDB default allows apps like MySQL Workbench to do bulk 
> data inserts from files while MySQL does not. With MySQL I had to use 
> the CLI version to do the inserts. I was unable to set the permissions 
> in MySQL to allow MySQL Workbench to do bulk data inserts.
>
> I am using Linux Mint Maya / 13. 64 bit. I have not yet tried the 
> MySQL Connector and Base (LO 4.0.0.3). This might be an issue between 
> the two forks.
>
> Jay
     Bulk data inserts: Are you using this to append data to a table? 
(Add the data to a table that already contains data) I am not sure I 
understand.
     I understand importing databases and their data as well as 
exporting them. Somehow I do not think that you were talking about 
importing databases or exporting them.

--Dan

--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted