DBS_DUMPTABDATA(1p) User Contributed Perl Documentation DBS_DUMPTABDATA(1p)NAME
dbs_dumptabdata - Creates file set with SQL table data
DESCRIPTION
dbs_dumptabdata is an utility to create a file set with SQL table data. For each table in the database dbs_dumptabdata calls the appropri-
ate dumper utility with the output directed to a file named table.sql in the current directory. dbs_dumptabdata asks for a password if nec-
essary.
COMMAND LINE PARAMETERS
Required command line parameters are the DBI driver ("Pg" for Postgres or "mysql" for MySQL) and the database name. The third parameter is
optionally and specifies the database user and/or the host where the database resides ("racke", "racke@linuxia.de" or "@linuxia.de").
COMMAND LINE OPTIONS -t TABLE[,TABLE,...], --tables=TABLE[,TABLE,...]
Comma-separated list of tables to dump.
--exclude-matching-tables=REGEXP
Excludes any table matching the regular expression REGEXP from dumping.
--use-printtab
Uses generic dump (similar to "dbs_printtab") instead of the dumper utility provided by the DBMS.
BUGS
msql is not supported.
AUTHOR
Stefan Hornburg (Racke), racke@linuxia.de
SEE ALSO perl(1), DBIx::Easy(3)perl v5.8.8 2007-02-01 DBS_DUMPTABDATA(1p)
Check Out this Related Man Page
DROP TABLE(7) SQL Commands DROP TABLE(7)NAME
DROP TABLE - remove a table
SYNOPSIS
DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DESCRIPTION
DROP TABLE removes tables from the database. Only its owner can drop a table. To empty a table of rows without destroying the table, use
DELETE [delete(7)] or TRUNCATE [truncate(7)].
DROP TABLE always removes any indexes, rules, triggers, and constraints that exist for the target table. However, to drop a table that is
referenced by a view or a foreign-key constraint of another table, CASCADE must be specified. (CASCADE will remove a dependent view
entirely, but in the foreign-key case it will only remove the foreign-key constraint, not the other table entirely.)
PARAMETERS
IF EXISTS
Do not throw an error if the table does not exist. A notice is issued in this case.
name The name (optionally schema-qualified) of the table to drop.
CASCADE
Automatically drop objects that depend on the table (such as views).
RESTRICT
Refuse to drop the table if any objects depend on it. This is the default.
EXAMPLES
To destroy two tables, films and distributors:
DROP TABLE films, distributors;
COMPATIBILITY
This command conforms to the SQL standard, except that the standard only allows one table to be dropped per command, and apart from the IF
EXISTS option, which is a PostgreSQL extension.
SEE ALSO
ALTER TABLE [alter_table(7)], CREATE TABLE [create_table(7)]
SQL - Language Statements 2010-05-14 DROP TABLE(7)
I have a utility provided by our vendor to dump data from their system. It is
expsysdb -s prod proddata.dmp
"-s" and "prod" are parameters and "proddata.dmp" is the file name that the data is dumped to (this can be any name). Our current system (AIX 4.3) has a file size limit set to 1... (7 Replies)
I want to collect the database tables(Ex: Emp,Sal,Bonus...etc)
in a file & give this file at the command prompt, when prompted for the tables list at command prompt. How can i do that ?
Ex:- Import jason/jason1 tables=emp,sal,bonus log=j1.log
i want to change this into
Ex:- Import... (3 Replies)
my database
deepak 23/12 43536
deepika 23/12 675858
my program
echo "Enter your friend's name"
read FRIEND
found=no
cat database | while read LINE
do
if ;then
candidate=$(echo $LINE | cut -d ' '... (5 Replies)
Hi all,
I was wondering, if there is any way to generate boxes/tables using perl to represent some data in better format.
input :
Name SAlary
pranav 10000
ajay 5000
shri 15000
output :
_________________________
|Name |Salary |... (3 Replies)
Hello all,
Thank you in advance for reading my post and helping me..
Scenario:
I have 50 tables whose names are in a file export.sql, i use the below command to export all these tables one by one
cat export.sql|while read tn
do
echo "export to $tn.del of del select from... (7 Replies)
can anyone help me out to write a code by connecting to the sql database and I need to print the list of tables present in the databse.
any ideas please. (1 Reply)
HI Experts,
I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into
the table.
Also i... (1 Reply)
HI Experts,
I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into
the table.
Also i... (1 Reply)
Hello,
I am newbie on mysql and trying to edit my database from terminal under linux.
What I need to do is to change the information written in a cell in table.
Let me explain what I tried:
$ mysql -u mysqluser -p
$ show databases;
$ USE catalogue;
$ show tables ;
$ select * from... (2 Replies)