Questions tagged as 'mariadb'

Tagged questions
1
answer

LEMP Script for Ubuntu / Debian

Is there a script to install the entire LEMP stack in Ubuntu / Debian in the style of CentOS (Centmin Mod)?     
asked by 10.08.2016 / 17:09
0
answers

Help to replicate MSSQL in MariaDB with SymmetricDS

I am trying to configure the SymmetricDS tool to replicate a database hosted in SQL Server in a new table in MariaDB (or MySQL). I have the nodes running but the synchronization does not start because I have to create some records in the table...
asked by 03.01.2019 / 12:45
0
answers

MariaDB - Mysqld got signal 6

The mariadb service has started to fall and is now directly unable to start. The server was in operation until a few hours ago with several websites in production. My log 2018-12-18 20:12:06 140667795601600 [Note] InnoDB: PUNCH HOLE support...
asked by 18.12.2018 / 21:42
0
answers

My program does not insert data in Mariadb

import java.nio.channels.SelectableChannel; import java.sql.Connection; import java.sql.Date; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; i...
asked by 24.11.2018 / 00:14
1
answer

Array does not store the full value of my DB if it has a space

Inside my DB I have the following information: MariaDB [agenda]> select * from materia; +-----------+--------------------------------------+ | idmateria | materia | +-----------+---------------------------------...
asked by 15.11.2018 / 01:17
1
answer

Get number of rows that contain a certain value, and that value put in another table

How about? After some search in stack overflow, I could not find the solution to the next problem. I have the following table, in which there is a column where the number of postings that person has to his name in another table will hurt....
asked by 11.11.2018 / 00:34
0
answers

Help I try to create a record of an autoincrement value which is a primary key and is a foreign key

I try to enter a value register autoincrement but I get the following error    You have an error in your SQL syntax; check the manual that   corresponds to your MariaDB server version for the right syntax to use   near '"",' Jose Queza...
asked by 25.11.2018 / 23:29
1
answer

mysqldump saves views as tables

When doing a DUMP with mysqldump, the views are saved as tables: CREATE TABLE v_facturas The correct thing would be CREATE VIEW v_facturas AS ... What option should I use to prevent this problem from happening?     
asked by 30.10.2018 / 23:28
1
answer

Why does the mysql Workbench always throw me an error when I synchronize tables?

With the latest version of mysql workbench, I have only problems. I create two tables, one using an n: n relation, I synchronize it and it always ends with the same message "ERROR: Error 1064: You have an error in your SQL syntax; check the manu...
asked by 24.10.2018 / 06:08
1
answer

Stored procedure Mariadb 10.1 variable assignment

I have a stored procedure works great ... but I want to optimize it .. what I need is to declare a variable, assign that variable a value of a field in a table ... but the simple fact of making any change in that procedure throws me an error 106...
asked by 11.10.2018 / 16:34