- discuss - lists.mariadb.org

[Maria-discuss] New Question: Wierd tables in mysql system database
by AskMonty KB 22 Feb '16

22 Feb '16

2 1

[Maria-discuss] New Question: "WITH" clause in "SELECT" statement?
by AskMonty KB 22 Feb '16

22 Feb '16

Hello, A new question has been asked in "Data Manipulation" by roblewis. Please answer it at http://mariadb.com/kb/en/with-clause-in-select-statement/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Some SQLs (e.g., SQLite) support a "WITH" clause introducing a SELECT statement, but it appears MariaDB doesn't. Can you discuss? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/with-clause-in-select-statement/

1 0

[Maria-discuss] Is there something like "best practices" to migrate from Paradox to MariaDB?
by Hugo Wau 21 Feb '16

21 Feb '16

Hello, I am new here. I will have to migrate some hundred Paradox Databases (on as many machines) to MariaDB. The best way to do so, would be something like a script. My OSs are Linux (Debian) and Win7. Is there some kind of documentation of the experience of someone, who has migrated from Paradox to MySQL/MariaDB before? (I have googled for days, but have not found such yet.) With kind regards Hugo

5 7

[Maria-discuss] New Question: Can't run C program using mariaDB on centOS
by AskMonty KB 21 Feb '16

21 Feb '16

Hello, A new question has been asked in "MariaDB FAQ" by grvsngh929. Please answer it at http://mariadb.com/kb/en/cant-run-c-program-using-mariadb-on-centos/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- here is link to my question (still unanswered): http://stackoverflow.com/questions/35531782/cant-run-c-program-using-mariad… -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/cant-run-c-program-using-mariadb-on-centos/

1 0

[Maria-discuss] New Question: Can't run C program using mariaDB on centOS
by AskMonty KB 21 Feb '16

21 Feb '16

Hello, A new question has been asked in "MariaDB FAQ" by grvsngh929. Please answer it at http://mariadb.com/kb/en/cant-run-c-program-using-mariadb-on-centos/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- here is link to my question (still unanswered): http://stackoverflow.com/questions/35531782/cant-run-c-program-using-mariad… -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/cant-run-c-program-using-mariadb-on-centos/

1 0

[Maria-discuss] MariaDB 10.0.24 now available
by Daniel Bartholomew 19 Feb '16

19 Feb '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.24. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.24 - Release Notes: https://mariadb.com/kb/en/mdb-10024-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10024-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.0.24 About MariaDB 10.0: - https://mariadb.com/kb/en/what-is-mariadb-100/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] New Question: Upgrading MariaDB 10.0.20 to 10.1.11 with bi-directional master-slave replication
by AskMonty KB 18 Feb '16

18 Feb '16

Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by aferrett. Please answer it at http://mariadb.com/kb/en/upgrading-mariadb-10020-to-10111-with-bi-direction… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have two Maria DB instances running 10.0.20 on RHEL. Each is database is a slave with the other database as a master. Is there a procedure documented to upgrade these to 10.1.11? I just need to know the steps associated with the replication. I've already tested the upgrade of a single instance without replication. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/upgrading-mariadb-10020-to-10111-with-bi-direction…

1 0

[Maria-discuss] New Question: Migrating mysql 5.5.19 to mariadb with encryption
by AskMonty KB 18 Feb '16

18 Feb '16

Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by Christine.Ross. Please answer it at http://mariadb.com/kb/en/migrating-mysql-5519-to-mariadb-with-encryption/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I am currently running mysql 5.5.19 64bit, Innodb, on Sparc Solaris and looking to move to mariadb on linux. Our ultimate goal is to have encrypted data-at-rest. I have 2 questions please. 1) So from my research I see I should be able to install mariadb 10.0 and run mysql_upgrade. Since the database exists already, do you just specify the location of the database when you install and it will upgrade it to mysqldb 10.0 when I run mysql_upgrade? 2) To achieve encryption, do I just install 10.1.4 on the same machine and run mysql_upgrade after making the changes to my.cnf. I know there are other my.cnf options but will this encrypt all the tables and logs? Does it do system tables please? [mysqld] plugin-load-add=file_key_management.so file-key-management file-key-management-filename = /mount/usb1/keys.txt innodb-encrypt-tables innodb-encrypt-log innodb-encryption-threads=4 I have just started to research so I appreciate the help. Christine -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/migrating-mysql-5519-to-mariadb-with-encryption/

1 0

[Maria-discuss] New Question: Access + MariaDB connector problem
by AskMonty KB 18 Feb '16

18 Feb '16

Hello, A new question has been asked in "MariaDB Community" by a.mesquita_37041. Please answer it at http://mariadb.com/kb/en/access-mariadb-connector-problem/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi everyone, I have an issue while executing a query with an ORDER BY on a table linked through a MariaDB ODBC connector to a MS ACCESS 2013 database. I use the 1.0.5 version of MariaDB ODBC connector and the 10.1.1 version of MariaDB (I don’t want to use a MySQL ODBC connector). If I try only with a SELECT * it works but from the moment I use the ORDER BY Access freezes for a while and then stops running. The UPDATE queries work fine. Any help would be much appreciated, Aurélien MESQUITA. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/access-mariadb-connector-problem/

1 0

[Maria-discuss] Google Summer of Code 2016
by Colin Charles 18 Feb '16

18 Feb '16

Hi! Its that time of year again and I believe that we plan to participate in Google Summer of Code 2016 again (we did so in 2013, 2014, and 2015). We are of course waiting to get accepted (we will know on Feb 29 2016) but that should not stop you, a *potential mentor* from adding your idea to the idea’s list page: https://mariadb.com/kb/en/mariadb/google-summer-of-code-2016/ Potential mentors should also see if there are Jira tasks they’d like completed: https://mariadb.atlassian.net/issues/?jql=labels%3Dgsoc16 (add more by adding the gsoc16 label) *Students* — please note that we have *not* been accepted *yet*, so asking us if you can do a project now is not necessarily useful (once we are accepted, then yes, please propose your interest) Here’s to Google Summer of Code 2016! cheers, -colin -- Colin Charles, http://bytebot.net/blog/ twitter: @bytebot | skype: colincharles "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

1 0