SQL is a programming language designed for managing data in relational database management systems (RDBMS).

learn more… | top users | synonyms

0
votes
0answers
37 views

mysql INSERT limited

I am inserting data from .csv to mysql datebase using PHP but I can't INSERT more then 922 lines . Every time the number of the lines is different, usually it is 841 or 837 but after restart my mysql-...
0
votes
0answers
10 views

Cannot start sqlplus on my dell inspiron15R tried every solution on askubuntu

I have followed the tutorial given at Oracle Instant Client sqlplus: error while loading shared libraries: libclntsh.so.12.1: cannot open shared object file: No such file or directory my ...
0
votes
0answers
26 views

“Access denied for user 'root'@'localhost'” when updating vendors in a symfony app while deploying on a remote server

I am trying to deploy my symfony application on a remote amazon server. While updating the vendors using: composer install --no-dev --optimize-autoloader command this error occurs Access denied for ...
0
votes
0answers
28 views

Databases and Oracle SQL Developer

First off, I'm practically a total noob at using Ubuntu. I came across a "teach yourself SQL" book, so I decided to try to learn SQL. I managed to install the Oracle SQL Developer (thanks to this ...
0
votes
0answers
17 views

How to Selectively Populate one Table to Another

I have a table called RestaurantReviews. This contains the following columns: A, B, C, D, E, F, G, H, I, J I also have another table called Restaurant. This contains some of the columns from ...
0
votes
1answer
13 views

How do I re-enter a sqlite database that I already created?

I am using sqlite3 and created a new database in the terminal by using: sqlite3 test.db I then created some tables in this database but then I closed sqlite3. How can I re enter my test.db? Do I ...
0
votes
1answer
47 views

Why am getting this error when I try to install Emma?

I get the following error when I try to install Emma, how can I resolve this problem? Package dependencies cannot be resolved This error could be caused by required additional software packages ...
1
vote
1answer
39 views

SQL developer : connection problem

I installed Oracle SQL Developer in my Ubuntu 14.04. To set the connection, I have to use two files tnsname.ora and listener.ora. How can I find them?
3
votes
4answers
168 views

What standalone databases with GUI are available for Ubuntu?

I have googled for this information and I am simply lost. I just need a simple, standalone and a single table database with GUI. I tried Libraoffice base, but it keeps giving me an error "S1000 java....
0
votes
0answers
78 views

Has anyone try MS SQL 2016 on Ubuntu yet?

With Microsoft now supporting MS SQL on Ubuntu I want to see if anyone has try it and what was their experience. Microsoft Supporting SQL on Ubuntu https://www.microsoft.com/en-us/server-cloud/sql-...
0
votes
0answers
27 views

Ubuntu for SQL database and windows clients?

I am currently running my small business with an Ubuntu 12.04 file server which houses an MDB (access) database for our ERP software (E2 ShopTech) along with various CAD/CAM files. We need to upgrade ...
0
votes
0answers
25 views

UML class diagrams and databases

I have a database set up that includes foreign keys in different tables. I am trying to work the cardinality out but am getting confused. Can someone explain how I can work out the cardinality and ...
0
votes
1answer
148 views

Working with Nodejs + MSSQL at Ubuntu

I've my nodejs app connected to MSSQL server, worked perfectly in my Windows laptop, sing mssql@npm The same app is not able to see the database in my Ubuntu laptop. I defined the mssql connectivity ...
0
votes
0answers
73 views

Wine and SQL connected softwares

I need to run a software on wine (ubuntu 15.10) which is making connection via MS SQL on my local network. (ERP Software). I was able to run software without any issue with 1.8 wine and necessary ...
0
votes
0answers
83 views

Good alternatives to SqlDbx in Ubuntu 14.04

In my workplace we use this program for windows 8 called SqlDbx which is just great since through it I can connect to many different Dbs (oracle, microsoft sql, postgres, mysql,...) and also have good ...
0
votes
0answers
71 views

Physical Backup of Maria DB as a snapshot using LVM

I have a SQL database which I want to backup as a snapshot. I want to use LVM to do so, but I am not able to do it. Also my database is not stored in a LVM partition but its located in my /dev/sda2 ...
0
votes
1answer
91 views

mysql commands are not working properly from terminal

