The command-line tag has no wiki summary.
38
votes
7answers
68k views
How do I list all databases and tables using psql?
I am trying to learn PostgreSQL administration and have started learning how to use the psql command line tool.
When I log in with psql --username=postgres, how do I list all databases and tables?
I ...
6
votes
4answers
11k views
How can I unload Oracle database tables into a csv files?
I need to retrieve certain data from an Oracle 11g release 1 database and provide it as one or more CSV files. The data resides in multiple tables and/or views. All this should work via the command ...
4
votes
1answer
326 views
How, if possible, can an .sql file be executed against an oracle database from a bash script
Is it possible to execute an sql file (a text file containing several SQL statements) against an oracle database from a bash shell command line (e.g. no graphical GUI and no interactive clients)
...
4
votes
1answer
1k views
Unattended install of SQL Server 2008 R2 cluster fails with error - “Illegal characters in path.”
I am trying to build an .ini file for unattended installations of SQL Server 2008 R2. I followed this blog post to build an initial .ini file: ...
3
votes
1answer
2k views
Pg install: “The database cluster initialisation failed”
(Note: This question has been compeltely rewritten from its original form, so it reflects the actual problem and will help others find a solution to the same issue).
I still haven't been able to ...
2
votes
2answers
61 views
Changing PostgreSQL port using command line
My PostgreSQL default port is 5432, I want to change default port by using command line (in Windows 7).
I saw this solution before: http://stackoverflow.com/questions/187438/want-to-change-pgsql-port
...
2
votes
3answers
485 views
Script Contents of SQL Server Database From a Batch File
I want to be able to script the schema of a given database into a .sql file from the Windows command prompt. Basically, I want to execute the "Generate Scripts" feature of Management Studio ...
2
votes
3answers
420 views
Test MySQL credentials from Linux command line?
How do you test MySQL credentials from the command line on a Linux server?
2
votes
1answer
292 views
How can you output UPDATE / INSERT query results when using MySQL -e,--execute?
When using MySQL to run an UPDATE or INSERT, I get query result info:
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
When using MySQL from the command line (eg: mysql ...
2
votes
1answer
265 views
PostgreSQL: Change default port used by utilites like psql, createdb, etc
I have 2 instances of PostgreSQL running on some servers. One on the default port (5432) and the other instance on port 5433. Some users (and processes) only need access to the second instance (5433) ...
2
votes
1answer
401 views
Oracle SQL Loader - load file where record is composed of “n” delimiters
How would you write a control file for Oracle SQL Loader that treats each record as being composed of 3 commas?
I have read the documentation, however I cannot find how to handle this scenario, ...
1
vote
1answer
37 views
Phantom Table in MySQL
Programmer here, be gentle.
I'm working in a MySQL database with only a single table, as shown by show tables:
mysql> show tables;
+----------------------+
| Tables_in_widget_web |
...
1
vote
1answer
92 views
mysql: show which users have permissions to a DB
Is there a way to show all users that have permissions on a database?
I'm looking for something like:
> show_permissions_for_db <DB>;
+----------+----------------------+
| User | ...
1
vote
2answers
2k views
How do you encrypt data while performing a mysqldump?
My OS is windows 7.
How can I encrypt data while performing a mysqldump?
From the command prompt, can I take a mysqldump with encrypted varchar and texts values?
Please help me.
Thanks
1
vote
1answer
82 views
How export a database based in a primary key of a table?
So, I'm trying to export all the DB structure of my MySQL db.
Attached is my DB structure, I have more then this, but I want these tables only.
Basically Tools relate to Factsheets and Factsheets ...
1
vote
1answer
179 views
Mysql 5.1.X How to upload data from dump file without the partitioning commands?
I need to upload data from a dump file (large one) that includes partitioning info into a database that doesn't support partitioning.
How can I tell the mysql command line to ignore the partitioning ...
1
vote
0answers
64 views
sql server install by command line
I am using following command line to install sql server 2008 r2 but its not installing.Also i am not getting any error or log in summary.txt
"D:\SQLEXPR32_x86_ENU (1).exe" /q /ACTION=
Install ...
0
votes
1answer
67 views
Using postgres with the command line without pgAdmin
I started working with PostgreSQL and till now I only had issues with it ( pgAdmin3 issues the most ) now I work a lot with MySQL and sometimes on the command line by just doing
mysql -u ... -h ...
0
votes
1answer
367 views
MySql command line cyrillic Iinsert result is corrupted
Have putty connection.
Putty config : window-->translation-->remote character set-->utf-8
Launch command line MySQL client.
Perform insert with cyrillic like:
CREATE TABLE `category` (
`catName` ...