sir I used to access mysql through command from terminal using mysql -u root -p And after that I also put the password of mysql Now I want to show my databases using the command given below. mysql&...
0
votes
2answers
232 views

Can't import .sql files in phpmyadmin

I had exported databases from wamp and tried importing the same from phpmyadmin but it displays an error saying you probably tried uploading a file that was too large! Why? How should I solve it?
0
votes
0answers
48 views

How do I get the database files using LFTP from the remote server to the local server

I want to connect to the database of a dedicated server remotely from a Linux server and the store the SQL file onto the local Linux server. What command would I need to use, using LFTP?
1
vote
0answers
102 views

Error [IM002] on unixODBC FreeTDS

I'm trying to query a SQL Server DB using unixODBC FreeTDS and isql I'm getting the error: [IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified [ISQL]ERROR: ...
1
vote
3answers
851 views

Can't connect to MS SQL with pyodbc

I just spent hours trying to acomplish a simple task. I had python code that I used to run in windows, and it access a MS SQL db on a windows server 2008. I set up a ubuntu server and want to run this ...
1
vote
1answer
78 views

Connecting to an oracle ebs system

I am interning at a company that uses oracle's ebs that I'm supposed to connect to. Everyone else here uses windows and use toad to connect to the company's database; everyone but me that is... I use ...
0
votes
0answers
532 views

How to determine FreeTDS is working with ODBC via tsql?

Ubuntu 14.04.1 LTS is the client machine. This machine does not have a registered domain. Using Perl 5.18.2 and DBD::Pg, this machine connects just fine to a Postgresql database. I'm now trying to ...
0
votes
1answer
1k views

Where to find MSSQL ODBC driver .so file?

Ubuntu 14.04.1 LTS From my Ubuntu machine I want to access an MS SQL 2005 server via ODBC. This MSSQL server is on our internal network. I've installed these packages: unixodbc, unixodbc-dev, ...
1
vote
1answer
44 views

can we install maria db on ubuntu touch device?

can we install maria db server on ubuntu tablet(ubuntu touch) ? i'm trying to install ubuntu touch on a tablet, and i want it to act as portable sql server . is that doable with ubuntu touch
0
votes
1answer
62 views

Unable to install SQL

I am new to UNIX, Linux and Ubuntu ... I am unable to install SQL on my system I follow this link Error After Installation Type the full pathname of a JDK installation (or Ctrl-C to quit), the ...
0
votes
1answer
173 views

problem while updating backbox using sudo apt-get update

[*] starting at 19:46:20 [19:46:20] [INFO] updating sqlmap to the latest development version from the GitHub repository [19:46:20] [INFO] update in progress .. [19:46:22] [ERROR] update could not be ...
0
votes
1answer
255 views

UBUNTU/PHP: Can not connect to sql server 2008

We took a copy of our Ubuntu virtual server and changed its name and IP. In every other way it is a duplicate of our production server. Now for some reason we can't get php connection to SQL-SERVER. ...
1
vote
1answer
748 views

How to run SQL PLUS in ubuntu 14.04

I have installed SQL PLUS from instructions I got from hereSQL PLUS .. BUt now I don't know how to start whenever I start it using sqlplus64 command it asks for username and password which I don't get ...
0
votes
1answer
90 views

RealSQLDatabase file: accessing in Linux

I have *.rsd file. By googling it, I found that it is RealSQLdatabase file. I am able to view it through text editors but it seems very cumbersome. Is there another way like Database browser or ...
0
votes
1answer
1k views

What path shall I find schema.sql?

I am looking for file named "schema.sql", can someone let me know where can I find it? when I googled a little about it I go one path i.e. /etc/raddb/sql/mysql/schema.sql however it does not exists ...
0
votes
2answers
2k views

SQLSTATE[HY000] Unknown host machine name (severity 2)

I have a problem in which I can not find a solution and I was hoping that you could help me out. I rolled back my server and now none of the php scripts can now connect to other servers. The scripts ...
1
vote
1answer
635 views

PostgreSQL importing from folder

I lost my ubuntu partition (12.04) and I've installed the ubuntu 14.04, I could save my database files from postgreSQL v9.1, but now I'm with a problem how can I import this data base and my settings ...
2
votes
1answer
248 views

Charset with driver for Microsoft-SQL

I have got a form on a PHP website on an Apache on an Ubuntu-Server, to write data in a Table of a Microsoft SQL-Server. The Charset of the Website is UTF-8 and the Charset of the SQL-Server is ...
26
votes
3answers
91k views

How to install SQL Developer on Ubuntu 14.04?

I am trying to install SQL Developer on Ubuntu 14.04. I have followed some tutorials but none of them worked. So I am asking you if you know how to install SQL Developer.
1
vote
1answer
736 views

How to connect to SQL SERVER using php?

I have Microsoft SQL Server 2008 on Windows PC but my PHP is on Ubuntu, hosted by webfusion. I haven't configured anything at all but I want PHP to connect to SQL Server. What drivers do I need and ...
1
vote
1answer
22 views

Users in MySQL have too many rights

I finally found out how to install phpmyadmin and get a working internet connection in virtual box after a lot of research. Now, I addes users and gave them specific rights for testing purposes. The ...
0
votes
1answer
432 views

SQL Anywhere , Ubuntu 12.04 x86

I need to make a server in my company. IMG of my MNC has refused to provide any help on Linux systems, hence I need to do it without any help. I tried: ⠀Ubuntu 13.10 x86, SQL Anywhere(12-16) both ...
0
votes
1answer
307 views

sudo useradd wont make home directory

I have an automatic script which works, only it just never makes a home directory. The data is extracted from a database. Heres the script: $SQL -s -e "SELECT uid, password FROM registrations WHERE ...
0
votes
1answer
386 views

Retrieve data from sql into specified place in text

I'm very new to sql and bash-scripting, but even so I've manage to make a sql-table with coming events. And I manage to make a Script deleting old events and export everything in the table to a ...
8
votes
3answers
52k views

How to use SQL in terminal?

I want to create simple tables, insert values in it, and do queries. How to perform them in the terminal?
1
vote
0answers
38 views

SQLPLUS on Ubuntu 12.04 [duplicate]

I'm tryin to install sqplplus on my ubuntu machine, but it didn't really work well till now.. I've did everything in this article.. and tried "sqlplus" and gave me this error.. sqlplus: error while ...
1
vote
1answer
884 views

How to update sqlmap in Ubuntu 12.04

How to update sqlmap in Ubuntu 12.04. It's giving me problem. How do I do this?
2
votes
1answer
6k views

How to connect Ubuntu to a MS SQL server 2005?

I am using Ubuntu 13.04 and I installed Wine 1.6. I am running a dotnet application through Wine, but I am getting the following error message: An error occurred while establishing connection to ...
0
votes
1answer
78 views

Unable to run PostgreSQL 9.2 [duplicate]

I followed an instruction on how to setup Ubuntu 10.04 with PostgresSQL $ psql Or this: lucid@ubuntu:~$ sudo -u postgres psql postgres [sudo] password for lucid: psql: could not connect to server:...
2
votes
2answers
429 views

How to open VDB files under Ubuntu ?

I'm working with a software that uses VDB (VistaDB) to archive log files, while everyone else uses windows and can use the Vistadb software, I'm unable to do so using my Ubuntu OS, does anyone knows ...
1
vote
1answer
1k views

Oracle in Ubuntu [duplicate]

Can I install Oracle SQL Developer or Oracle Express Edition in Ubuntu 12.10 (32 bits) using Java 7? If not, what's the "best" SQL Integrated development environment in this platform?
1
vote
2answers
782 views

Mysql Server shuts down periodically on ubuntu

Mysql Server shuts down periodically on Ubuntu. I looked through the system log file and found the following lines in the log files i checked : Out of memory: Kill process 719 (mysqld) score 114 or ...
1
vote
1answer
4k views

Call to undefined function sqlite_open() in CLI mode

12.04 AMD 64 apt-get install sqlite php5-cli php5-sqlite php -r '$x = sqlite_open();' PHP Fatal error: Call to undefined function sqlite_open() in Command line code on line 1
0
votes
4answers
518 views

Is there a server app in Ubuntu Software Center for PHP?

I'm a beginner learning PHP. I need a server and MySQL. Is there an app in Ubuntu that I can download? I think I have installed something with PHP5 Server-side something. But when I clicked to use ...